Uploading files into a MySQL database using PHP

[Atli]

You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t.

In situations where your PHP application needs to store entire files, the preferred method is to save the file onto the server’s file-system, and store the physical location of the file in your database. This is generally considered to be the easiest and fastest way to store files.

However, you may find yourself in situations where you would want to keep the file itself with the other data in your database. This gives you - or rather: MySQL - complete control over the file data, rather than just the location of the file on the server.

There are some downsides to this method though, such as; decreased performance and added complexity to both your PHP code and your database structure. This is something you should carefully consider before using this in a real-life application.

Having said that, this article demonstrates how you can upload a file from a browser into MySQL, and how to send the files back to the browser.

Before you start
To get through this smoothly, you should be familiar with the following:

• PHP Basics
• MySQL Basics
• Using MySQL in PHP (mysqli)
• HTML Forms and how to handle POST data in PHP.

The battle plan
As with all programs, before we start writing we need to plan a little ahead. Just so we know what we are going to write before we write it.

Before we start on the program, we need to design the database. This is not a complex design, as we are not talking about creating some complex filing system. We only need a single table, containing a BLOB field for our file and various other fields to store information on our file, such as name, size, type.

Now then. The first phase of the program is getting the file from our users onto the server where our PHP can interact with it. This is the simplest part of the process, requiring only a basic HTML form.

The second phase involves reading the uploaded file, making sure it was uploaded successfully and adding it to the database. This is a similar process as the one used when uploading a file to the file-system, but using the MySQL functions rather than the file-system functions.

The third phase is to list all files that have been uploaded and saved on the database, with a link so it can be downloaded. The only problem here would be the fact that the file does not exists on the server, so how do we create a link to it? That is a problem handled by phase 4, all we need to do in phase 3 is create a link with the ID of the file to be downloaded embedded in the URL.

The fourth, and final, part is the one that is most confusing about this process. The part where we fetch the file and send it to the client's browser.
We start by using the MySQL functions, and the ID sent by phase 3, to fetch the file data from the database. Then we set a few headers, letting the browser know what to expect, before finally sending the contents of the file.

Now, using this summary as a guide, lets start writing our program.

Phase 0: Building a database
The database is simple. One table with a BLOB field for the file data and a few fields for various pieces of information relating to the file:

CREATE TABLE `file` (
    `id`        Int Unsigned Not Null Auto_Increment,
    `name`      VarChar(255) Not Null Default 'Untitled.txt',
    `mime`      VarChar(50) Not Null Default 'text/plain',
    `size`      BigInt Unsigned Not Null Default 0,
    `data`      MediumBlob Not Null,
    `created`   DateTime Not Null,
    PRIMARY KEY (`id`)
)
 

As you see, we store the file name, including the extension.
We have the mime type, which we use to let the browser know what kind of file we are dealing with.
The size of the file in bytes.
And finally the data itself, in a MediumBlob field.

Phase 1: Uploading the file
Now, we need to get the file from the user. The table we designed does not require any additional information from the user, so we will make this simple and create a HTML form with only a single "file" input field and a submit button:

<!DOCTYPE html>
<head>
    <title>MySQL file upload example</title>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
    <form action="add_file.php" method="post" enctype="multipart/form-data">
        <input type="file" name="uploaded_file"><br>
        <input type="submit" value="Upload file">
    </form>
    <p>
        <a href="list_files.php">See all files</a>
    </p>
</body>
</html>

Note the third attribute of the <form> element, "enctype". This tells the browser how to send the form data to the server. As it is, when sending files, this must be set to "multipart/form-data".
If it is set any other way, or not set at all, your file is probably not going to be transmitted correctly.

At the bottom, we have a link to the list we will create in phase 3.

Phase 2: Add the file to the database
In the form we built in phase 1, we set the action property to "add_file.php". This is the file we are going to build it this phase of the process.

This file needs to check if a file has been uploaded, make sure it was uploaded without errors, and add it to the database:

