How can I use multidimensional arrays in PHP with MySQL-based sessions?

Question

So I started using MySQL-based sessions with session_module_name("user"); and I love it, and I might as well because I have to.

The only thing I'm missing are my beloved multidimensional arrays, and I'm at a juncture where they are most desired. How can I still use them, or is it a lost cause?

What's the problem? AFAIK - You should be able to store multidimensional arrays in session stored in mySQL without problems. — timdev
– timdev, Commented Oct 12, 2009 at 23:27
Yeah I don't know, they just don't show up in the database and don't follow the state from page to page. All my other variables work just fine... they usually look like this: count|i:13;user|s:1:"1";level|s:1:"2";theme|s:10:"fixeddream"; — Aaron
– Aaron, Commented Oct 12, 2009 at 23:34
That's what they look like in the database, in case something looks wrong to you. — Aaron
– Aaron, Commented Oct 12, 2009 at 23:36
@aaron - could this bug by your problem: bugs.php.net/bug.php?id=33772 — Corey Ballou
– Corey Ballou, Commented Oct 12, 2009 at 23:53
@cballou - I don't think so, but in all honesty, I don't completely understand everything mentioned there. It looks to be about classes and __destruct, and I don't employ either, unless PHP is employing them behind the scenes. — Aaron
– Aaron, Commented Oct 13, 2009 at 0:15

Ben Rowe · Accepted Answer · 2009-10-13 01:10:22Z

1

use seralize() method to convert your array data into a string representation (which is easily stored in a db). When you retrieve the data back from the db, use unseralize().

answered Oct 13, 2009 at 1:10

Ben Rowe

28.8k6 gold badges58 silver badges76 bronze badges

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

Collectives™ on Stack Overflow

How can I use multidimensional arrays in PHP with MySQL-based sessions?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related