Form Objects and PHP

Screamin4q

I'm building and administration page for a friends web site. This will be to take the tasks of updating the DB awway from me. I have made this page exactly like hte original page except intsead of all the content being shown in frames and static HTML, it's in input objects, textboxes and what not. This all looks fine, and completely editable, except getting the newly edited content back into the DB.

I was origianlly thinking of putting the id to each record in an attribute for each input object and then just re-inserting them, but it doesn't seem that simple now. Any suggestions? :o

dalecosp

Write a form handling script in PHP to do the inserts for ya ... that's what this language does best....

HTH,

Screamin4q

I understand how to get the data back into the DB, but it's a matter of getting the data from the multiple textboxes that I don't get. I have a loop placing all the records into textboxes so they can be edited. How will I get the correct data back into the correct records? I placed the record 'id' in each textbox, but I don't get how to iterate through the textboxes, pulling the info and id from them.

dalecosp

Show some code...

Weedpacket

Give the form fields the same name as the database field. Then, when you're going through the $_POST array it's obvious which form field goes with which database field. Throw in a couple of other type="hidden" form fields to contain stuff that doesn't need or shouldn't be edited (database record ID, for example).

If you're displaying multiple records at once, name the fields as something like "title[<?php echo $id?>]", "body[<?php echo $id?>]" where $id of course is the ID# of that record. $POST['title'] is then an array of all the titles listed, with $POST['title'][54] being the title of record#54.

An alternative to the previous paragraph is to give each record its own form. You can only update one record at a time this way, but it means a lot less data to upload and a lot less processing at the other end. And you can go back to using a hidden form field to store the record ID.

Screamin4q

$ctr=0;

foreach($id as $myId) {


if($club[ctr] == "" && $date[ctr] == "") {


    $sql="DELETE FROM shows WHERE id = $myId";
} else {

    $sql="UPDATE shows SET club = '$club[ctr]', date = '$date [ctr]' WHERE id = $myId";
}
$ctr++;
}

This is assuming that I made an array for the textboxes, and id is a hidden field array containing all the ids for all the data in the text arrays.

Screamin4q

The above code worked fine, well some alterations had to be made. Now that I got the queries to submit, I need the page to refresh to reflect the new data. I will start a new thread on this if I don't hear anything by tomorrow. Thanks everyone. -Rocky

jayant

just output

<html>
<head>
<meta http-equiv="Refresh" content="5;http://URI/to/the/page">
</head>
<body>
Update done...
redirecting in 5 seconds
</body>
</html>