Platon Technologies
neprihlásený Prihlásiť Registrácia
SlovakEnglish
open source software development oslavujeme 10 rokov vývoja otvoreného softvéru! Streda, 29. jún 2022
O nás
Magazín
Otvorený softvér
CVS
Služby
Index  »  Projekty  »  phpMyEdit  »  Fórum  »  Howto Display lookup, Open URL with database value?

phpMyEdit General     Howto Display lookup, Open URL with database value?
Odoslať novú tému   Odpovedať na tému   Choď na stránku 1, 2, 3  Ďalší  
 
rumex     Založený: 27.10.2017   Príspevky: 7  
Príspevok Zaslal: 2017-10-27 13:40
Návrat hore  Odpovedať s citátom     

Hi Doug

I want to click a record and open a different form. The different form will filter by a value from the row.

I am not able to add to the URL a value from the table when I have performed a lookup from a different table. I want the foreign key 'AgencyId' and not the 'name' of the agency. Can you help?

---
I have two mysql tables:
agent has ID, name, AgencyID fields
agency has ID, name

I want to open a form showing all agents. Click an agent and have the agency form open, filtered by AgencyId.



/****
*** NAVIGATION from agent form to agency form ***
*** I want this to open the form and for the ***
*** form to only display this agency. ***
*** The database table key is AgencyId ***
****/
$opts['fdd']['AgencyId'] = array(
'name' => 'Agency',
// *** The lookup and the display are different here.
'values' => array('table' => 'agency', 'column' => 'id', 'description' => 'name'),
'URL' => 'http://localhost:81/html/agenter/agency.php?agencyId=$value',
'select' => 'T',
'maxlen' => 11,
'sort' => true
);

 
doug     Založený: 10.02.2003   Príspevky: 1013   Bydlisko: Denver, Colorado (USA)
Príspevok Zaslal: 2017-10-27 18:46
Návrat hore  Odpovedať s citátom     

I don't know, not functioning well today, see some examples.
https://www.phpvs.com/xmfg/txt/lookups.txt

 
doug     Založený: 10.02.2003   Príspevky: 1013   Bydlisko: Denver, Colorado (USA)
Príspevok Zaslal: 2017-10-29 01:58
Návrat hore  Odpovedať s citátom     

Skip the URL option and use CONCAT to create the link. Search the forum for CONCAT examples, the example below is what I had nearby and perhaps it will give you an idea.

$opts['fdd']['dummy2'] = array (
'name' => 'Thumbnail',
'sql|VLF' => 'if(category = "other",
CONCAT("<a href=\"", dir, "/", filename, "\" target=\"_blank\">link</a>"),
if(category = "thumb", CONCAT("<a rel=\"example_group\" href=\"", REPLACE(dir, "/tn", "/"), filename, "\" target=\"_blank\"><img src=\"", dir, "/", filename, "\" ", " alt=\"\" border=\"0\"></a><br><a href=\"fancybox.change.php?upld_id=", upld_id, "\">Replace</a>"), ""))',
'options' => 'VLF',
'input' => 'R',
'escape' => false,
'sort' => false
);


$opts['fdd']['logon_url'] = array(
'default' => '',
'input' => '',
'maxlen' => 255,
'name' => 'Logon URL',
'options' => 'XACPVD',
'required' => false,
'select' => 'T',
'size|ACP' => 60,
'sqlw' => 'TRIM("$val_as")',
'tab|ACPV' => 'LOGON URL',
'sort' => true,
'escape' => false,
'sql|LFV' => 'if(logon_url > "", CONCAT("<a href=\"", logon_url, "\" target=\"_blank\"", " title=\"", logon_url ,"\"", ">Go There</a>"), "")'
);

 
doug     Založený: 10.02.2003   Príspevky: 1013   Bydlisko: Denver, Colorado (USA)
Príspevok Zaslal: 2017-10-29 02:06
Návrat hore  Odpovedať s citátom     

'sql|LFV' => 'if(AgencyId > "0", CONCAT("<a href=\"otherPage.php?agencyID=", AgencyId, "\" target=\"_blank\"", " title=\"", AgencyId ,"\"", ">AgencyId</a>"), "")'

 
rumex     Založený: 27.10.2017   Príspevky: 7  
Príspevok Zaslal: 2017-11-07 15:49
Návrat hore  Odpovedať s citátom     

