Creating Guest Checkout Feature

[vinpkl]

Hi

I have an old ecommerce website in which all queries are based on LOGIN ID.

select * from user_table where user login id = '$loginid'

Now i have a requirement of creating “CHECKOUT AS GUEST” feature.

So i would like to ask how should i create “CHECKOUT AS GUEST” Feature and ON WHAT BASIS i should refer my queries ??

So that my queries should work in both case, whether user is a MEMBER or a GUEST.

Thanks
Vineet

[droopsnoot]

One way might to have a dummy login-id that all guests use. You’d need to ensure that doing it that way does not mean that one guest can see another guests orders, payment information, etc. Probably a better way of doing it.

[SpacePhoenix]

When you’re dealing with any data that has been submitted by the user you need to always use prepared statements otherwise you’ll leave yourself wide open to SQL Injection attacks. You also should be validating any user submitted data for example if login IDs are numeric you could use is_int() to check if the login ID is a number.

[vinpkl]

Everything is being validated.

I just want to know whether you create TWO separate database tables for Member and Guest.

OR Single table for both.

And Then you do queries on what basis.

Thanks
Vineet

[oddz]

What is the table schema for the user table.

SHOW CREATE TABLE user_table;

[mdarc]

Create a new field “is_guest” to be used as boolean in user_table. Then use unique/random generated $loginid (or the default autoincrement) to insert this new guest user.

From time to time, run a cron job for deleting old “is_guest” records from the user_table if needed.

If the user is not a guest anymore (i.e. he subscribed), update the row to is_guest=false.

[djsmithme]

Whats your payment gateway?

If you are using sage pay/paypal or something I have found it easier to not worry about storing the information untill after the payment, on the sucess callback just fetch the transaction records and save the relevant information to your invoice database.