Help to build a temporary table

[Anon]

Hi,

I need a little help, a trace, to create a mini e-commerce page.

In few words I would like to:

a) create a session

b) create a temporary table for such session

c) save there the items selected by the costumer

When the user goes away from the website the table should be deleted.

If the user confirm the order I will take the lines in table and send them to me by e-mail.

This is what I want to get.

I know something about PHP session and someting about MySQL CREATE TEMPORARY TABLE of MySQL ... How could I match these two things ?

I have still not tryed but I have read that closing the DB connection means table deletion...I suppose that submit a form or link to another page in the web site means the same...

Shoul I use permanent connections ?

Thank you very much for any help about!

Fabio

[[deleted]]

Forget the temporary tables, you can simply store all the ordered items in the session itself. When the user finishes the order you can process the items from the session and put them in a database or email.

If a user leaves the site, the session will be erased after X minutes automatically by PHP.

[fabiuz]

Thank you very mush, I have understood. I will go with sessions and a bidimensional array...

This is the first step: make my first mini e-comm page.

In the second step I would like to allow users to try a page and a database themself.
For this purpose I should create temporary tables to store the items they will insert trought the administrative area and than I manage basket by sessions and arrays... but I get another problem: how to take the tables available for the time users try them ?

...I don't see any MySQL function that have a counter after that delete the tables... Any idea about ?

Thank you very much for your help!

Fabio