How do I store an php object in a MySQL table?

Question

I have set up a table that has only one field for a BLOB (Binary large object) but when I try to Insert it into the table it throws an error stating that it failed to convert the object to a string. This is my Query:

mysql_query("INSERT INTO objects (inquery) VALUES($inquery)");

score 28 · Accepted Answer · answered Feb 20 '11 at 00:33

28

Serialize it:

$str = serialize($object);

If your object contains private/protected fields it's also a good idea to base64_encode() the serialized object as those properties will result in ascii-1 characters being used which would break when editing the column manually e.g. with phpMyAdmin..

To restore your object, you simply unserialize() the string (base64_decode() it before if necessary).

answered Feb 20 '11 at 00:33

ThiefMaster

310,957
84
592
636

1

So when I go to grab it from the table after it has been stored, how do i convert it back to an object? – nkcmr Feb 20 '11 at 00:35
2

`$object = unserialize($str);` – tdammers Feb 20 '11 at 00:36
5

be careful though, not all php objects can be serialized. resources (db connects, http connections, etc) cannot be. see http://www.php.net/manual/en/function.serialize.php – helloandre Feb 20 '11 at 00:37
1

@contagious no worries, it is a dead simple object i created myself. – nkcmr Feb 20 '11 at 00:38

score 2 · Answer 2 · answered Aug 22 '16 at 01:05

2

use json_encode to encode the object before you save it in Mysql then json_decode to decode the object

answered Aug 22 '16 at 01:05

Mohamed Auf

129
1
2

When json_decoding the object will be a stdClass Object – Samuel Auger May 06 '19 at 18:14
1

sorry for the late response, but you can add the true to the second param something like this json_decode($json, true); – Mohamed Auf Jul 27 '19 at 09:15

How do I store an php object in a MySQL table?

2 Answers2

Linked