<?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 = new mysqli('127.0.0.1', 'user', 'pwd', 'myTable');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
 
        // Gather all required data
        $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
        $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
        $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
        $size = intval($_FILES['uploaded_file']['size']);
 
        // Create the SQL query
        $query = "
            INSERT INTO `file` (
                `name`, `mime`, `size`, `data`, `created`
            )
            VALUES (
                '{$name}', '{$mime}', {$size}, '{$data}', NOW()
            )";
 
        // Execute the query
        $result = $dbLink->query($query);
 
        // Check if it was successfull
        if($result) {
            echo 'Success! Your file was successfully added!';
        }
        else {
            echo 'Error! Failed to insert the file'
               . "<pre>{$dbLink->error}</pre>";
        }
    }
    else {
        echo 'An error accured while the file was being uploaded. '
           . 'Error code: '. intval($_FILES['uploaded_file']['error']);
    }
 
    // Close the mysql connection
    $dbLink->close();
}
else {
    echo 'Error! A file was not sent!';
}
 
// Echo a link back to the main page
echo '<p>Click <a href="index.html">here</a> to go back</p>';
?>
 
 

Phase 3: Listing all existing files
So, now that we have a couple of files in our database, we need to create a list of files and link them so they can be downloaded:

<?php
// Connect to the database
$dbLink = new mysqli('127.0.0.1', 'user', 'pwd', 'myTable');
if(mysqli_connect_errno()) {
    die("MySQL connection failed: ". mysqli_connect_error());
}
 
// Query for a list of all existing files
$sql = 'SELECT `id`, `name`, `mime`, `size`, `created` FROM `file`';
$result = $dbLink->query($sql);
 
// Check if it was successfull
if($result) {
    // Make sure there are some files in there
    if($result->num_rows == 0) {
        echo '<p>There are no files in the database</p>';
    }
    else {
        // Print the top of a table
        echo '<table width="100%">
                <tr>
                    <td><b>Name</b></td>
                    <td><b>Mime</b></td>
                    <td><b>Size (bytes)</b></td>
                    <td><b>Created</b></td>
                    <td><b>&nbsp;</b></td>
                </tr>';
 
        // Print each file
        while($row = $result->fetch_assoc()) {
            echo "
                <tr>
                    <td>{$row['name']}</td>
                    <td>{$row['mime']}</td>
                    <td>{$row['size']}</td>
                    <td>{$row['created']}</td>
                    <td><a href='get_file.php?id={$row['id']}'>Download</a></td>
                </tr>";
        }
 
        // Close table
        echo '</table>';
    }
 
    // Free the result
    $result->free();
}
else
{
    echo 'Error! SQL query failed:';
    echo "<pre>{$dbLink->error}</pre>";
}
 
// Close the mysql connection
$dbLink->close();
?>

Phase 4: Downloading a file
This part is the one that usually causes the most confusion.

To really understand how this works, you must understand how your browser downloads files. When a browser requests a file from a HTTP server, the server response will include information on what exactly it contains. These bits of information are called headers. The headers usually include information on the type of data being sent, the size of the response, and in the case of files, the name of the file.

There are of course a lot of other headers, which I will not cover here, but it is worth looking into!

Now, this code. We start simply by reading the ID sent by the link in phase 3. If the ID is valid, we fetch the information on the file who's ID we received, send the headers, and finally send the file data:

<?php
// Make sure an ID was passed
if(isset($_GET['id'])) {
// Get the ID
    $id = intval($_GET['id']);
 
    // Make sure the ID is in fact a valid ID
    if($id <= 0) {
        die('The ID is invalid!');
    }
    else {
        // Connect to the database
        $dbLink = new mysqli('127.0.0.1', 'user', 'pwd', 'myTable');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
 
        // Fetch the file information
        $query = "
            SELECT `mime`, `name`, `size`, `data`
            FROM `file`
            WHERE `id` = {$id}";
        $result = $dbLink->query($query);
 
        if($result) {
            // Make sure the result is valid
            if($result->num_rows == 1) {
            // Get the row
                $row = mysqli_fetch_assoc($result);
 
                // Print headers
                header("Content-Type: ". $row['mime']);
                header("Content-Length: ". $row['size']);
                header("Content-Disposition: attachment; filename=". $row['name']);
 
                // Print data
                echo $row['data'];
            }
            else {
                echo 'Error! No image exists with that ID.';
            }
 
            // Free the mysqli resources
            @mysqli_free_result($result);
        }
        else {
            echo "Error! Query failed: <pre>{$dbLink->error}</pre>";
        }
        @mysqli_close($dbLink);
    }
}
else {
    echo 'Error! No ID was passed.';
}
?>

Any decent browser should be able to read the headers and understand what type of file this is, and that it is to be downloaded, not opened.

The finish line
So, as you see, this is not as complex as one might think.

