Re: Dynamic Form 'on The Fly'

From: Date: Fri, 20 Mar 2009 18:03:07 +0000
Subject: Re: Dynamic Form 'on The Fly'
References: 1 2 3 4 5  Groups: php.general 
Request: Send a blank email to php-general+get-290406@lists.php.net to get a copy of this message
tedd wrote: [snip]
No problem here -- I'm open to all languages. The OP posted his question on a php list and that's the reason why I responded with a php solution. Now, can you show me how to pull data from a mysql database so that the input statements can be created dynamically? Cheers, tedd
Sure, On the WebDNA side, it's something like this (form of "names" from a database): ----------start [SQLConnect dbType=MySQL&host=192.168.1.1&database=TestNames&uid=sa&pwd=pass&conn_var=conn1] [/SQLConnect] [SQLExecute conn_ref=conn1&result_var=rs1] select firstName from employees; [/SQLExecute] <form ..> [SQLResult result_ref=rs1] [!] ** Loop through the results of the query ** [/!] [FoundItems]
    FirstName [index]:
    <input name="fname_[index]" value="[firstName]"><br>
[/FoundItems] [/SQLResult] <input type="submit" value="submit"> </form> ----------end However, like you said, this a PHP list, so I'd better refrain from any more WebDNA related posts for a while! ;-) I don't want to upset the powers that be. Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o D. BROOKE EUCA Design Center WebDNA Software Corp. WEB:> http://www.euca.us | http://www.webdna.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o

« previous php.general (#290406) next »