An E commerce site using php/mysql?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
187skillz
Forum Commoner
Posts: 39
Joined: Sun Aug 10, 2003 8:35 pm
Location: London

An E commerce site using php/mysql?

Post by 187skillz »

Has anyone ever seen an E commerce site tutorial using php/mysql? I've seen just 2 on my search on the web, I was wondering if y'all come across any apart from phpwebcommerce?


Thanks.
foobar
Forum Regular
Posts: 613
Joined: Wed Sep 28, 2005 10:08 am

Post by foobar »

If you want a solid e-commerce application, you should consider downloading one over making one yourself. There are a lot of security implications that _must_ be dealt with. Also, your clients will want to use something they can trust.

For an freeware, opensource, php e-commerce system, I'd recommend oscommerce. Remember, this has been developed by a large team of programmers and various specialists over a period of a few years.
187skillz
Forum Commoner
Posts: 39
Joined: Sun Aug 10, 2003 8:35 pm
Location: London

Post by 187skillz »

I'ts for my university project, we're all sh**** ourselves because he set us this stuff and we have no clue really.
foobar
Forum Regular
Posts: 613
Joined: Wed Sep 28, 2005 10:08 am

Post by foobar »

187skillz wrote:I'ts for my university project, we're all sh**** ourselves because he set us this stuff and we have no clue really.
I'd still recommend downloading oscommerce. Look at what they're doing in their database, look at some of their flow-charts to get a feel of what is needed. Browse eBay and Amazon for inspiration and to get a grasp of what security issues are immediately visible. There's not much more that I can recommend, really. I haven't found any e-commerce application "tutorials" as of yet, so I guess you're stuck with looking at already existing code.
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Post by onion2k »

You might also look at Zencart .. it's similar to OSCommerce, but better in a few areas apparently.
foobar
Forum Regular
Posts: 613
Joined: Wed Sep 28, 2005 10:08 am

Post by foobar »

onion2k wrote:You might also look at Zencart .. it's similar to OSCommerce, but better in a few areas apparently.
That reminds me, check out HotScripts.com for a simple e-commerce app.I don't know about ZenCart, but oscommerce is a giant. Something slimmer than that but with solid coding (lots of OO, as little spaghetti code as possible) should get you thinking in the right direction.
187skillz
Forum Commoner
Posts: 39
Joined: Sun Aug 10, 2003 8:35 pm
Location: London

Post by 187skillz »

thanks Foobar and Onion, I'll take them apart and if I encounter any problem, I'll write back, I know you guys will find this hard to believe but there are people that don't even know what php is and they're being asked to do this too.
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

Don't look at OSCommerce, it's a mess and still requires register_globals to be on, which has known security-implications. ZenCart is the "official" successor and probably a bit better. There are also commercial scripts (e.g. XCart) etc.
User avatar
neophyte
DevNet Resident
Posts: 1537
Joined: Tue Jan 20, 2004 4:58 pm
Location: Minnesota

Post by neophyte »

patrikG wrote:Don't look at OSCommerce, it's a mess and still requires register_globals to be on, which has known security-implications. ZenCart is the "official" successor and probably a bit better. There are also commercial scripts (e.g. XCart) etc.
I second that. One copy I installed constantly had table corruption problems. (I admit it might be a mysql problem). Aside from that I agree, it's a "mess".
foobar
Forum Regular
Posts: 613
Joined: Wed Sep 28, 2005 10:08 am

Post by foobar »

Thanks for correcting me, neophyte and patrikG! :) It's good to find out something new.
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Post by Jenk »

There is a contirbution to eliminate the need for register_globals, but I agree, oscommerce is a bit of a mess and still uses long vars which can also put you in the same boat as register_globals (if you don't have access to php.ini and long vars are off, you are stuffed.)
Post Reply