Hi all

 

I have just joined to forum because I am in need of some help. I am trying to create a website, and have done pretty much all of it so far.

 

Though I have now come to the point where I have to design a page that will act as the page where all products will be shown when clicked. Though am having trouble finding help with this on the internet and what I call it really?

 

Basically what I need to do is create on 'template' where a product is shown in more detail when clicked from another page where they are all listed.

 

For example, when you search for a product on Amazon, you are shown a list of products that match your search, when you then click one of these you are shown a page containing price, reviews and a product description. What do I need to do to get something like this, because I know that Amazon and online stores like this do not create a page for each product haha.

 

Any help would be great sorry to rant on just dont know how to explain what I mean properly

It would be a single page (file) that acts a a layout template. The product text and images (or path to the images) will be stored in a database and the query string in the url will reflect which product info is pulled from the database and displayed on the template.

 

e.g. template.php?product=1 will mean you can have the template pull row with id '1' from the database ie. product number 1's name, price, images, description etc....

Great, many thanks for your help.

 

I take it I will need to create a MySQL database to make this happen? Do I need any additional software to go with this, to make the database?

 

Apologies I am very new to PHP, MySQL etc...

 

A push in the right direction would be great, I can do the research/learning from there.

 

Dan

If you have a mysql database at your disposal and php, that's all you'll need.

 

In it's basic form, you are going to populate a database with info, and retrieve that info using $_GET[] from the URL. You really just need to learn about $_GET[], avoiding sql injection, SELECT from mysql and you should be able to do it all with that.

Once again thank you for your help.

 

I am having trouble understanding how I get the information from the database to the PHP page.

 

Do you set fields? so that when the product is selected the image goes into a certain place along with text and description etc...

 

My server supports MySQL how do I go about creating this as a database, like you would in access - with field headings etc... not sure how this is actioned.

 

Sorry again I'm completely new to all this, and dont want to sound too newbie-ish

 

Dan

I'd suggest you take a look at an open source cart and see how that creates & interacts with the database to produce the product pages & expanded views.

Hi,

That is done in php

 

mysql database and php will help you to do that

thanks

a1visions.com

Thank you all for your help.