This code is of course only written for demonstration purposes and I would not recommend using it without adding a little extra security. Un-edited, this code would basically allow anybody to upload anything to your server, which is not a good idea!

I hope this has been helpful, and I wish you all the best.

See you around,
- Atli Þór

Revisions

• August 20th, 2008 - Replaced the old mysql functions with the improved mysqli functions.
• December 12th, 2009 - Updated the introduction to include a bit more detail on the pros and cons of this method. Also improved the code structure a bit. Replaced the mysqli procedural functions with their OOP counterparts. (Thanks to kovik for pointing out the need for these changes!)

[santhanalakshmi]

hi,

Its uploading to my database.Thanks its working fine.

[mattgnr]

Hi,

I am having a slight problem when downloading the file.

E.g. the file upload is called Unit 1 Lesson 2.pdf. When i go to download the file, if i choose the 'open' option, Adobe opens fine. If i click on 'save' however, it just saves the file as 'Unit' without the rest of the name and no extension.

Any ideas?

Follow Up: I have noticed that this is only a problem in Firefox. Works perfectly in IE.

My code to display can be found below:

<?php
// Make sure an ID was passed
if(isset($_GET['id'])) {
// Get the ID
    $id = intval($_GET['id']);
 
    // Make sure the ID is in fact a valid ID
    if($id <= 0) {
        die('The ID is invalid!');
    }
    else {
        // Connect to the database
        $dbLink = new mysqli('127.0.0.1', '####', '#####', '#####');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
 
        // Fetch the file information
        $query = "
            SELECT `mime`, `name`, `size`, `data`
            FROM `file`
            WHERE `id` = {$id}";
        $result = $dbLink->query($query);
 
        if($result) {
            // Make sure the result is valid
            if($result->num_rows == 1) {
            // Get the row
                $row = mysqli_fetch_assoc($result);
 
                // Print headers
                header("Content-Type: ". $row['mime']);
                header("Content-Length: ". $row['size']);
                header("Content-Disposition: attachment; filename=". $row['name']);
 
                // Print data
                echo $row['data'];
            }
            else {
                echo 'Error! No image exists with that ID.';
            }
 
            // Free the mysqli resources
            @mysqli_free_result($result);
        }
        else {
            echo "Error! Query failed: <pre>{$dbLink->error}</pre>";
        }
        @mysqli_close($dbLink);
    }
}
else {
    echo 'Error! No ID was passed.';
}
?>
 

[mirasol]

i used the given codes, how to add textbox and it will be save to mysql?

[mirasol]

<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>Teacher ID: </TD> 
       <TD><input name="subjects" size = "66%" /></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>

[mirasol]

what is the supply codes to list_file.php and add_file.php?

[mirasol]

add_file.php

<?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 = new mysqli('localhost', '', '', ''); 
            if(mysqli_connect_errno()) { 
                die("MySQL connection failed: ". mysqli_connect_error()); 
            } 
 
            // Gather all required data 
            $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
        $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']); 
            $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name'])); 
            $size = intval($_FILES['uploaded_file']['size']); 
 
            // Create the SQL query 
            $query = " 
                INSERT INTO `file` ( 
                    `name`, "this is my problem" (`t_id`,) `mime`, `size`, `data`, `created` 
                ) 
                VALUES ( 
                    '{$name}', '{$t_id}', '{$mime}', {$size}, '{$data}', NOW() 
                )"; 
 
            // Execute the query 
            $result = $dbLink->query($query); 
 
            // Check if it was successfull 
            if($result) { 
                echo 'Success! Your file was successfully added!'; 
            } 
            else { 
                echo 'Error! Failed to insert the file' 
                   . "<pre>{$dbLink->error}</pre>"; 
            } 
        } 
        else { 
            echo 'An error accured while the file was being uploaded. ' 
               . 'Error code: '. intval($_FILES['uploaded_file']['error']); 
        } 
 
        // Close the mysql connection 
        $dbLink->close(); 
    } 
    else { 
        echo 'Error! A file was not sent!'; 
    } 
 
    // Echo a link back to the main page 
echo '<p>Click <a href="add_file1.php">here</a> to go back</p>'; 
    ?>

[mirasol]

list_file.php

