loop for a bunch of UPDATE s at once

Anon

I have created a schedule function that creates a bunch of form elements on the fly, one for each date in the schedule. I want the user to be able to edit all of the schedule at one, then UPDATE all of the info when the form is submited. The trouble I am running into is the construction of the loop to insert all of the form data into the database. I have se the form generation script up so each form element keeps a master name and is appended with a number (examples: event1, event2, etc.). I need to set up a loop (I have been working with a do while) that can UPDATE the database with all of the different events at once.

Does anyone have any idea how to do this? My forehead is getting bloody from banging it on my desk!

majik-sheff

Post your relevant PHP and HTML please.

zhabala

Hi,
I think I have solved similar situation:

foreach ( $HTTP_POST_VARS as $var ) { // go through all posted vars
if ( substr($var,0,4)=='chkb') { // testing whether starting part of name of var is equal to something
$mkey = substr($var,4,strlen($var)-4); // if yes, then the rest of var name is key to my table
}
}

Anon

This is my code as it stands. What I am having trouble with is refering to the form name correctly, as I need to concatenate the current number in the loop to the variable name, then grab the data stored in that variable. I feel I am dangerously close here, but not quite solving it.

Thanks for any help!!

$i = 1;
do
{
$sql = "UPDATE $prefix"._schedule." SET event_type='$event_type.$i', event_date='$event_date.$i', week='$week.$i', event='$event_input', date_posted='$date_posted' WHERE id=$i";
$result = mysql_query($sql) or die("There was a problem inserting the information into the database");
$i = $i + 1;;
}
while ($i <= $num_events);

zhabala

I see, you may probably use following trick:

$i = 1; // current loop
$a1 = 'Test'; // tested variable
echo "$a1<BR>"; // only for test
$x = "a".$i; // variable name created as base name concatenated with loop number
echo "$x = ".$$x; // content of variable printed (main point is $$x )

May be that there is another simpliest way.

Zdenek