close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Multiple Images per product through the database

Thread began 9/22/2015 6:49 pm by Paul | Last modified 10/05/2015 2:26 pm by Ray Borduin | 967 views | 15 replies |

Paul

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.

Sign in to reply to this post

Ray BorduinWebAssist

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).

Sign in to reply to this post

Paul

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!

Sign in to reply to this post

Paul

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Paul

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!

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Paul

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Paul

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...