Greetings.
I'm using PHP for the first time on a job, and I'm having some trouble with it.
I'm using PHP and MySQL to make an online store for a client. I was going to open a persistent connection using mysql_pconnect, and create a TEMPROARY table for the shopping cart.
These tables are deleted when the connection is closed (which happens when user checks out the items), and each user can have one of these tables at the same time without interfering with each other.
The problem is:
mysql_pconnect looks for already open connections before connecting, thus all the custumers use the same connection, thus the same table, and thus they share a shopping cart.
How can I get this to work?
I'm using PHP for the first time on a job, and I'm having some trouble with it.
I'm using PHP and MySQL to make an online store for a client. I was going to open a persistent connection using mysql_pconnect, and create a TEMPROARY table for the shopping cart.
These tables are deleted when the connection is closed (which happens when user checks out the items), and each user can have one of these tables at the same time without interfering with each other.
The problem is:
mysql_pconnect looks for already open connections before connecting, thus all the custumers use the same connection, thus the same table, and thus they share a shopping cart.
How can I get this to work?