Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I've had to do a similar thing with a site I wrote (allow a 30 minute period for a customer to enter a code)</p> <p>Rather than use a cookie (as you can't guarantee that the customer would be returning to the site in the same browser), I stored the expiry time for the code against the user's record. That way, whatever browser they accessed the page from (e.g., starting from mobile, finishing on a desktop), they would always expire at the same time.</p> <p>When the customer returns to the site, I compare the current time to the expiry time and act accordingly</p> <p>As you're already storing the customer's basket, I would add an expiry time against the record and then run a compare when the customer returns. It's quite easy to do:</p> <pre><code>update basket set expiryDateTime=date_add(now(),interval 7 day) where basketID=[xyz] </code></pre> <p>If you want, you could even set the time of day to be a standard value (20:00) by using a bit more trickery in MySQL</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to keep a session open after browser closed in PHP?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USDaveyBoy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to keep a session open after browser closed in PHP?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks but that only works when the customer is logged in. I also wanted to allow the customer to add items to the basket without having to register. Besides which I'm already keeping a last_update field in the database against the cart record. (What I mean is, I'm already going to be doing this for registered customers).
      singulars
      1. PO
      1. USuser1275136
    2. COIn that case, store the basket in a cookie (as a JSON string) with an expiry date value too. When they return, check for the cookie and expire any items that need to be. Just ensure that no personal information is stored in the cookie. If they need to register to actually get to the check-out/payment section, transfer the information to the DB once they have successfully registered and only use the DB from there on in (i.e., cookie for un-registered, DB for registered). This would allow for order history to be searched as well.
      singulars
      1. PO
      1. USDaveyBoy
    3. COSorry I don't think you understood me. I am storing the cart in the database already, and for registered customers I will find the carts they own from the database. All I'm trying to do here, is that when the browser is closed, persist the session_id from before so that unregistered customers will see their cart from before. So I created a session under the session name, and set it to expire in 30 days, but it still seems to expire when the browser is closed. What do I do to fix that? I only need the session id from before to identify the cart which is already stored in the database. thanks
      singulars
      1. PO
      1. USuser1275136
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload