function addImage($conn,$filename)
{
// Open and read the file that was uploaded
$fp = fopen($filename, "r");
if($fp == false)
echo "Error opening file";
// Begin a PostgreSQL transaction
pg_exec("begin");
// create the large object and get the lo id
$lo_id = pg_locreate();
// have postgresql open the large object for writing
$lo_fp = pg_loopen($lo_id, "w");
// for ever 8192 bytes of the uploaded file
while($nbytes = fread($fp, 8192)) {
// write to the large object
$tmp = pg_lowrite($lo_fp, $nbytes);
// handle possible error
if($tmp < $nbytes) {
echo "error while writing large object";
}
}
// close the large object
pg_loclose($lo_fp);
// commit the postgresql transaction
pg_exec("commit");
// close the uploaded file
fclose($fp);
if (!is_int($lo_id)) {
// return false
return false;
}
if (is_int($lo_id)) {
// return large object id
return $lo_id;
}
}
function ReadImage($lo_id,$filesize)
{
pg_exec("begin");
<?
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);
?>
