multi line edit with php and mysql

Posted by recklessop, 01-15-2008, 09:54 PM
Does anyone know of an example of a php mysql script. basically i want to be able to display multiple variables and edit them then click a single save button and have the script update the database database structure for the example is varchar name varchar value one row might be : name = taxrate value = .07 what i want is a script that will display all rows into a table and have input boxes for the values (i can get it to display) but im not sure how to pass the values in the form to the action script.. probably an array but not sure

Posted by Barti1987, 01-15-2008, 11:31 PM
A script like this would run for $15-$25 dollars. Try looking for a freelancer. Peace,

Posted by Czaries, 01-15-2008, 11:51 PM
You can just select all the records from the database and iterate over them to display a bunch of text boxes to edit them in. When you pass them back on a POST to save them, you will want your form fields to look something like this: And that will pass an array to the PHP script and you can do: Or better yet use PDO to prepare the SQL statement before the loop, and then just execute it multiple times with the execute() function inside the loop.

Posted by recklessop, 01-16-2008, 10:44 AM
QUOTE=Czaries;4907765]QUOTE] I understand all that except the ? $_POST... : NULL; what does the ? and the : NULL do? Thanks alot for the help

Posted by Czaries, 01-16-2008, 03:49 PM
It's basically a contracted IF-ELSE statement. That one-liner is equal to this:

Hasznosnak találta ezt a választ?

 Kinyomtatja ezt a cikket

Olvassa el is

max_allowed_packet error

Posted by vnsg, 09-15-2007, 12:39 AMOne of my client use VBB 3.6.7 and have error when try to...

yum broken

Posted by chielsen, 12-18-2007, 02:20 PMI have waisted all not trying to get subversion working...

sshd has failed, please contact the sysadmin

Posted by X-x-X, 01-23-2007, 12:31 PMi have problem in SSH if i want to restart it its say :...

sdb instead of sda -> Help needed

Posted by CoolMike, 07-17-2007, 03:23 AMHi I have a server with a raid5 configuration. Linux...

JaguarPC reselling program?

Posted by Snoopy, 09-28-2001, 11:22 PMHi, I am looking for a good reseller program....