Sharing session variables?

[Gilles Ganault]

Hi

A friend of mine use PHP sessions to keep track of user data on the
server. The problem is that some of the SELECT queries are common to
all users, but apparently, session data cannot be shared among users.

Is there a way to share the output of a SELECT?

Thank you.

[ZeldorBlat]

On Mar 12, 6:41 pm, Gilles Ganault <[e-mail]:

Hi

A friend of mine use PHP sessions to keep track of user data on the
server. The problem is that some of the SELECT queries are common to
all users, but apparently, session data cannot be shared among users.

Is there a way to share the output of a SELECT?

Thank you.

Session data typically can't be shared between users -- that's one of
the reasons they're very effective.

Just store the result somewhere else. You can serialize it and write
it to a file or use something like memcached. Then you just check if
the result you're looking for is in the cache. If it is you use it;
if it isn't you hit the database then store the result.

[Gilles Ganault]

On Wed, 12 Mar 2008 15:47:37 -0700 (PDT), ZeldorBlat
<ze********@gmail.comwrote:

>Just store the result somewhere else. You can serialize it and write
it to a file or use something like memcached.

I'll read up on serializing data, or using a Memcached daemon. Thanks.