<?php 
// Connect to the database 
    $dbLink = new mysqli('localhost', '', '', ''); 
    if(mysqli_connect_errno()) { 
        die("MySQL connection failed: ". mysqli_connect_error()); 
    } 
 
    // Query for a list of all existing files 
    $sql = 'SELECT `id`, `t_id`, `name`, `mime`, `size`, `created` FROM `file`'; 
    $result = $dbLink->query($sql); 
 
 
    // Check if it was successfull 
    if($result) { 
        // Make sure there are some files in there 
        if($result->num_rows == 0) { 
            echo '<p>There are no files in the database</p>'; 
        } 
        else { 
            // Print the top of a table 
            echo '<table width="100%"> 
                    <tr> 
                        <td><b>Name</b></td> 
                <td><b>Teacher ID</b></td>
                    <td><b>Mime</b></td> 
                        <td><b>Size (bytes)</b></td> 
                        <td><b>Created</b></td> 
                        <td><b>&nbsp;</b></td> 
                    </tr>'; 
 
            // Print each file 
            while($row = $result->fetch_assoc()) { 
                echo " 
                    <tr> 
                        <td>{$row['name']}</td> 
                <td>{$row['t_id']}</td> 
                        <td>{$row['mime']}</td> 
                        <td>{$row['size']}</td> 
                        <td>{$row['created']}</td> 
                        <td><a href='get_file.php?id={$row['id']}'>Download</a></td> 
                <td><a href='delete_ac.php?id={$row['id']}'>delete</a></td>
                    </tr>"; 
 
            } 
 
            // Close table 
            echo '</table>'; 
        } 
 
        // Free the result 
        $result->free(); 
    } 
    else 
    { 
        echo 'Error! SQL query failed:'; 
        echo "<pre>{$dbLink->error}</pre>"; 
    } 
 
    // Close the mysql connection 
$dbLink->close(); 
    ?>

[LiuT]

Hi,

I am wonder if it will upload pdf files of size 2.13MB (1,238,590 bytes)? Thank you in advance.

Liu

[Dormilich]

with the necessary code, MySQLi and PDO should be able to.

[LiuT]

Hi Dormilich,

Thank you for the reply. I am new working with mysql and php. I am wonder it is any tutorial in how to do it. Any help will be appreciated and thank you in advance.

Liu

[Dormilich]

I don’t know any in particular, but the PHP Manual is always a good point to start (like this one)

[anton duric]

problem.
Hello
i need a view or download a jpg file stored in database.
I tried a code and it give me a error message :
http://bozita.sk/vystava/get_file.php?id=1

how can i fix it ?

[Atli]

@anton duric
I'm just getting a 404 error. The file doesn't exist.

[anton duric]

I don´t know when he upload file (name of folder),
i cannot locate a file in server.

[lulitta]

hi Atli.^_^
first thank you for this nice topic..this code is exactly what i need for my project..but i have faced 2 problems.


1. when i upload pdf or doc file and download it ,just strange characters appear such as "�"
ºT¨t³AKLÒy|òµ,~"
2.Warning: Cannot modify header information - headers already sent by .....error
i have tried all solutions you posted before but it still not working..

am using Apache 2.2
php5
mysql 5.
IE8
hope you can help me in this...

[Atli]

@lulitta
Hey.

Those would be a text representation of your file data. If your code fails to set the "Content-Type" header, your browser will assume it is receiving a HTML file and just display all the file data as text.

The Waring you posted should tell you where in your code the problem is. Can you post the full warning message here, and the lines in your code that the warning refers to?

You should also check out this article. It explains in detail why you get this warning, the most common causes and ways to work around them.

[lulitta]

this is my download_file.php

<html>
<?php 
// Make sure an ID was passed 
if(isset($_GET['id'])) { 
// Get the ID 
    $id = intval($_GET['id']); 
 
    // Make sure the ID is in fact a valid ID 
    if($id <= 0) { 
        die('The ID is invalid!'); 
    } 
    else { 
        // Connect to the database 
        $dbLink = new mysqli('localhost', '****', '****', '****'); 
        if(mysqli_connect_errno()) { 
            die("MySQL connection failed: ". mysqli_connect_error()); 
        } 
 
        // Fetch the file information 
        $query = " 
            SELECT mime, name, size, data 
            FROM file3 
            WHERE id = {$id}"; 
        $result = $dbLink->query($query); 
 
        if($result) { 
            // Make sure the result is valid 
            if($result->num_rows == 1) { 
            // Get the row 
                $row = mysqli_fetch_assoc($result); 
 
              header("Content-Type:".$row['FileMime']); 
              header("Content-Length:".$row['FileSize']); 
              header("Content-Disposition:attachment;filename=".$row['FileName']); 
 
                // Print data 
                echo $row['data']; 
            } 
            else { 
                echo 'This project has been deleted.'; 
            } 
 
            // Free the mysqli resources 
            @mysqli_free_result($result); 
        } 
        else { 
            echo "Error! Query failed: <pre>{$dbLink->error}</pre>"; 
        } 
        @mysqli_close($dbLink); 
    } 
} 
else { 
    echo 'Error! No ID was passed.'; 
} 
?>
</html>

