Re: EXAMPLE: How to store pictures in Mysql database

[James Zapico]

For the insert script:

$picture = fopen('path/to/file');
$data = fread($picture, filesize('path/to/file'));
$sqlpic = mysql_excape_string($data);

//It's good to find the mime type for later
//if the mime_magic extension is enabled
$mime = mime_content_type('path/to/file'))
//or on unix/linux
$mime = exec("file -bi path/to/file"

mysql_query("INSERT INTO `pictures` (`type`, `pic`) VALUES ('$mime', '$sqlpic')");


The display script should act like a picture:

$result =mysql_query("SELECT * FROM `picture` WHERE id = 1");

$picture = mysql_fetch_array($result);
header("Content-type: ". $picture['type']);
echo $picture['pic'];

That's it.