PHP PDO ODBC将一个文件夹的文件装载到MySQL数据库BLOB列,并将BLOB列下载到另一个文件夹

getMessage();
}

$arrFiles = array();
$iterator = new FilesystemIterator("InputFiles");

foreach ($iterator as $entry) {
    $arrFiles[] = $entry->getFilename();
    echo ( $entry->getFilename());
    echo ( $entry->getPathname());

    $blob = fopen($entry->getPathname(), 'rb');
    $sql = "INSERT INTO gallery(name,image) VALUES(:name,:image)";
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(':name', $entry->getFilename());
    $stmt->bindParam(':image', $blob, PDO::PARAM_LOB);
    $stmt->execute();
}
?>

getMessage();
}

$sql = "SELECT name,image FROM gallery";
$stmt = $pdo->query($sql);
while ($row = $stmt->fetch()) {
    $filehandle = fopen("DownLoadFiles/" . $row[name], 'wb');
    fwrite($filehandle, $row[image]);
    fclose($filehandle);
}
?>