PHP arrays and postgresql

On Wednesday 07 January 2004 20:45, Mike Nolan wrote:

I'm trying to find a way to store and then retrieve a PHP array in
my pg database.

If you mean as one value, look into the serialise() function - that's probably
what you want.
If not, can you explain a little more?
--
Richard Huxton
Archonet Ltd

create table test(
t_value text;
);

$array_values[] = "Test 1";
$array_values[] = "Test 2";
$array_values[] = "Test 3";

pg_Query($conn, "INSERT INTO test VALUES ( '" .
base64_encode(seralize($array_values)) . "' );");

$result = pg_Query($conn, "SELECT * FROM test;");
$rows = pg_NumRows($result)
for ( $y = 0; $y < $rows; $y++ )
{
$data = unserialize(base64_decode(pg_Result($result, $y, 0)));
print_r($data);
}
pg_FreeResult($result);

Hope this helps (serialize, unserialize). I use base64_encode/decode to
ensure that there wont be any delimiter problems, could be achieved by
using addslashes as well.

Gavin

Mike Nolan wrote:

I'm trying to find a way to store and then retrieve a PHP array in
my pg database.

If you mean as one value, look into the serialise() function - that's probably
what you want.

Serialize is just what I was looking for but not coming up with.
(My 18 year old son just got a kick out of the answer, he doesn't know
PHP but when I was explaining the problem to him last night he said,
"You mean like 'serialize' in Javascript?")

Thanks to everyone who responded.
--
Mike Nolan