it is not different from the one that you posted, just the host,username, password and database name are different ,but i observed when i hide headers it works with plain/text.
and display strange characters with application/pdf ..etc.

these are warnings for the three headers:
Warning: Cannot modify header information - headers already sent by (output started at C:\AppServ\www\download_file.php:2) in C:\AppServ\www\download_file.php on line 32

Warning: Cannot modify header information - headers already sent by (output started at C:\AppServ\www\download_file.php:2) in C:\AppServ\www\download_file.php on line 33

Warning: Cannot modify header information - headers already sent by (output started at C:\AppServ\www\download_file.php:2) in C:\AppServ\www\download_file.php on line 34
archive system is system that save old data in seartin place.

[Dormilich]

you start your file with <html>, that’s what’s causing the error.

[lulitta]

Dormilich i have tried to remove <html><body><head> tags before..but when i try to download any file, only popup window appears with save or open options for php file that am working with..!!! :(

[Dormilich]

only popup window appears with save or open options for php file that am working with..!!! :(

of course, that’s what line #34 does. force a download.

[lulitta]

yes it forces download but when i chose to save or open file just empty file opened..!! if i try to open pdf or doc files just empty file opened but it works with plain/text files..but i need it to work with pdf files :$

[Dormilich]

then I can only assume that there might be the headers wrong or the file doesn’t exist at the designated location.

[lulitta]

hmmm i have checked headers and files..nothing wrong with them..if i have 2 files, pdf and plain text files in the same location..plain text file works but pdf empty page...!!

thanx Dormilich for trying to help ^_^..any another suggestions!!

[Dormilich]

..any another suggestions!!

not without a demo page.

[ropata]

Great tutorial Atli

I was wanting to be able to add accompanying text along with uploading the file. I get I'd need to add text fields to the form and in sert new fields in the MySql database that would need populating but I can't figure out how I would gather that data in the add_file.php

Cheers

Rob

[Jim Gordon]

Would anyone happen to have a link to the older version of this code which doesnt use mysqli?

Much appreciated

Jimmy

[Sagar Joshi]

Hey Guys i have been in PHP coding for about 6 months and also tried out this very fantastic tutorial of downloading and uploading.... well upload works like charm! but so does download but when i download the file such as doc file or image file i am not able to view and image shows that it is not supported and word shows that it is corrupted or unsupported format! pls i need help! thanking you in advance!

[kovik]

@Jim Gordon
There's no reason to use mysql_* functions instead of MySQLi.

[Atli]

@Sagar Joshi
Hey.

If you are getting corrupted files, a likely reason is that PHP is printing errors or warnings into the file. To see those errors you can simply change line #32 in the get_file.php script so it reads: header('Content-Type: text/html');, and then you need to comment out line #34.

This should print the error, along with all the data, into your browser instead of you getting a download dialog. Then you can browse through it and read the errors/warnings being printed.

[Kenneth Roggers]

Nice Code. Thanks to the original author. May your days be long...

[Samuell Ngu]

Hi Atli,
I you help me change the mysqli to mysql?

<?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 = new mysqli('localhost', 'root', '###', '###');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
 
        // Gather all required data
        $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
        $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
        $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
        $size = intval($_FILES['uploaded_file']['size']);
 
        // Create the SQL query
        $query = "
            INSERT INTO `file` (
                `name`, `mime`, `size`, `data`, `created`
            )
            VALUES (
                '{$name}', '{$mime}', {$size}, '{$data}', NOW()
            )";
 
        // Execute the query
        $result = $dbLink->query($query);
 
        // Check if it was successfull
        if($result) {
            echo 'Success! Your file was successfully added!';
        }
        else {
            echo 'Error! Failed to insert the file'
               . "<pre>{$dbLink->error}</pre>";
        }
    }
    else {
        echo 'An error accured while the file was being uploaded. '
           . 'Error code: '. intval($_FILES['uploaded_file']['error']);
    }
 
    // Close the mysql connection
    $dbLink->close();
}
else {
    echo 'Error! A file was not sent!';
}
 
