Leer directorio de archivos y cargarlos a BD como Bytea

[alvaro_trewhela]

Mira esto hice con mysqli y me anduvo muy bien:

Carga:

Código PHP:

<?php
 
//Config
 
$d = "dir/subdir"; //Direction without / final
 
$db_data = array(
"server" => "server", //DB server
"user" => "user", //DB user
"pass" => "pass", //DB pass
"db" => "db", //Data Base
"table" => "table" //DB table
);
 
//End config
 
$mysqli = new mysqli($db_data["server"], $db_data["user"], $db_data["pass"], $db_data["db"]);
 
$dir = scandir($d);
 
for($k=0;$k<sizeof($dir);$k++){
    if($dir[$k] != "." && $dir[$k] != ".." && !is_dir("$d/".$dir[$k])){
    $file = "$d/".$dir[$k];
    $name = $dir[$k];
    $size = filesize($file);
    
    $fo = finfo_open(FILEINFO_MIME_TYPE);
    $mime = finfo_file($fo, $file);
    finfo_close($fo);
    
    $fop = fopen($file,"r");
    $data = $mysqli->real_escape_string(fread($fop,$size));
    fclose($fop);
 
    $mysqli->query("INSERT INTO ".$db_data["table"]." (name, size, mime, data) VALUES ('$name', '$size', '$mime', '$data')");
    }
}
 
?>
 

Download:

Código PHP:

<?php
 
$idFile = 3; //someway to get the id of file
 
 
//Config
 
$db_data = array(
"server" => "server", //DB server
"user" => "user", //DB user
"pass" => "pass", //DB pass
"db" => "db", //Data Base
"table" => "table" //DB table
);
 
//End config
 
$mysqli = new mysqli($db_data["server"], $db_data["user"], $db_data["pass"], $db_data["db"]);
 
$file = $mysqli->query("SELECT * FROM ".$db_data["table"]." WHERE id='$idFile'")->fetch_assoc();
$name = $file["name"];
$size = $file["size"];
$data = $file["data"];
 
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename="'.$name.'"');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Length: '.$size);
echo $data;
exit;
 
?>
 

Y mi tabla:

id: primary ai
name: varchar
size: int
mime: varchar
data: longblob

Tu dale la longitud y cotejamiento a toda la tabla

Eso, falta las validaciones, pero espero haber ayudado.

Saludos