Multiple Images per product through the database

A new client needs multiple images for each product. So I wanted to check with Webassist first to see what is the best way to do this.

I just bought the MySQLi.
Own: Design Extender and Data Bridge
Running DW CC2015
Windows 10

I am looking for guidance in adding multiple images for each product.

1. Do I have to have a separate column in the record for each picture?
2. What would be the path for each picture? images/product1.jpg, etc?
3. Does Webassist have a method to be able to show "more images" for each product and have them come up in a pop-up type window or is there some way to make thumbnails that pop-up to full-size images?

Appreciate any guidance to get me going.

Is there a maximum number of images per product? You could do a separate column for each picture if there is a maximum number. If you need to support unlimited images then you would have to use a relational table for the images.

I'd do a path like: images/[product_id]/[imagename] and just use the name the client uploads.

If you upload the full size image (I would not resize on upload unless it is over the maximum size you want to support), then you can use Image Resizer to show it as a thumbnail.

Popping up a full size version would then just be a simple lightbox and javascript to set the image to the full sized version. We don't have anything for that, but the concept is pretty simple to pull off. An fixed position layer that overlays the page and has an image in it that you set the display and img src attributes on click of the thumbnail, then a close icon you set the display to none. We could help with that in a premier support ticket, or you can probably find lightbox script samples somewhere on the web (jquery).

Wow, Ray. Super Service!

Thanks for the quick response...

From what I can see on their current site, there is a max of 4-5 images. So I guess the one column for each is not a big deal.

I will look for a simple lightbox, but if I run into issues I will certainly grab a premier support ticket.

Thanks!

Ray, I'm a bit befuddled as to what's happening on GoDaddy and with the DataAssist Wizard. I purchased

I have a new MySQL database that I created called "fit_products". In it, I have 1 table called "products".

In Dreamweaver, I connect without any problems and I see the "fit_products" database. Now, I am trying to create the admin pages so that I can start populating the database.

In the DataAssist Wizard Create Pages, my connection is correct and when I check it through the DEFINE button, it shows the correct database and connects successfully.

I chose the Product Administration pages to build and it shows my table called "products". The Key Columns correctly show the fields, but not the preview. I thought it might just be for visual purposes, so I created the pages and they all have the wrong fields.

I called GoDaddy and they see the same thing through the phpMyAdmin that I do.

Have you seen this before? The correct connection, correct database and table, but the wrong fields?

I've attached a screen capture of the preview page. I don't have a PRICE field in my database along with the other fields.
I've also attached a screen capture of the phpMyAdmin page, showing the database structure.

Your help is greatly appreciated.

Is it possible that you already had a table named "products" in your database? If so the preset wouldn't be able to create the table and the columns would remain from the table you already had instead of the one from the preset.

Try renaming the table you have in your database now by running a query like:
RENAME products TO myproducts

Then run the wizard again. That should allow it to create the correct database structure from the preset. At that point you can add more columns if you need them.

I do have a table named products in my database... In the wizard it shows the correct database, table and the key columns, but the fields in the preview are incorrect.

Wouldn't the presets still pick up MY table even if I didn't check the box to create the table for me?

I will try changing the table name tomorrow and see what happens.

Thank you!

Sometimes you need to change the selected table in the list and change it back again for it to refresh after choosing a preset. Maybe just try that.

Hi Ray,

Take a look at this screen capture. Now I am unable to open the DataAssist Pages. I did uninstall DataBridge and reinstalled it, but the same error comes up.

UPDATE:
I checked my versions of your software and realized I was a dot behind, so I removed them all and reinstalled them.

I was able to, as usual, make my database connection through the Dynamic MySQLi extension. Tested it and all good.
Then I went to make the Recordset. I click on Define the connection and it shows it properly, but it doesn't show it in the Recordset window.

Not sure what's happening now.

The installation must not have completed properly. Can I get a US phone number or Skype contact information? I'll set up a screen sharing session to help you get the proper version installed.

see PM

UPDATE:
The installation of the dot upgrades fixed the activation problem. The original problem still exists. It is showing the incorrect fields for the table. I am also still unable to make a Recordset as it doesn't put the connection in that I select.

UPDATE 2: FIXED. Not sure how, but after redoing the connection and recordset again, the page is now showing content.

I have concluded the following:

1. I realized that since I am using the MySQLi extension, that my recordsets have to be made from the Webassist > MySQLi > MySQLi Recordset. Even though I've done that now, when I place my fields on a test page and upload to the website, nothing is showing on the page. The source code doesn't even show the fields.


UPDATE 3: NOT FIXED
In making the Admin pages:

1. If I choose one of the preset Application Types like "Product Administration" (which is what I am trying to do) it pulls up the wrong table, which I still don't know where it is coming from.
2. If I choose <New From Blank>, I get the popup window (see capture3.png attached) that tells me it can't find all the columns?


9/28/15
This morning, I tried to make the search/product page/details pages from the DataAssist Wizard. It opens up and tells me "No Database Connection Found". In the screen capture2.png file attached, it clearly shows a connection.

Still need some help.