Use a SELECT query to get the values (SELECT * FROM table) and a table that has form
input fields in the cells. The values for the form fields would be based on the array
you get from the SELECT query. The form could be something like <form
action="<?=$PHP_SELF ?>" method="post">. In the script, before the body, you would
have an if statement to check whether the submit button for the form is set; if it is
set, it will run an INSERT INTO query:
if (isset ($submit)) {
$query = "INSERT INTO . . . ";
$query_result = @mysql_query ($query);
}
If the form is submitted, then the values in all the form fields (including any
changes) will go into the database. If it's not submitted, the current values will be
displayed in the tabled-embedded form. Actually, I think if the form is submitted, it
will redisplay with the new values as defaults.
Hopefully this will work, or lead you in the right direction.
-----Original Message-----
From: Robert Sossomon <[EMAIL PROTECTED]>
Sent: Jun 3, 2004 6:23 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Bulk table updates
I am looking for a tutorial or a already created class or file that I can
use to learn how to create a form that is populated from a database table
that can be edited in every row and column and takes only 1 SAVE button to
upload all the changes.
Thanks,
Robert
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