Thanks, I put those together and got the following working

$opts['fdd']['NavParent'] = array (
'name' => 'GO',
//_self - open over current page
'sql|LFV' => 'if(AgencyId > "0", CONCAT("<a href=\"agency.php?agencyId=", AgencyId, "\" target=\"_self\"", " title=\"", AgencyId ,"\"", ">GO</a>"), "")',
'options' => 'L', // only visible on list
'input' => 'R', // no sql write
'escape' => false,
'sort' => false
);

 
jognahartu     Založený: 06.12.2021   Príspevky: 1214  
Príspevok Zaslal: 2022-01-24 15:25
Návrat hore  Odpovedať s citátom     

I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. &#53664;&#53664;&#52964;&#48036;&#45768;&#54000;

 
richard68stewart     Založený: 24.01.2022   Príspevky: 1  
Príspevok Zaslal: 2022-01-24 16:58
Návrat hore  Odpovedať s citátom     

Pro Evolution Soccer Crack is no exception. An attempt has been made to close the gap with its competition "EA Sports FIFA," however it falls far short in terms of depth and variety. Those who prefer the gameplay of "PES "can still find it good enough to compensate for the missing areas.
https://connectcrack.com/pro-evolution-soccer-crack-latest-version-download/

 
AliAhern     Založený: 09.10.2020   Príspevky: 4  
Príspevok Zaslal: 2022-01-31 08:41
Návrat hore  Odpovedať s citátom     

Truly, the significance of this entryway is without a doubt and fine art in this entryway is so mind blowing. I for one analyze this entryway and work of art which is looking a lot of great and also check essay writing service reviews to manage the task. Much obliged to you for sharing this brilliant and astonishing data.

 
Holly Lewis     Založený: 02.09.2021   Príspevky: 785  
Príspevok Zaslal: 2022-02-16 08:50
Návrat hore  Odpovedať s citátom     

This article was written by a real thinking writer. I agree many of the with the solid points made by the writer. I&#8217;ll be back. resurfacing machines

 
Holly Lewis     Založený: 02.09.2021   Príspevky: 785  
Príspevok Zaslal: 2022-02-23 18:50
Návrat hore  Odpovedať s citátom     

I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work... slotxo &#3648;&#3623;&#3655;&#3610;&#3605;&#3619;&#3591;

 
Holly Lewis     Založený: 02.09.2021   Príspevky: 785  
Príspevok Zaslal: 2022-02-24 19:52
Návrat hore  Odpovedať s citátom     

Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. Telephonic Interpretation Services

 
techsquad2     Založený: 08.04.2021   Príspevky: 50  
Príspevok Zaslal: 2022-02-25 08:18
Návrat hore  Odpovedať s citátom     

Log into your account and block Malwarebytes popups easily. You need to find the popups notification option under the general setting tab in your Malwarebytes account.

 
Holly Lewis     Založený: 02.09.2021   Príspevky: 785  
Príspevok Zaslal: 2022-02-26 20:08
Návrat hore  Odpovedať s citátom     

This type of message always inspiring and I prefer to read quality content, so happy to find good place to many here in the post, the writing is just great, thanks for the post. practice karambit

 
Holly Lewis     Založený: 02.09.2021   Príspevky: 785  
Príspevok Zaslal: 2022-03-03 21:17
Návrat hore  Odpovedať s citátom     

Wow, excellent post. I'd like to draft like this too - taking time and real hard work to make a great article. This post has encouraged me to write some posts that I am going to write soon. Groothandel in verpakkingsmaterialen

 
Holly Lewis     Založený: 02.09.2021   Príspevky: 785  
Príspevok Zaslal: 2022-03-07 19:51
Návrat hore  Odpovedať s citátom     

Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It&#8217;s always nice when you can not only be informed, but also entertained! elo boost wild rift

 
Odoslať novú tému   Odpovedať na tému   Choď na stránku 1, 2, 3  Ďalší  

Copyright © 2002-2006 Platon Group
Stránka používa redakčný systém Metafox
Na začiatok · Odkazový formulár · Prihláška
Upozorniť na chybu na PLATON.SK webstránke · Podmienky použitia · Ochrana osobných údajov