Verify array has data...

jamz310

I have row in the MySql DB that contains various data. One column has the word 'Array' it in as seen when viewing it with phpmyadmin. How can I verify/see what is in the array? Or is it empty and thats why 'Array' is seen?

thx
jamz310

tomhath

You didn't give much information to go on. But I believe what you have in that column is the word 'Array'.

bradgrafelman

Yeah... unless PMA changed things up a bit, if it was a true MySQL array, you would see more than just that word when viewing rows.

Sounds like something went awry when you were storing data into the database, such as you tried to store an array as a string which... is translated to the word "Array" by PHP 😉

jamz310

Thanx for the input...

Here is what I have:

<?
echo "<pre>\n";

print_r($type_service);

echo "</pre>\n";

?>

Gives:

Array
(
[0] => UPS
[1] => USPS
[2] => Fedex
)

<? $ts=serialize($_REQUEST['type_service']); ?>
<? echo $ts ?>;

Gives:
a:3:{i:0;s:3:"UPS";i:1;s:4:"USPS";i:2;s:5:"Fedex";};

<? $type = implode(' ',$_REQUEST['type_service']); ?>
<? echo $type ?>;

Gives:
UPS USPS Fedex;

So the data is there but I can't seem to get it into the database. It shows up as just 'Array' in phpmyadmin.

In the mysql insert - VALUES statement I have this :

."$_REQUEST['type_service']".

I tried ."(implode(' ',$type_service))." but got error - probably wrong syntax but not sure how to store this into the DB.

There are a bunch of VALUES and they are all correct except the one above - it just shows as 'Array' in the DB column..

jamz...

bradgrafelman

jamz310 wrote:

$type = implode(' ',$_REQUEST['type_service']);

Uh... why not try inserting $type ?