uploading files to MySQL DB

ninag

How do I upload differnt types of files to mySql database using php ? I cant seem to find the code i need to do it....

I use a browse button to find the file and then i have an upload button to upload it to the database.

please help !!

Anon

You need to do an insert query. Post the code you have and we will help.

What type of files are you loading?

ninag

image and .doc files,

<?php
$link = mysql_connect("*********", "ninag", "h0r$e$");
if (!$link)
die("Couldn't connect to MySQL");
$database ="ninag";
mysql_select_db($database) or die ("Couldn't open database);

$query = "INSERT INTO details(name, title) values($author, $title);
mysql_query($query)
or die("Couldn't submit details".mysql_error());

  <form name="BookDetails" method="post" action="" enctype="multipart/form-data">
    <table width="75%" border="0" height="126">
      <tr> 
        <td height="62" valign="top"><font color="#000000">Please select file 
          for upload:</font></td>
        <td width="203" valign="top"><font color="#000000"> 
          <input type="file" name="file">
          </font></td>
        <td width="139" valign="top"> 
          <input type="submit" name="Upload" value="Upload">
        </td>
      </tr>
      <tr> 
        <td height="68" width="186"></td>
        </tr>
    </table>
    <p align="left">&nbsp;</p>
  </form>
  mysql_close($link);
	?>

Anon

You just need a max_file_size hidden variable after your <form> tag.

Where the value is the maximum allowable size (in bytes).