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:

Bu mövzu kifayət qədər köməkçi oldu mu?

 Çap

Digər Başlıqlar

kernel exploit!

Posted by tkanaco, 06-27-2008, 11:27 PMHow Can i translate An Kernel Exploit to secure my server...

apf and iptables

Posted by smrtalex, 01-11-2008, 02:12 AMDoes the iptables service need to be running in order for...

Question on array sorting in php

Posted by computerwiz3491, 01-17-2008, 05:10 PMI have the following array that I printed using...

ColocateUSA Announces Acquisition of CPC Technologies, LLC

Posted by RayWomack, 05-28-2010, 04:34 PM ColocateUSA Announces Acquisition of CPC...

Trojan detected on initial load of site

Posted by geekie246, 01-08-2008, 02:10 PMHi. I have 2 reseller accounts with one provider, and...