Максим Шептуха » 17 янв 2005, 14:55
Чуть не забыл: вот тестовый скрипт...
Код: Выделить всё
<?
Header("Expires: Mon, 26 Jul 1997 01:00:00 GMT");
Header("Last-Modified: ".gmdate("D, d M Y H:i:s")."GMT");
Header("Cache-Control: no-cache, must-revalidate");
Header("Pragma: no-cache");
$Conn=ocilogon("HR","pfvsckjdpfvsckjd");
$SelectPhoto="select photo from photos where recno = 43890";
$PreSelectPhoto=ociparse($Conn,$SelectPhoto);
$DHumanPhoto=ocinewdescriptor($Conn,OCI_D_LOB);
ocidefinebyname($PreSelectPhoto,"PHOTO",&$DHumanPhoto);
ociexecute($PreSelectPhoto);
$HumanPhoto=ociloadlob($DHumanPhoto);//->load();
if(IsSet($HumanPhoto)){
echo"Such variable exists. ".$HumanPhoto;
}else{
echo"Such variable doesn't exist.";
}
ocifreestatement($PreSelectPhoto);
ocilogoff($Conn);
$TFFile="Photos/1.jpg";
$TFOpen=fopen($TFFile,"w+");
fputs($TFOpen,$HumanPhoto);
fclose($TFOpen);
//Header("Location: Photos/1.jpg?".time());
?>
Чуть не забыл: вот тестовый скрипт...
[code]<?
Header("Expires: Mon, 26 Jul 1997 01:00:00 GMT");
Header("Last-Modified: ".gmdate("D, d M Y H:i:s")."GMT");
Header("Cache-Control: no-cache, must-revalidate");
Header("Pragma: no-cache");
$Conn=ocilogon("HR","pfvsckjdpfvsckjd");
$SelectPhoto="select photo from photos where recno = 43890";
$PreSelectPhoto=ociparse($Conn,$SelectPhoto);
$DHumanPhoto=ocinewdescriptor($Conn,OCI_D_LOB);
ocidefinebyname($PreSelectPhoto,"PHOTO",&$DHumanPhoto);
ociexecute($PreSelectPhoto);
$HumanPhoto=ociloadlob($DHumanPhoto);//->load();
if(IsSet($HumanPhoto)){
echo"Such variable exists. ".$HumanPhoto;
}else{
echo"Such variable doesn't exist.";
}
ocifreestatement($PreSelectPhoto);
ocilogoff($Conn);
$TFFile="Photos/1.jpg";
$TFOpen=fopen($TFFile,"w+");
fputs($TFOpen,$HumanPhoto);
fclose($TFOpen);
//Header("Location: Photos/1.jpg?".time());
?>[/code] :)