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)");

ThiefMaster · Accepted Answer · 2011-02-20 00:33:56Z

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, 2011 at 0:33

ThiefMaster

320k85 gold badges608 silver badges648 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

nkcmr Over a year ago

So when I go to grab it from the table after it has been stored, how do i convert it back to an object?

tdammers Over a year ago

$object = unserialize($str);

helloandre Over a year ago

be careful though, not all php objects can be serialized. resources (db connects, http connections, etc) cannot be. see php.net/manual/en/function.serialize.php

nkcmr Over a year ago

@contagious no worries, it is a dead simple object i created myself.

Mohamed Auf · Accepted Answer · 2016-08-22 01:05:05Z

2

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

answered Aug 22, 2016 at 1:05

Mohamed Auf

1291 silver badge2 bronze badges

2 Comments

Samuel Auger Over a year ago

When json_decoding the object will be a stdClass Object

Mohamed Auf Over a year ago

sorry for the late response, but you can add the true to the second param something like this json_decode($json, true);

Collectives™ on Stack Overflow

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

2 Answers 2

4 Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Linked

Related