Databases and ecommerce...... Confused?
I have searched fro the answer to this but i had/am having no luck, My site (simcards-r-us.co.uk) is currently a "static" site i think the word is, meaning that when for example you click on the simcards page i have copy and pased the hompage then modified the centre to have the simcards in it. I checked out the net and found that these big sites like play.com use a database for their products, i was wondering how to go about this for my site?
Thanks Ben
kb posted this at 20:50 — 5th June 2006.
He has: 1,380 posts
Joined: Feb 2002
You basically would want to use a template-based system and a language like PHP. A simple pseudo-code example:
index.php:
set page to indexinclude generic header file, and display first "half of webpage"
connect to table for index
pull data
display dynamic data
include generic footer file and display the remaining parts
And this would be the setup for each page, with a different "tag" for the page. If you want to get really fancy...you can have index.php accept variables, and have your entire webpage built around "index.php?id=1", "index.php?id=2" etc, but that's not really that good for SEO (from what I've heard).
Hopefully this helps.
adjroth posted this at 05:57 — 6th June 2006.
He has: 33 posts
Joined: Jun 2006
on my site http://www.jewelrysummit.com/ i have a main template, then smaller tables that are filled with data from a database using PHP, like brady said. I have an "Action" variable that defines what the customer is doing, "Page" variable to define what page they're on, and obviously a "Product" variable for what product they're viewing. You could use a paypal shopping cart, but i have one that i made but then uses paypal to checkout.
Bkag posted this at 17:10 — 6th June 2006.
They have: 7 posts
Joined: Jun 2006
Well i hope i have got this sorted now, im going to use zen cart, but have to change host first because my current doesnt accept ftp. I am using msfrontpage to design my site, is there any way of doing what you are saying in the "design" view of frontpage?
http://www.rc-forum.co.uk
kb posted this at 18:14 — 6th June 2006.
He has: 1,380 posts
Joined: Feb 2002
No, the coding has to be done by hand. It's not something that Frontpage can do for you.
adjroth posted this at 20:25 — 6th June 2006.
He has: 33 posts
Joined: Jun 2006
with the few products on your page, you should not need a database to hold product information. unless you are planning on putting alot more on there.
Green11 posted this at 06:33 — 7th June 2006.
He has: 10 posts
Joined: Jun 2006
A database is alot of work. If you have alot of products you definitely need one, and using MySQL with PHP will achieve this
However for a few products you can get away with static pages.
Myonlineusers.com - Online user count service (FREE!!)
It will look like "5687 users online" on your pages.
Bkag posted this at 17:49 — 7th June 2006.
They have: 7 posts
Joined: Jun 2006
Well we plan on offering probably 40-50 products i think.
kb posted this at 20:41 — 7th June 2006.
He has: 1,380 posts
Joined: Feb 2002
I would reccommend a database, for sure. MySQL and PHP preferred. Do you have any experience in coding at all?
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.