Session problem

teckniel

I'm making a cart trou database :-)

but my problem is every time a users goto the catalog i create a new table trou my sql

example :
session_start()

$sql="CREATE TABLE ....

but how do i drop the table when the users leave???
even if there is information in it Note that the table name is the users there session id
🙂

hope sambody know it 🙂

pnoeric

hmmm two things come to mind. one is that SQL has a way to create temporary tables but I think that's just for the duratrion of a SELECT query. not sure. check the docs for temporary table.

the other is-- why are you creating a new table every time someone looks at a catalog?! I promise you there is a better way to do that :-)

best
Eric

teckniel

how is it don the other way????

quicknik

i would suggest to write your own session handler.
you could drop the table as part auf the garbage collector.

have a look at :
http://www.phpbuilder.com/columns/ying20000602.php3

bye,
niko

Weedpacket

Originally posted by teckniel
how is it don the other way????

Well, one way is with two tables. One contains the user's session id and other user-specific data, the other contains cart items (more exactly, ids of cart items), and includes a field for storing the id of the user who has that item in their cart.

All users use the same two tables.

I sometimes just store the time and date of the last user action as part of the data stored in the user table. Occasionally, I look through the table and find records that are more than (e.g.), a day or so old (older than the session lifetime, anyway) and drop them and any rows in the other table indexed to such "stale" users.

It may not be the most elegant of solutions, but I'd rather have data going stale in the database through lack of use than trash data that someone's still trying to use - and who sits and stares at a shopping cart for days on end without doing anything to it?

Have a look at some of the shopping cart scripts on this site and at Zend to see how others do it.

teckniel

thx m8t's for the great help :-)