Page 1 of 1

Fastfood Ordering System with PayPal Intergration

Posted: Tue Jun 10, 2008 4:49 am
by italianninja
Hello, I am trying to figure out the best way to do an online ordering system for my chinese takeaway! the way i would like it to work is:

people log onto my site
register there details
takes them to the order page
they place the order and goto the payment page
payment is processed via someone like paypal or googlecheckout
payment cleared thank you order coming soon screen
(in shop) usb reciept printer prints two reciepts, one for kitchen to cook and the other for driver to deliver with name address on etc.

is this possible in php mysql? anyone fancy giving me some of there time to work on this project? I have done most of the design, just need to make it work! :banghead:

Re: Fastfood Ordering System with PayPal Intergration

Posted: Tue Jun 10, 2008 5:57 am
by aceconcepts
Sure, i'll lend you a hand.

So you're going to need a menu, basket, customer table, orders table.

menu = list of dishes

basket = storage of selected dishes by customer

customer table = storage of customer details

order tables = storage of all paid orders

Let me know how this digests :D

Re: Fastfood Ordering System with PayPal Intergration

Posted: Tue Jun 10, 2008 9:12 am
by italianninja

Re: Fastfood Ordering System with PayPal Intergration

Posted: Tue Jun 10, 2008 11:00 am
by aceconcepts
Cool, looks good.

Have you worked with databases and SQL before?

Re: Fastfood Ordering System with PayPal Intergration

Posted: Tue Jun 10, 2008 9:31 pm
by italianninja
done a little bit like but not much. this is wh i could do with some help! have you done much?

Re: Fastfood Ordering System with PayPal Intergration

Posted: Wed Jun 11, 2008 3:23 am
by aceconcepts
Yeah, I work with databases everyday.

So, do you use cPanel and phpMyAdmin on your server?

Re: Fastfood Ordering System with PayPal Intergration

Posted: Wed Jun 11, 2008 7:04 am
by italianninja
Neither. phpmyadmin needs to be installed. Use fasthosts and they have there own panel.

Re: Fastfood Ordering System with PayPal Intergration

Posted: Wed Jun 11, 2008 7:40 am
by aceconcepts
Ok.

So, I guess we should describe the tables needed to do this:

1. tblDish (intDishId, strDishName, strDishDescription) - this will store all the dishes/food you sell including side orders, soups and sauces

2. tblBasket (intDishId, intQty, strSessionId) - this will hold the dishes and quantities selected by the customer

3. tblOrder (intOrderId, intCutomerId, strSessionId) - this will hole one single complete order

4. tblOrderDetails (intOrderId, intDishId, intQty) - this will detail a single order e.g. how many dishes they had and which ones

5. tblCustomer (intCustomerId, strTitle, strFirstName, strLastName, strEmail, strPassword, etc...) - self explanatory (include login details)

So these are the basic tables you need in order to construct you database.

FYI: tbl = table, int = integer, str = string

I have used the above abreviations to help recognise the data types used except for tbl which simply identifies a table. str as a datatype could be VARCHAR or TEXT - anything that is text based really, or mixed.

Let me know what you think.

Re: Fastfood Ordering System with PayPal Intergration

Posted: Wed Jun 11, 2008 9:01 am
by italianninja
Sounds good. What about people forgetting there login details etc. Need to add something for that. How long will it take to get a beta version up and running then?

Re: Fastfood Ordering System with PayPal Intergration

Posted: Wed Jun 11, 2008 9:06 am
by aceconcepts
If someone forgets their login just send the login details to the email address they signed up with or additionally you could add a secret question and answer facility - either way is simple enough.

It won't take long to setup a beta version. You already have the cosmetic side sorted so now all you need to do is setup the database and program the basket and login stuff etc...

Do you want to communicate by email instead of via the forum?

you can reach me at: nick at q2q dot co dot uk

Re: Fastfood Ordering System with PayPal Intergration

Posted: Wed Jun 11, 2008 9:23 am
by italianninja
yeah we can talk through email, i got a blackberry for my sins so i can get email on the move. I think I will get a new iphone when they come out :D