Re: [GENERAL] PHP arrays and postgresql

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:

>This may not be the best place to ask the question, but I've already searched
>the PHP archive and code snippet sites.
>
>I'm trying to find a way to store and then retrieve a PHP array in
>my pg database.
>
>Has anyone written some code to do this?
>--
>Mike Nolan
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>