I need help with uploading file to mysql DB

superdos · June 25th, 2004, 02:43 AM

my site is hosted by server that its REGISTRY GLOBLAS are OFF
Please read the code below, and tell me why cant I upload file to DB?
Its only upload the binary data but not the file name,size & type, can anyone tell my why ?

<HTML>
<HEAD><TITLE></TITLE></HEAD>
<BODY>

<?php
  $sub_price = $_POST['submit'];
  $idprice = $_POST['priceid'];
  $f_data = $_POST['form_data'];

  if (isset($sub_price)) {

     $p_date = date("W/Y");

     include("../dbconnect.php");

     $p_data = addslashes(fread(fopen($f_data, "rb"), filesize($f_data)));

     //inserting the file info to the first table.
     $result=mysql_query("REPLACE INTO price VALUES ('$idprice', '$f_data_name','$f_data_size','$f_data_type','$p_d ata','$p_date')");

     if (!$result) {
        die('Error inserting the file info');
     }

     echo

     "<center>File <b>$f_data_name</b> update successfully<BR><BR><a href='www.crg.co.il'>To CRG Site</a> ";

     mysql_close();

  } else {

?>

<FORM method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
      <p align="center" dir="ltr"> 
      <INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000">

      <INPUT TYPE="hidden" name="priceid" value="0">

      <span style="background-color: #FF0000">

      Price List UPDATE - Week <? echo date("W/Y") ?></span>

      <BR>
      <BR>
      <br>
      Price List File Upload - ONLY ZIP FILE !!!
      <br>
      <br>
      <INPUT type="file" name="form_data" size="20" dir="ltr">

      <INPUT type="submit" name="submit" value="submit">
      <INPUT type="reset" name="reset" value="reset">
      </P>
   </FORM>

<?php
  }
?>
</BODY>
</HTML>

richard.york · June 26th, 2004, 08:34 PM

Quote:

quote:Originally posted by superdos

Its only upload the binary data but not the file name,size & type, can anyone tell my why

You're using the wrong superglobal to access the data contained in the file. use the $_FILES superglobal, which is where information about the uploaded file is kept once the file reaches the server.

I wrote a tutorial on this exact topic, have a read of it:
http://p2p.wrox.com/topic.asp?TOPIC_ID=11883

You have a few other errors as well, $PHP_SELF isn't available if register_globals is turned off, you must access this from its superglobal array.. $_SERVER['PHP_SELF']

Regards,
Rich

::::::::::::::::::::::::::::::::::::::::::
The Spicy Peanut Project
http://www.spicypeanut.net
::::::::::::::::::::::::::::::::::::::::::

superdos · June 27th, 2004, 01:50 AM

Thank you very very much !!!! :D:)