Need help inserting images into blob field from jpg files.

[jchapa]

Kudos to all ,

I am trying to facilitate the process of importing some jpg files I have into a blob field on MySQL. I wanted to get the filename and blob, however, I am encountering a wall when attempting to read the files into my database. Any help is appreciated. Below is the code I have been manipulating to no avail.

<?php
mysql_connect ("localhost","root");
mysql_select_db("sou");

$dirPath = "\relative\path\to\files";
$handle=opendir($dirPath);
while (false!==($file = readdir($handle))) {
if ($file != "." && $file != "..") {
writeToBlob($file, $dirPath);
}
}
closedir($handle);

function writeToBlob($file, $dirPath) {

// Read File
$newHandle = fopen($dirPath . "/" . $file, "rb");
$contents = fread ($newHandle, filesize ($dirPath . "/" . $file));
fclose($newHandle);

// Write it to the DB
$sql = "INSERT INTO img (filename, photo) values ('".$contents_name."','".$contents."')";
mysql_query($sql);
$id=mysql_insert_id();

}

?>

[jchapa]

Hello to all,

Well my intention was to take alot of pictures that I got for a sex offender program I am working on and have php automatically insert the filename and image into a blob field and varchar field for the filename. After several hours of fiddling with my code I got it to work. So if you need to grab pictures from a directory and store the filename and image inside the database where the image is stored in the blob field here is the remedy. I hope it saves someone some time and frustration trying to get help.

<?php
//Replace localhost and port(3306) with your values port not required, and username.
$conn = mysql_connect("localhost:3306","root");
//Replace database name (sou) with your database name.
$db = mysql_select_db("sou");
//Replace with your image directory.
$dir = "/apache/htdocs/img";
//If statement that reads the image directory
if (is_dir($dir)) {
if ($dh = opendir($dir)) {
while (($file = readdir($dh)) !== false) {
//The If statement below bypasses the two files that exist in Winddows/Dos directories.
//and eliminates "permission denied error" that would otherwise be produced if left out.
if ($file != "." && $file != ".."){
writeToBlob($file, $dir);
}
}
closedir($dh);
}
}
function writeToBlob($file, $dir) {
//Replace localhost and port(3306) with your values port not required, and username.
$conn = mysql_connect("localhost:3306","root");
//Replace database name (sou) with your database name.
$db = mysql_select_db("sou");
// Reads the filename and prepares data to be placed in a blob field
$newHandle = addslashes(fread(fopen($dir."/".$file, "rb"), filesize($dir."/".$file)));

// Write it to the DB INSERT INTO TABLENAME (FIELD1,FIELD2) VALUES ('$String1','String2')
mysql_query("INSERT INTO img (filename,pic) VALUES ('$file','$newHandle')");
mysql_close();

}
?>