Display image in web page from DB

Raks

Hi,

I am using the plaicart code provided by http://www.phpwebcommerce.com/, all is fine. I was able to configure the site and build the DB. Am using it on WAMP with MySQL as backend.

I'm encountering a lil issue though,when I'm adding a picture,it doesn't display on the web page but it is stored on in the DB. Why is that so?I've checked the path and seems ok else the data would not have populated my DB "tbl_category".

I've added the picture through the web interface itself in the product section and it is stored in the DB but on the web display it displays as "No Image" thumbnail.

Can you please assist me as am a bit new to php and am still learning it.

Thank you,
Raks

anakadote

Did you verify that the image was actually uploaded to the server? And can you provide a URL to the website?

Raks

Thank you for your reponse.
When I go to the "Admin - View Category" I still get the thumbnail "No-Image". I've even copied the image in the directory where it should be for "category", i.e. "http://localhost/plaincart/images/category". I've added a category through the web interface by searching the new image I just copied in the location. When I check in the 'tbl_category' table the image is stored there.

Would really appreciate some help here as am stuck with it even after going through the all the relevant pages: "/plaincart/admin/category/add.php" , "/plaincart/admin/category/processCategory.php".

I trust your know how and thank you in advance

jeepin81

Is it actually storing BLOB data in the DB or just referencing a path to the image?

Couple thoughts:
- permissions on the images directory
- is the image rgb?
- what format is the image? ie: gif, png, jpg, etc.

anakadote

'View Source' through your web browser and look to where the image is suppose to appear. Does it show the correct full path to the image? Does the image file actually exist in that location on your local computer? What is the path and file name that you see in the source?

Raks

The image are in.jpg and there is 777 permissions on the root folder itself.
The 'viewsource' show me quite certain things. The "No Image" thumbnail is showing a path where there is the default path where the "No Image.png" is stored.

Please find some extracts of the code with the error part in bold

<td>Expensive and luxurious cars</td>

<td width="75" align="center"><a href="javascript:modifyCategory(12);">Modify</a></td>

<td width="75" align="center"><a href="javascript:deleteCategory(12);">Delete</a></td>

</tr>

<tr class="row1">

<td><a href="index.php?catId=19">Laptop</a></td>

<td width="75" align="center"><a href="javascript:modifyCategory(19);">Modify</a></td>

<td width="75" align="center"><a href="javascript:deleteCategory(19);">Delete</a></td>

</tr>

<tr class="row2">

<td><a href="index.php?catId=13">Manga</a></td>

<td>It's all about manga, yay....</td>

<td width="75" align="center"><a href="javascript:modifyCategory(13);">Modify</a></td>

<td width="75" align="center"><a href="javascript:deleteCategory(13);">Delete</a></td>

</tr>

Should you require the whole coding of this page I can forward it to you.
Thnkx

amber_long83

yeah your code right,
so how you get error on screen. i will check your code and than give's you answer.

Raks

Hi Amber,
If the image is well saved as a md5 value in the DB, logically it's storing it but why its not displaying? You think its the path in the coding "processCategory.php"?

$catImage = uploadImage('fleImage', SRV_ROOT . 'images/category/');

Hierarchy of Admin Category: "plaincart/admin/category/processCategory.php"
Hierarchy of Image folder: "plaincart/images/category/ "

I modified the path but same result.

Thnx