Updating multiple records after a query

Wabin

So I have a script which generates a table of results from a query (with multiple results and all of that). Each of those results has a comments column, which I would like to make editable. I have no problem with creating a text field and putting the current comments in that, but I am not sure how to pass all of the comments (if more than one was editted on the page) to the next script, while keeping the info about the record with which they were associated.

I also want to do a similar thing with popup menus for each record, but if I get one working, I figure the other will be easy to figure out.

Thanks in advance.

johnnyv

use forms and the hidden input type to pass along the record values

<?php
echo "<input type=hidden value=\"$phpvalue1\" name=record1>";
echo "<input type=text name=\"user_input1\">";
?>

get the idea?

Wabin

Okay, so that will work, of course, but it doesn't really get me all the way there. The issue I am having is that when the second page gets the script, I want it to be able to parse through all of the sent values easily, where there could be values for up to 100 records. I want to be able to pass something like a perl hash, really, but can't really see a way to do that.

Thanks again.

drawmack

In php if you have multiple fields with the same name they come through comma seperated however here is how I would do it.

Let's say we've got a db like this

tblOne contains fields ID and Notes

So in php we do this

$query = mysql_query("SELECT ID,Notes FROM tblOne ORDER BY ID");

echo "<form name=\"mian\" method=\"post\" action\"$PHP_SELF\">\n";

for($i=0;$i<mysql_num_rows($query);$i++) {
  echo "<input type=\"text\" name=\"notes_" . mysql_result($query,$i,0) . "\" value=\"" . mysql_result($query,$i,0) . "\"><br />\n";
} //end for
echo "</form>\n";

okay now your form will be generated with fields named things like notes_1, notes_2, ..., notes_x

Then in the processor do this

$query = mysql_query("SELECT ID,Notes FROM tblOne ORDER BY ID");
for($i=0;$i<mysql_num_rows($query);$i++) {
  $curVar = "notes_" . mysql_result($query,$i,0);
  echo $HTTP_POST_VARS[$curVar] . "<br>\n";
}//end for

Wabin

okay, I found the solution that makes me happiest... similar to your suggestion...

assigning variable names as you did to comment_xx, but then in the processor using

while(list($key, $value) = each($HTTP_POST_VARS)) {
   if  (preg_match("/comment_(\\d+)/", $key,  $matches){
      $id = $matches[1];
      //and the processing code here
   }
}

I think this solution will work better for me, as it allows me not to have to include the query in the processing web page. and it lets me use a regex, which just makes me happy.