Posting mysql objects...

Valkrin

I am using mysql_fetch_object to get results from the database. Now I want to pass these results to the next page using a form and the post method. The problem is that when I post the object to the next page, I get the variable type and not the variable itself. For example:

$row = mysq_fetch_object($result);

//echo html for a form here

echo "<input type=\"checkbox\" name=\"blah[]\" id=\"blah[]\" value=$row />";

Now on the next page where the object has been posted to, if I do something like this:

print_r (array_values ($blah));

I get [0]=>Object [1]=>Object etc.

Is there another way that I might try that would make this work or will I have to query for the same results on next page? Any help would be appreciated. Thank you.

suit4

the error seems to be in your mysql_fetch_object($result)

even, if there's only one element in the result,
you need to get that element out of the result by
doing something like

$element=$row->name;

where 'name' is the name of the table column you are trying to fetch.

your input tag has to look like this:

echo "<input type=\"checkbox\" name=\"blah[]\" id=\"blah[]\" value=$element />";

Valkrin

Thank you for your help, but that is not what I was looking for. Sorry, I should have made my question clearer. I want to post all the variables from one row, not a particular variable from the row. For example, I have the $row object which contains the following variables:

$row->name;
$row->age;
$row->address;
etc.

Now I want to pass all the values in that particular row to next page using the post method. If I do value=\"$name\" then only the name is passed and the other variables in the row object are not. That is the problem. I want to pass all the variables in $row, that is why I used value=\"$row\" but as I mentioned in my previous post that does not work.

Valkrin

I figured out how to do it, and decided to post it here just in case someone else was having a similar problem. Instead of using objects, I used arrays by using $row = mysql_fetch_arrays($result,ASSOC)

Then I imploded the $row array and placed it as the value for the checkbox. In the next page this information was posted as an array of imploded arrays. To extract the data I looped through the array exploding each element and storing it in an array, and then immediately processing the array because it would be overwritten with the next iteration of the for loop.

Here is the code for extracting data from an array of imploded arrays:

for ($x=0; $x < sizeof($blah); $x++)
{
$narray = explode("," , $invoice[$x]);

//Do something with $narray because each time the loop iterates the data is overwritten.
}

Or you could just do this:

$array0 = explode("," , $invoice[0]);
$array1 = explode("," , $invoice[1]);
etc.
etc.

Mushroom

It should work with the methods of "GET" or '"post".

But using "explode" and "implode" is not so satisfying I am afraid.If the vars contain the separator ",",how to deal with it?

Valkrin

You can use any seperator you want. Use ~ if you must, I doubt any of your vars contain that character. 🙂

Mushroom

:-)