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

Problem with database driven image file names in PHP / MySQL?

Thread began 1/09/2014 10:52 am by Nathon Jones Web Design | Last modified 3/11/2015 4:57 pm by pistartech366237 | 1116 views | 8 replies |

Nathon Jones Web Design

Problem with database driven image file names in PHP / MySQL?

Nyarg! I knew this process wouldn't be easy but I'm struggling to understand, seemingly, the very basics.
Is there a known issue when populating an IMG tag from a MySQL database?

Here's my code:
<img src="../led-light-bulbs/tmb/<?php echo $row_rsPRODS['LEDimgtmb']; ?>" width="220" height="220" style="border:none;" />

My images are in the correct directory, and when I right click on the images (which are not displaying) I am shown the correct full path:
http://www.ledwarehouseuk.com/led-light-bulbs/tmb/LWP0002.jpg

I've quadruple checked that the image files are in the right place but they just won't display!
I've got everything stored in a restricted directory on this website so if you need access I'll upload the login details and URL for the sign in in the private area.

Hope a PHP regular can point me in the right direction here. Trying hard not to throw PHP out of the window and go back to trusty old Classic ASP here! :o)

Thanks
NJ

Sign in to reply to this post

Nathon Jones Web Design

Just posting login details to the restricted page (see below).

Sign in to reply to this post

Nathon Jones Web Design

Jayzus!

File name reference in the database was wrong!
Starting to wonder if learning PHP on live projects is such a good idea. I'm showing symptoms of madness here!

Sorry.
NJ

Sign in to reply to this post

Jason ByrnesWebAssist

learning anything on live products, including PHP, is a bad idea.

Create a test project for learning purposes.

Sign in to reply to this post

pistartech366237

Hi Jason,

Need your help yet again.

I have created the Query using the MySQLi extension. Everything is working great on the page except the image - it would not show using the php command after binding it to the Image Placeholder. On the live site it shows the empty placeholder, however, the image is being stored on the remote server correctly, the path to the image is also correct, and the database shows the correct image name in the correct column.

Please see the code and the links in the PM

Thank you so much in advance.

Sign in to reply to this post

Jason ByrnesWebAssist

if i right click one of the image placeholders and select to open in a new tab, it gives a 403 permission denied error. the path to the image is:
http://www.michaelgalperin.com/MGalperin_Comment_Insert_Form/storage/files/Koala.jpg

but the permissions for the image are not allowing access.

you will need to change the file permissions to allow access.

Sign in to reply to this post

pistartech366237

Dear Jason,

Thank you so much for taking the time checking this out.

The image permissions are at 755. Should I change them to 777?

Please advise.

Sign in to reply to this post

Jason ByrnesWebAssist

755 should work. double check the permissions for the folder also, and the other subfolders in the path. that can effect it.

if you still can't get the permissions to work, you should contact the host.

Sign in to reply to this post

pistartech366237

Will do.

Thank you so much for your help.

Best wishes.

Sign in to reply to this post

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