insert and getting images from mysql database with PHP

[olm475]

how do insert and get images into and from my mysql database using PHP and PHPmyadmin, when i try it shows image as some funky code not the image itself.

[litebearer]

Personally, I prefer to store the images in a folder and simply store the image name and description in the database. Makes life a bit easier.

example using database (with pagination)

http://nstoia.com/effie/gallery/

example using flatfile (sans pagination)

http://nstoia.com/testpg01/index.php

Both use a popup window to display the full size image

Lite...

[olm475]

ok i do but when i insert in the mysql database using PHPmyadmin how do i get it to upload on my website, i am using dreamweaver and have a connection to my mysql database....do i need to store folder in the database also...

[olm475]

and i also am trying to make the records hyperlinks on the site from the database how do i do this using phpmyadmin

[Roger_Ramjet]

Store the filename in the db and insert it into the <img src=" tag. FTP the file to your website. That is the usual way. See here for an explanation http://dev.mysql.com/doc/mysql/en/Tips.html