This is probably a FAQ, but the on-line manual is rather confusing
and I can't get it to work!
The problem: I have a fairly complicated set of objects, all
interconnected through the instance variables of one object storing
the value of another and so on. Other instance variables hold
strings. I want to store the whole thing in a PostgreSQL database
and then later recreate the entire hierarchy with everything set up
as before.
This is what I am using ($zurich is an instance of the Class Zurich):
$s = addslashes(serialize $zurich));
$result = pg_exec($db, "UPDATE zurtable SET serializedobject = '$s'
WHERE name='Zurich'");
[error checking omitted]
This puts something sensible into the database; the first few
characters of what is retrieved using the database front end psql
looks like this:
O:6:\"zurich\":10:{s:7:\"players\";a:7:{s:14:\"water_supplier\";O:14:\"water_supplier\":3:{s:4:\"name\";s:14:\"water_supplier\";s:10:\"reservoirs\";a:5:{i:0;O:9:\"reservoir\":5:{s:13:\"building_cost\";i:2500;s:11:\"repair_cost\";i:2000;s:14:\"maintenance_pa\";i:50;s:7:\"max_age\";i:10;s:3:\"age\";i:4;}i:1;O:9:\"reservoir\":5:{s:13:\"building_cost\";i:2500;s:11:\"repair_cost\";i:2000;s:14:\"maintenance_pa\";i:50;s:7:\"max_age\";i:10;s:3:\"age\";i:1;}i:2;O:9:\"reservoir\":5:{s:
[many lines omitted]
itical_popularity\";i:5;s:19:\"supplier_popularity\";i:5;s:13:\"env_awareness\";i:5;s:5:\"clock\";i:997373335;s:4:\"time\";s:31:\"Thu,
9 Aug 2001 17:08:55 +0100\";}
However, when I come to extract the field from the database using:
$result = pg_exec($db, "SELECT serializedobject FROM zurtable WHERE
name='$Zurich'");
$row = pg_fetch_array($result,0);
$new_s = $row['serializedobject'];
the output ($new_s) is null. What am I doing wrong?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
