Uploading files into a MySQL database using PHP

**ririe** · Jun 10 '09, 07:10 AM

show me your codes for upload

**roseple** · Jun 10 '09, 07:18 AM

Oki here's my code.

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<FORM METHOD="post" ACTION="add_file.php" ENCTYPE="multipart/form-data">
<INPUT TYPE="hidden" NAME="MAX_FILE_SIZE" VALUE="1000000">
<INPUT TYPE="hidden" NAME="action" VALUE="Upload">
 <TABLE BORDER="1" cellspacing="1" cellpadding="3">
  <TR>
   <TD>Subject: </TD>
   <TD><input name="subjects" size = "66%" /></TD>
  </TR>
  
  <TR>
   <TD>Client Name: </TD>
   <TD><input name="clientname" size = "35%" id="clientname" /></TD>
  </TR>
  
  <TR>
   <TD>File: </TD>
   <TD><INPUT type="file" NAME="uploaded_file"></TD>
  </TR>
  <TR>
   <TD COLSPAN="2"><INPUT TYPE="submit" VALUE="Upload"></TD>
  </TR>
 </TABLE>
</FORM>



<?php
# Check if a file has been uploaded
if(isset($_FILES['uploaded_file'])) 
{
    # Make sure the file was sent without errors
    if($_FILES['uploaded_file']['error'] == 0) 
    {
        # Connect to the database
        $dbLink = mysql_connect("localhost", "root", "777") or die (mysql_error());
		mysql_select_db("filestorage", $dbLink) or die(mysql_error());
		
        /*if(mysql_connect()) {
            die("MySQL connection failed: ". mysql_error());
        }*/
 
        # Gather all required data
        $name = mysql_real_escape_string($_FILES['uploaded_file']['name']);
        $mime = mysql_real_escape_string($_FILES['uploaded_file']['type']);
        $size = $_FILES['uploaded_file']['size'];
        $data = mysql_real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
 
        # Create the SQL query
        $query = "
            INSERT INTO file_upload (
                FileName, FileMime, FileSize, FileData, subjects, clientname, Created
            )
            VALUES (
                '{$name}', '{$mime}', {$size}, '{$data}', '{$subjects}','{$clientname}', NOW()
            )";
 
        # Execute the query
        $result = mysql_query($query, $dbLink);
 
        # Check if it was successfull
        if($result) 
        {
            echo "Success! Your file was successfully added!";
        }
        else 
        {
            echo "Error! Failed to insert the file";
            echo "<pre>". mysql_error($dbLink) ."</pre>";
        }
    }
    else 
    {
        echo "Error! 
                An error accured while the file was being uploaded. 
                Error code: ". $_FILES['uploaded_file']['error'];
    }
 
    # Close the mysql connection
    mysql_close($dbLink);
}

# Echo a link back to the mail page

echo "<p><a href='list.php'>Click here to see all Files.</a></p>"; 
?>
</body>
</html>

**ririe** · Jun 10 '09, 07:31 AM

I already try your code but there is nothing wrong with it and I can upload the pdf file. What is actually the error come out??

**roseple** · Jun 10 '09, 07:35 AM

Error! An error accured while the file was being uploaded. Error code: 2
Notice: Undefined variable: dbLink in c:\Inetpub\wwwr oot\uploadingfi les\add_file.ph p on line 86

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in c:\Inetpub\wwwr oot\uploadingfi les\add_file.ph p on line 86

**ririe** · Jun 10 '09, 07:40 AM

what is the code on line 82??

**ririe** · Jun 10 '09, 07:41 AM

sorry what is the code on line 86??

**roseple** · Jun 10 '09, 07:49 AM

mysql_close($db Link); //line 86

**roseple** · Jun 10 '09, 07:50 AM

That warning and error only appear if pdf file was being uploaded.

**ririe** · Jun 10 '09, 07:58 AM

As I remember you said that you are using mysql instead of mysqli..
I think you should change and use mysql as I believe mysql does not support dblink. So better you change all to mysqli..Try it first

**ririe** · Jun 10 '09, 07:58 AM

Sorry I mean you should use mysqli as mysql does not support dblink

**Atli** · Jun 10 '09, 07:59 AM

ririe and roseple,

Please use [code] tags when you post you code examples.

[code] code goes here [/code]

Thanks.

**ririe** · Jun 10 '09, 08:03 AM

Sorry Atli...Next time I will use code tag

**Atli** · Jun 10 '09, 08:07 AM

The problem there is explained here. (Error code #2).

Your form has a MAX_FILESIZE field, who's value is to low to upload your files:

Code:

<input type="hidden" name="MAX_FILE_SIZE" value="30000" />

Increase that and it should work again.

Also, the error on line #86 has nothing to do with the fact you are using the old mysql extension.
It's because you open your database connection inside the if statement, so when the upload fails it skips it and goes right to the else clause without ever opening it, where it tries to close it, obviously failing.

Edit,
No, on second glance, the mysql_close call is outside the if/else block altogether.
Move it inside the if statement and that error is fixed. (The one on line #86, anyways)

**roseple** · Jun 10 '09, 08:09 AM

Sorry Atli.. next time I will use code tag too.

**roseple** · Jun 10 '09, 08:28 AM

Atli was right, I move the connection of database outside the if statement and the error regrading mysql_close(); was gone.

In max_file_size.. I put 1 000 000. And pdf file is already working, but some pdf file didn't work. Maybe because they are a too large file. Is 1000000, the maximum file size I can put?

Uploading files into a MySQL database using PHP

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment