SAVE AND RESTORE FILES TO POSTGRESQL (PHP CLASS)

Поиск
Список
Период
Сортировка
Искать

SAVE AND RESTORE FILES TO POSTGRESQL (PHP CLASS)

От:
ivan valadares <ivan.valadares@ydreams.com>
Дата:





-------- Database ----------------

CREATE TABLE images (
    name text,
    image oid,
    filesize bigint
);


---------- File to Database Exemple ------------
include("image.php");
$filetosave="HPIM0551.JPG" // file to save in the database
$loId = addImage($conn,$filetosave);
$id_Desc = $filetosave;
$fsize=filesize("HPIM0551.JPG");
$sql = "INSERT INTO images(name,value,filesize) 
VALUES('$id_Desc','$loId','$fsize')";
pg_query($sql);



-------- Database to Files Exemple ------------
include("image.php");
$sql = "Select value,name,filesize FROM images";
$res = Query($conn,$sql);
$dir = "C:\\images\\"; // directory
while(Fetch($res))
{
if (Cell($res,2))
{
 WriteImageToFile(Cell($res,0),$dir.Cell($res,1),Cell($res,2));
}
}


FAQ