corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Help making a shopping basket in PHP and MySQL


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Help making a shopping basket in PHP and MySQL
James
Member

Registered: 1st Jun 02
Location: Surrey
User status: Offline
9th Mar 05 at 18:49   View User's Profile U2U Member Reply With Quote

Im trying to make an online shopping basket in PHP and MySQL. The user logs in using their email address and a password and that is when the session starts.

I have no idea how to code it and ive been looking for decent examples over the web without much luck.

What extra tables would i need in the database?

Can anyone help?
lozzd
Member

Registered: 10th Aug 04
Location: Winchester,Hants
User status: Offline
9th Mar 05 at 18:54   View User's Profile U2U Member Reply With Quote

http://www.hotscripts.com/PHP/Scripts_and_Programs/E-Commerce/index.html
Joff
Member

Registered: 17th Oct 00
Location: Cambridgeshire
User status: Offline
9th Mar 05 at 19:36   View User's Profile U2U Member Reply With Quote

Buy a book and work through it.
Chump
Member

Registered: 1st Feb 04
Location: Sharnbrook
User status: Offline
9th Mar 05 at 21:26   View User's Profile U2U Member Reply With Quote

to be honest mate your asking a bit much for someone to just write it all down for you.....there's a fair bit involved in what you've mentioned. If you then want to chuck a shopping cart facility into it aswell then you're talking quite a few mans hours to sit and do it all.

As Joff said - buy a PHP and MySQL book and teach yourself. Thats what i did. Took me about 2 weeks to grasp the majority of it and now I can do all you've mentioned above without any problems...


[Edited on 09-03-2005 by Chump]
Dom
Member

Registered: 13th Sep 03
User status: Offline
9th Mar 05 at 23:36   View User's Profile U2U Member Reply With Quote

aye, get a book, read some online tutorials etc etc and your sorted

although i would go get a free shopping cart like oEcommerce or something and just hack it to shite for what you want
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
10th Mar 05 at 01:17   View Garage View User's Profile U2U Member Reply With Quote

There's all sorts of security things to be aware of as well, probably best using an out-of-the-box one as it will be more mature in this respect.

Email address for username I don't like - what happens when someone loses use of an address?
Andrew
Member

Registered: 5th May 04
Location: Skoda Octavia Estate, Ford Puma
User status: Offline
10th Mar 05 at 01:38   View User's Profile U2U Member Reply With Quote

Think this one is books only
lewie
Member

Registered: 21st Feb 05
Location: Home: Orkney Uni: Edinburgh
User status: Offline
10th Mar 05 at 13:02   View User's Profile U2U Member Reply With Quote

use oscommerce, here

[Edited on 10-03-2005 by lewie]
Joff
Member

Registered: 17th Oct 00
Location: Cambridgeshire
User status: Offline
10th Mar 05 at 18:30   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Ian
Email address for username I don't like - what happens when someone loses use of an address?


Serves them right.
Nothing worse than signing up to a service or a forum with the intention to troll, only to forget your username.

When services become over-subscribed, it can take a few attempts to get the username you're after. Look how many people have a hotmail account with "2000, 80, 81, 82, etc" in them.

Laney
Member

Registered: 6th May 03
Location: Leeds
User status: Offline
10th Mar 05 at 19:24   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Peugeot Nut
Think this one is books only


Not really.

If you think about how it works its not THAT hard.

Use an array in the session to hold the amount/product ID and go from there.

If I can do it, anyone can

[Edited on 10-03-2005 by Laney]
Joff
Member

Registered: 17th Oct 00
Location: Cambridgeshire
User status: Offline
10th Mar 05 at 19:26   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Laney
quote:
Originally posted by Peugeot Nut
Think this one is books only


Not really.

If you think about how it works its not THAT hard.

Use an array in the session to hold the amount/product ID and go from there.

If I can do it, anyone can

[Edited on 10-03-2005 by Laney]


But then he's got to write code to recurse through the array when item quantities are updated or when whole "rows" are deleted.
Does PHP have an equivalent to the Dictionary object in ASP/VBScript?

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
TIM!!! U BROKE IT AGAIN!! Richie General Chat 1 846
9th Jun 03 at 22:13
by mestonian
 
Linking .jsp pages to a MySQL database chris_lee100 Geek Day 7 1434
1st Feb 04 at 14:23
by Ian
 
Good Monday Morning Pablo Off Day 27 601
26th Jul 04 at 13:07
by leeshez
 
forum hacking - SQL's Drew Geek Day 15 1720
9th Sep 04 at 23:50
by Ian
 

Corsa Sport » Message Board » Off Day » Geek Day » Help making a shopping basket in PHP and MySQL 29 database queries in 0.0143249 seconds