Data Bridge - Public Pages

Hi,

I have just recently upgraded to data bridge, Do I get a free consultation? I didn't recieve any information in the email.

I am currently making an e-commerce site. I have created the admin pages and public pages using data assist. I need help with a few things :

1. The products table has product images which does not display on the results page and on the product details page.

2. The public pages which have been created are products_search, products_results and products_detail page. I have a menu which exists of the following categories sofas, tables, lighting etc. Would I have to create a separate products page manually to display products in each category or can I use data assist to create that?
And also would I be able to link the products page to the products_detail page created by data assist?

Thanks

Originally Said By: angel_16_786429569

  Hi,

I have just recently upgraded to data bridge, Do I get a free consultation? I didn't recieve any information in the email.

I am currently making an e-commerce site. I have created the admin pages and public pages using data assist. I need help with a few things :

1. The products table has product images which does not display on the results page and on the product details page.

2. The public pages which have been created are products_search, products_results and products_detail page. I have a menu which exists of the following categories sofas, tables, lighting etc. Would I have to create a separate products page manually to display products in each category or can I use data assist to create that?
And also would I be able to link the products page to the products_detail page created by data assist?

Thanks  

Hi,

I need to create this website ASAP, please can you help??

Thanks

1) the products table should store the image names in column, then on the details page set an image tag to use the column from the recordset:

<?img  src="path/to/images/<?php echo $row_recordsetName['imageColumn'] ?>" />

2) how do you want product categories to work? Should a product be assigned to only one category? or can it be assigned to multiple categories?

Thanks for replying, basically there would be multiple products in each category and then when you click on the menu for example sofas, the page should show only sofas. Once it shows sofas how would I then link that to the products details page created by data assist.

Thanks

  basically there would be multiple products in each category  

yes, i get that, but what i need to know is whether or not a product can belong to only 1 category? or can a product belong to multiple categories.

the answer to your question will be different based on the answer you provide to this question.

The products can only belong to one category.

ok, so in the products table add a categoryID column

also create a category table to define your categories:

categories:
categoryID -Primary Key
categoryName

when you run data bridge to create the products admin pages, set the category column of the products table to be a menu and use the categories table to populate it.


when you create the public product pages, include the category column in the search form, again set the category column to be a menu and use the categories table to populate it.

if you do a search for a category, you should see that the results page now uses URL variables to tell what category to show products for, use that URL in the links of your menu.

[QUOTE=Jason Byrnes;145076]1) the products table should store the image names in column, then on the details page set an image tag to use the column from the recordset:

<?img  src="path/to/images/<?php echo $row_recordsetName['imageColumn'] ?>" />

QUOTE]

Hi,

I copied the link like you said on the menu and it works thanks. I still have the issue with the image not being displayed. I copied the link as above (quote) but it does not show the image on the product detail page or result page.

Thanks

the image code above was only an example, and not the exact code, you need to substitute the correct image path and the correct recordset binding,

I have replaced the image path and put the correct recordset binding but it does not display.