FILES UPLOAD IN ORACLE

Anon

i'm using php to try to upload files/images from the web into a
database as LOBS, but wiothout any success. i have read all the
necessary documentation, visited many different websites, and
even emailed half a dozen people in the quest to find the answer
to this question. but it seems as if no one knows the answer to
the problem.

this is probably my last attempt in the search for the answser. the
problem is that no files/images are transferring across from the
user agent(web front end) to the database. therefore i'm pleading
with anybody that's out there to please help me with this problem
i would really appreciate the help
GG

Anon

Hello,

try this sample. Only thing you have to adjust is the db connection <your_conn>.

<?
require "DB.php";
?>

<?php
// code that will be executed if the form has been submitted:

if ($submit) {

// $form_data contains the temporary filename of the uploaded file

$lob = OCINewDescriptor(<your_conn>, OCI_D_LOB);
  echo $form_data;
$query = "INSERT INTO ATTACHEMENTS (ATT_ID,ATT_EMP_ID,ATT_DESCRIPTION, ATT_FILE, ATT_name,ATT_TYPE) values ".
"(SEQ_ATT_ID.NEXTVAL,1,'$form_description',EMPTY_BLOB(),'$form_data_name','$form_data_type') returning ATT_FILE into :ATT_FILE";
$stmt = OCIParse(<your_conn>,$query);
OCIBindByName($stmt, ':ATT_FILE', &$lob, -1, OCI_B_BLOB);
OCIExecute($stmt, OCI_DEFAULT);
if($lob->savefile($form_data)){
OCICommit(<your_conn>.);
echo "Blob successfully uploaded\n";
}
else{
echo "Couldn't upload Blob\n";
}
OCIFreeStatement($stmt);
OCILogoff(<your_conn>);
}
else {

// else show the form to submit new data:

<form method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
File Description:<br>
<input type="text" name="form_description"  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>