Putting images in MySql

[Uncle Ghed]

I've got myself to the point where i have a table with all the fields I need (id, title, content, date, category Id).
I heard you can put images directly into a Mysql db. This means I need a new field, i think... Anyone can point out a tutorial for this?
(I believe i recall the images with the mysql_fetch_object function, and can format them in my display page...)

[Ripper]

This link helped me with the same issue: http://www.devarticles.com/c/a/MySQL...PHP-and-MySQL/
Hopefully you'll find it useful too.

[ParaSnake]

This is as easy as puttng a text in MySQL

PHP Code:

$img = "<img scr = 'path'>";
mysql_query("INSERT INTO tbl(img_field) VALUES('".$img."') "); 


Output it:

PHP Code:

//connect to db
$query = mysql_query("SELECT * FROM tbl");
while($a = mysql_fetch_assoc($query) {
          $img_path = $a['img'];
          echo $img."<BR>";
} 


Hope this is what you are looking for.

[Uncle Ghed]

Both of you have helped a lot!! Thanks! ^^

[ParaSnake]

nah,not me,i read the articles on devshed and i realized that i dint got what u mean corectly,sorry

[Uncle Ghed]

As a matter of fact....
What I'm trying to do is a table that has an Id, a few other fields and a blob field, containing the image. This way when I call my row my Image is associated via database to my other fields, containing a title, a news, a date, etc...
Now: how the heck do I display this image? do I need an extra field called, uhm, "nameImage" or something? or do I just display it with the $fileType $fileContent variables?
I'm getting pretty messed up...

[scrowler]

if you wanna keep the original image name, then yes you need another column. basically do this:

get data from database
set header type to image : header("Content-type: image/jpeg"); etc
echo the data