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:

Помог ли вам данный ответ?

 Распечатать статью

Также читают

Disk IO performance

Posted by diskio, 03-26-2008, 08:03 PMFrom the Disk I/O performance is it better 1) to have main...

WHM to point site to home server

Posted by kiwami, 05-04-2007, 12:19 PMwhats up fellers, i'm attempting to point my design site...

PERM_FAILURE: SMTP Error (state 14)

Posted by Fahd, 03-29-2008, 05:42 PMMy mailserver has stopped accepting mail from all non-local...

Set up file that will be called up in cron

Posted by ninak, 03-09-2010, 10:10 AMI am kind of embarrassed asking this question but I hope...

adultvideoscript dispute

Posted by jo2jo, 03-05-2010, 08:46 PMPlease beware. quick over view, the site says Instant...