// Echo a link back to the main page
echo '<p>Click <a href="index.html">here</a> to go back</p>';
?>
 
 

[Dormilich]

I you help me change the mysqli to mysql?

the mysql_* functions are deprecated, thus it would be a waste of time.

[Hasan Baig]

I like above code that is very simple and useful
but its giving me error on
db->close();
while uploading the file

[Atli]

Hey Hasan.
Which file is it, and what exactly does the error say?

[marifard]

Hi,

Instead of phase 4, can I display the files such as images in a page instead from downloading?

Thanks
marifard

[dignat]

Hello Atli,
I used your code and everuthing is fine but I can not read word files properly when download them and pdfs are corrupt.
Cabn you help me , i used headers, but it is not working

[dignat]

hi atli,
i used your code, but i can not read properly msword document after dwnloading it.

[pavanipuppy]

hey hi..am new to this php stuff...so please help me..u have some .php files here...how should i compile or execute dis code??? is it automatically executed when it is called in .html page?? and how to make database connections for a .html file?? thanku in advance..

[Dormilich]

PHP code is neither compiled nor executed. it is automatically processed on a server with PHP installed (given the server is correctly configured). which also means that it doesn’t do anything in a .html page.

[shakhawat]

when i download file using php script message will be shown:
Object not found!

The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

If you think this is a server error, please contact the webmaster.
Error 404
localhost
10/31/11 09:29:10
Apache/2.2.2 (Win32) DAV/2 mod_ssl/2.2.2 OpenSSL/0.9.8b mod_autoindex_color PHP/5.1.4

[jennifersolomon]

Hi

you code works perfect for single file
but how do i modify it to select multiple files and upload it to the server

Thanks

[arashi23]

Hello~ I used your codes for self-practice and I encountered a problem when using this code. I was given this warning:

Warning: mysqli::mysqli() [mysqli.mysqli]: (42000/1049): Unknown database 'file' in C:\xampp\htdocs\test5\add_file.php on line 7
MySQL connection failed: Unknown database 'file'

Line 7 of the code:

$dbLink = new mysqli('localhost', '***', '***', 'file');

I've used the exact same codes as you've posted, the only difference is the user and password for the database. I've already created the 'file' table in my database though, so I'm not sure what was wrong. I'm using php 5.3.8 & MySQL 5.5.16

Maybe the problem lies with me using MySQL instead of MySQLi? Since the codes use MySQLi. Any help or pointers would be much appreciated since I'm really new to this PHP and MySQL thing. ^_^

[Dormilich]

the fourth parameter is the name of the database on the database server, not that of a table in a database.

[arashi23]

Oh! Thank you for pointing that out. ^^'

[xyzravi]

I have used the code of 'Atli' posted on Nov, 23 2007 to upload the images into the mysql database and it's working fine but i need some more help that is..

how to display image on browser that is stored in mysql database using php code?

Thanks.

[yogesh131]

hello ..
this is superb...
can you tell me how to delete a file and send through mail
thanks

[abelcher]

Hello,
i am using your code for uploading resumes to a database but i need to do a join to like them together. i was wondering if i could get some help on this.
this is my code to link them

$qr =  "SELECT job_seeker_info.id, job_resume.id ".
 "FROM job_seeker_info, job_resume ".
    "WHERE job_seeker_info.id = job_resume.id, and job_seeker_info.uname = '".$_SESSION['uname']."'"  ;

how can i get the correct id to show on the page for the link?

[zaza77]

there is the error occur after uploading the files..


Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'user'@'localhost' (using password: YES) in C:\xampp\htdocs\project open office easy learning\add_file.php on line 7
MySQL connection failed: Access denied for user 'user'@'localhost' (using password: YES)

[aziz123]

Hi Atli's,

Great tutorial just wondering could it be possible to demonstrate how to delete files within the list_files.php as I have tried and Dormilich has help me but still could not understand what I am doing wrong.

As I have stated in my post I am a self learning PHP and MYSQL and would love to see a guide from you on this so that I can learn from it and compare my code as well.

thanks

[sachin8289]

used same code as above but got error as below

Error! Failed to insert the file

Got a packet bigger than 'max_allowed_packet' bytes

how to get rid of this problem, i ma trying to upload 7mb single file