(Yes, I am following up to my own posting.)
Thanks your immediate response. I tried to solve the problem using the method given by you. But it's not working with oracle. Any how i found the solution for the same. I am attaching the sample code here for reference to PHP programmers.
Here two php files are there.
one file is:-uploaimage.php
second file is:-display.php
The first file which will take the input (the image you want upload. You can upload any image file. but display.php is limited to .gif file only)from the client browser and is going to submit to the same page, which is going to store the images in oracle database. The second file display all those images(.gif only) in the client browser.
uploadimage.php follows here.
<HEAD><TITLE>Store binary data into SQL Database</TITLE></HEAD>
<BODY>
<?php
if ($submit) {
$data = fread(fopen($form_data, "r"), filesize($form_data));
//You have to pass Appropriate username, Password,Serveice name
$db = OCILogon("scott","tiger","grk");
$stmt = OCIParse($db,"insert into blob_table values ($id,EMPTY_BLOB()) returning id,IMG into :id,:lob");
$lob = OCINewDescriptor($db);
OCIBindByName($stmt,":ID",$id,32);
OCIBindByName($stmt,":LOB",$lob,-1,SQLT_BLO😎;
// we cannot use autocommitt here
$exec_result=OCIExecute($stmt,OCI_DEFAULT);
$lob->save($data);
echo "$form_data id:$id\n";
OCICommit($db);
if(!$exec_result){
print "Error Occured".OCIError($conn);
}else{
OCICommit ($db);
print "<p>This file has been uploaded into Database ";
}
} else {
?>
<form method="post" action="uploadimage.php" enctype="multipart/form-data">
File Description:<br>
<input type="text" name="id" size="40">
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000">
<br>File to upload/store in database:<br>
<input type="file" name="form_data" size="40">
<p><input type="submit" name="submit" value="submit">
</form>
<?php
}
?>
</BODY>
display.php follows here.
<body>
<?
//You have to pass Appropriate username, Password,Serveice name
$db = OCILogon("scott","tiger","grk");
$stmt = OCIParse($db,"select * from blob_table order by id");
OCIExecute($stmt);
$img='';
$count=0;
while (OCIFetchInto($stmt,$arr,OCI_ASSOC)) {
$count++;
echo "id: ".$arr[ "ID" ]."\n";
$img= ($arr[ "IMG" ]->load());
if($fp = fopen ("test".$count.".gif", "w")){
fwrite ($fp, $img);
echo" <img src=\"test".$count.".gif\"><br><hr>";
}else{
echo ("failed to open the file");
}
}
?>
</body>
I hope it will help other programs.
thanks
