POST array from MySQL Query to reuse

stratguitar

Hello!

I have sucessfully executed a MySQL query (obtaining 80 records, 4 cols each), then using a while loop to iterate through the rows:
$query = "SELECT car_ID, car_name, s_val, FROM cartable WHERE bla bla..";
$result = mysql_query($query);
while ($dbrow = mysql_fetch_assoc($result)) {

displaying rows and collecting some user input in another array...

i.e.
$car_ID=$dbrow['car_ID'];
echo "<INPUT TYPE=\"text\" name=\"usage[$car_ID]\" SIZE=\"3\">" . $dbrow['car_name'] ."<BR>";

reset ($dbrow);

echo "<INPUT TYPE=\"Hidden\" NAME=\"arraycar\" VALUE=\"". $dbrow ."\">";
}

I'd now like to POST that array (preferably to $_SERVER['PHP_SELF'] and be able to reuse it.

I'm setting it now as hidden value in my Form Submit, but I'm not certain where to place it within the script, or that I'm telling the script the correct thing to post. I've tried several ($key=>$value scripts to test my POST results, but my POST is not bringing the array through.

I need some math values from the query, and operate on the user input values. So I am hoping to actually array_merge the 2 arrays that I've gotten. ($dbrow and $usage) once they both come thru... ::sigh::

Seems to me I should be able to do that, since 'usage' is passing all its values to the post. However, $dbrow is not.

What am I doing wrong?

Thanks
Strat

HalfaBee

This only sets arraycar not an array

echo "<INPUT TYPE=\"Hidden\" NAME=\"arraycar\" VALUE=\"". $dbrow ."\">";

should be
echo "<INPUT TYPE=\"Hidden\" NAME=\"arraycar[]\" VALUE=\"". $dbrow ."\">";

or
echo "<INPUT TYPE=\"Hidden\" NAME=\"arraycar[$car_ID]\" VALUE=\"". $dbrow ."\">";

To see the $_POST values use

echo '<pre>';
print_r( $_POST );

HalfaBee

stratguitar

Thanks for your suggestions! I must still be doing something wrong.

This is what I used per your recommendation

echo "<INPUT TYPE=\"Hidden\" NAME=\"arraycar[$car_ID]\" VALUE=\"". $dbrow ."\">";

View source' shows:
input type=hidden name=arraycar[car_ID] value=array

POST is passing the arraycar[$car_ID] properly, but each has the value 'array' with none of the elements from the row. When I request to see element [1][1], I get the letter 'r' from the word 'array.'

It DOES work if I do it the following way, but only passes the requested value car_name. Would that I could pass ALL those values from the query. Only way I can right now is to set each 'columnname' from the db this way as the 'while' loops thru the recordsets:

echo "<INPUT TYPE=\"Hidden\" NAME=\"arraycar[$car_ID]\" VALUE=\"". $dbrow[car_name] ."\">";

I've already been down that road, and it works fine. However, my actual goal is to have the $dbrow set (not just the last row of $dbrow) pass to the POST as the identical set pulled down from the database. (I don't care about the assoc, I simply want the set to look just like the query).

Why am I wrestling with this? For 2 reasons:
1. I don't want those values apparent on the client side. Is there no way to do this (except to re-run the query on post?)
2. Once this post is accomplished, I want to re-use the query on a third post. (i.e. users enter a buncha values, post then calc -- and then they can reset the value on the second page if they don't like the results.)

😃 (DON'T ASK!!!! - Tearing what little hair I have left out over this one.

Thanks for the help, though.

Strat

HalfaBee

If you don't want to send the data to the client you will have to do the query each page.

HalfaBee

stratguitar

As I thought. Thanks for confirming this. It's important to not display the calc info in this instance. but that will cause one query to the db for each user input. I'd imagine that might not be more than 6 inputs, but when multiple users may be using this, that could be quite a tap on the db, mightn't it?

Strat