Atli 5,058
Expert 4TB
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: 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> </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!)
221 366609
This whole idea of placing files in database BLOB fields, I get the impression it generally isn't a good idea. At least, it does seem quite unpopular. Could you delve a little into the pros and cons of BLOB versus filesystem options for storage of files on the server.
Thanks.
Ifedi.
This whole idea of placing files in database BLOB fields, I get the impression it generally isn't a good idea. At least, it does seem quite unpopular. Could you delve a little into the pros and cons of BLOB versus filesystem options for storage of files on the server.
Thanks.
Ifedi.
I guess it depends on what type of app you're thinking of
Storing images in a database allows for all of your data to be central stored which is more portable, and easy to replicate. This solution would likely also be easier for taking a point-in-time backup with referential integrity.
Which option you choose would really depend on the type application you’re building in my opinion.
So if you’re building an application with a moderately sized amount of image data, and moderate amount of traffic using a database would be okay as the benefits outway the cost. However if you’re building something like flickr with large amounts of data and high traffic, using the file system would be the advised approach.
I’ve also heard of a combined solution that could provide the best of both world. This is storing your images in the database to gain the benefits there, but also use filesystem caching of these to obtain the performance benefits.
Atli 5,058
Expert 4TB
Hi.
In my mind, the main reason for placing files and images into a database is security and control.
If your files are likely to be accessed very frequently, you may be better of leaving them on the file-system. Fetching them from a database involves a lot of extra overhead which will most likely slow you server down.
If, however, the files you are storing are of a sensitive nature, storing them in a database will give you more control over how they are handled. You could even go as far as splitting them up into multiple fields in multiple tables (even multiple database). It allows you a level of control you will generally not have over you file-system (at least not without jumping through several OS dependent hoops).
hi atli..it's me again...
this time i want to ask if there is a simple way to remove files that have been uploaded from database?
now i m using ur coding to upload my files ^_^
thank u so much for the coding and advice
I am new using mysql and php. I tried to follow the example and everything works fine but when I try to download a file, I get the following error message:
Error! Query failed:
Table 'FileStorage.fileStorage' doesn't exist
Any idea what I did wrong?
Any help will be appreciated.
@msei
I hate to state the obvious but it sounds like you ahve a typo. Look carefully where the word fileStorage was used. Capitals do make a difference, so make sure you didn't mean FileStorage or filestorage. Otherwise paste your download code if you can't see anything and we'll have a look..
Thank you for the info. It is working now, but I am having a problem when I view the pdf or doc file on the browser, is there a way to do not show as binary, see file attached. I would like it to be download in the desktop instead view it at the browser? Any help will be appreciated
Thank you in advance.
@msei
Part 4 of the above article shows you how to download a file.
hello;
dose any one can help me?? I found the above code perfect but the thing I would like to know is how can I save the changes that going to be made to the file that been opened? For example... if word file is being open and any thing is changed in it how to save this changes again in mysql db :((
HEEEEELP
Atli 5,058
Expert 4TB @tweeengl
Hi.
To do that, you would have to update the existing row in the database with the new data.
You could modify the code in phase 2, replacing the INSERT query with an UPDATE query.
thanx very much for your answer but the problem is still the same because cant take the file new changes after being edit I cant take the new size and new data to be able to update them as they have been inserted at the first place :'(
if you can clear that up to me it would be a great help
thanx again
Atli 5,058
Expert 4TB
The process of updating a file, stored in the manner the article describes, is almost exactly the same as uploading a new file.
If you want to open, edit, and save a Word document stored in a MySQL database, the file would have to be: - Downloaded to a client (Phase #4), where it would be edited.
- Uploaded to server again. (Phase #1)
- And finally inserted into the database again. (Phase #2, substituting the INSERT command with a UPDATE command).
The only difference between adding a new file and updating an existing one is that in Phase #2, rather than using INSERT to add a new row, you use UPDATE to alter an existing one.
That would of course require the client to pass along the ID of the old row, so it could be updated. You could simply add that to the form in Phase #1, which you would then use in Phase #2 in the UPDATE command.
Thanks very much alti for you respond it was great help for me :))
Hi, I am a newbie here in bytes forum.
I exactly follow the whole script you post, from phase 0 to phase 4. Fortunately there was no error and the codes works fine from phase 0 to phase 3. I have a problem in downloading. When I hit the download link, an error occur. Here's the error..
Warning: Cannot modify header information - headers already sent by (output started at c:\Inetpub\wwwroot\uploadingfiles\ddl.php:10) in c:\Inetpub\wwwroot\uploadingfiles\ddl.php on line 42
Warning: Cannot modify header information - headers already sent by (output started at c:\Inetpub\wwwroot\uploadingfiles\ddl.php:10) in c:\Inetpub\wwwroot\uploadingfiles\ddl.php on line 43
Warning: Cannot modify header information - headers already sent by (output started at c:\Inetpub\wwwroot\uploadingfiles\ddl.php:10) in c:\Inetpub\wwwroot\uploadingfiles\ddl.php on line 44
Another error was, there's no download pop window appear.
What is seem to be the error. Thanks in advance.
hi..
I think you should check the code in the phase 4. Make sure there is no white space before the <?php. It is related to the UTF rules..
Atli 5,058
Expert 4TB
Hi roseple.
ririe is right.
The headers are sent as soon as you start sending content to the browser, at which point you can not alter them (obviously).
If you try, you get that error.
Even a single space before your <?php tags will cause this, as will any echo calls from your scripts.
If there is absolutely no way to avoid sending content before altering the headers, you can use the Output Buffering Control functions to delay sending the content.
Thank you Atli and ririe on your reply.
I just check my codes if there is a white space on my download page. But the error is still the same. It does not raise a file download dialog box.
I don't know what to edit/debug anymore.
Thanks guys..
Roseple, why don't you attach along your download codes here..
so that we can together see and check the codes.Then we will try to find
the errors...
Oh.. oki i will attach the file..
By the way, is mysqli different from mysql?
If i change all mysqli command to mysql, this can cause any problem?
MySQLi is designed to work with MySQL 4.1.3 or higher and gives access to more advanced features in MySQL. It requires PHP 5.0 to use. It also gives you more control because you can change MySQL settings using MySQLi without stopping and starting the MYSQL server.
MySQLi is also the OOP version of MySQL extension. MySQLi supports some things that the old MySQL extension doesn't. A lot of people still use the original MySQL extension vs the new MySQLi extension because MySQLi requires MySQL 4.1.13+ and PHP 5.0.7+. However, they both provide access MySQL features.
Oh I see. But like me who is a newbie programmer, I still used the original MySql extension. So in above code you gave, I change all the mysqli to mysql. You can see on my attached file. - <!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><?php
-
# Make sure an ID was passed
-
if(isset($_GET['id']))
-
{
-
# Get the ID
-
$id = $_GET['id'];
-
-
# Make sure the ID is in fact a valid ID
-
if(!is_numeric($id) || ($id <= 0)) {
-
die("The ID is invalid!");
-
}
-
-
# Connect to the database
-
$dbLink = mysql_connect("localhost", "root", "777") or die (mysql_error());
-
mysql_select_db("filestorage", $dbLink) or die(mysql_error());
-
-
# Fetch the file information
-
$query = "
-
SELECT FileMime, FileName, FileSize, FileData
-
FROM filestorage
-
WHERE FileID = {$id}";
-
-
$result = @mysql_query($query,$dbLink)
-
or die("Error! Query failed: <pre>". mysqli_error($dbLink) ."</pre>");
-
-
# Make sure the result is valid
-
if(mysql_num_rows($result) == 1)
-
{
-
# Get the row
-
$row = mysql_fetch_assoc($result);
-
-
# Print headers
-
header("Content-Type:".$row['FileMime']);
-
header("Content-Length:".$row['FileSize']);
-
header("Content-Disposition:attachment;filename=".$row['FileName']);
-
-
# Print data
-
echo $row['FileData'];
-
}
-
else
-
{
-
echo "Error! No image exists with that ID.";
-
}
-
-
# Free the mysqli resources
-
@mysql_free_result($result);
-
@mysql_close($dbLink);
-
-
}
-
else
-
{
-
echo "Error! No ID was passed.";
-
}
-
?>
-
</body>
-
</html>
-
- <?php
-
# Make sure an ID was passed
-
if(isset($_GET['id']))
-
{
-
# Get the ID
-
$id = $_GET['id'];
-
-
# Make sure the ID is in fact a valid ID
-
if(!is_numeric($id) || ($id <= 0)) {
-
die("The ID is invalid!");
-
}
-
-
# Connect to the database
-
$dbLink = mysql_connect("localhost", "root", "777") or die (mysql_error());
-
mysql_select_db("filestorage", $dbLink) or die(mysql_error());
-
-
# Fetch the file information
-
$query = "
-
SELECT FileMime, FileName, FileSize, FileData
-
FROM filestorage
-
WHERE FileID = {$id}";
-
-
$result = @mysql_query($query,$dbLink)
-
or die("Error! Query failed: <pre>". mysqli_error($dbLink) ."</pre>");
-
-
# Make sure the result is valid
-
if(mysql_num_rows($result) == 1)
-
{
-
# Get the row
-
$row = mysql_fetch_assoc($result);
-
-
# Print headers
-
header("Content-Type:".$row['FileMime']);
-
header("Content-Length:".$row['FileSize']);
-
header("Content-Disposition:attachment;filename=".$row['FileName']);
-
-
# Print data
-
echo $row['FileData'];
-
}
-
else
-
{
-
echo "Error! No image exists with that ID.";
-
}
-
-
# Free the mysqli resources
-
@mysql_free_result($result);
-
@mysql_close($dbLink);
-
-
}
-
else
-
{
-
echo "Error! No ID was passed.";
-
}
-
?>
Roseple, you just try use the codes above and delete all those thing...
-----delete----- -
<!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>
-
</body>
-
</html>
-----delete------
The opening for html, head and all the things are not required for this code.As Atli said the headers are sent as soon as you start sending content to the browser, so you can not alter them. If you put the html codes, the program will assume that the header are already sent. So your actually program cannot running properly and you will get errors.
Wow, you guys were so great.
It's running properly now. The file download dialog box is now present and I can actually download the file.
Thank you so much.
Ok..congratulation roseple..
Good Luck in your work...
Hi, roseple again.. :)
If I try to upload an mp3, mpeg and pdf file but an error occurred. Is it because of their file size or the code does not support that said file?
Thanks...
well, the code cannot support the mp3 file but it should work for pdf..
Even if I try to increase the maximum file size value, pdf file does not work still.
show me your codes for upload
Oki here's my 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>
-
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??
Error! An error accured while the file was being uploaded. Error code: 2
Notice: Undefined variable: dbLink in c:\Inetpub\wwwroot\uploadingfiles\add_file.php on line 86
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in c:\Inetpub\wwwroot\uploadingfiles\add_file.php on line 86
what is the code on line 82??
sorry what is the code on line 86??
mysql_close($dbLink); //line 86
That warning and error only appear if pdf file was being uploaded.
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
Sorry I mean you should use mysqli as mysql does not support dblink
Atli 5,058
Expert 4TB
ririe and roseple,
Please use [code] tags when you post you code examples.
[code] code goes here [/code]
Thanks.
Sorry Atli...Next time I will use code tag
Atli 5,058
Expert 4TB
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: - <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)
Sorry Atli.. next time I will use code tag too.
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?
Atli 5,058
Expert 4TB
You can simply remove the max_file_size input if it is giving you problems.
It isn't really needed. PHP has it's own size limits that it uses.
The max_file_size input is mostly to give the browser a chance to prevent a file upload that is known to be to large.
Hi Atli..
Correct me if I'm wrong.
Error Code:2 = large file
Error code:4 = there's no file to upload
And what is the other error user may encounter using the codes above?
Thanks..
Ooops, I got it. Sorry..
You posted that already.
Thanks anyway.
Hi Atli,
Why does the link to the next page of this forum is not visible anymore?
Thanks..
Atli 5,058
Expert 4TB @roseple
I moved some of your posts into their own threads, which made this thread fit into one page again.
Click the "subscriptions" link at the top of the page and you should be able to see them.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: hdf |
last post by:
hi i have problems uploading my database using phpmyadmin n i want to load it using the ssh termal in setd of phpmyadmin.
can anyone hlp
|
by: menmysql |
last post by:
i am getting the following error while connecting mysql database using jsp
java.sql.SQLException: Communication link failure: Bad handshake
can any one tell what is the actual problem
|
by: menmysql |
last post by:
i am not bale to solve this problem since two weeks
i am trying to access records from mysql database using jsp. inside this jsp program i wrote all my JDBC code. it is working very nicely and...
|
by: christopher_board |
last post by:
Hi all. I am trying to connect to a MySQL Database using PHP on a
local machine using locahost. I am using the following code
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass =...
|
by: ganeshg |
last post by:
Hai All,
Please let me know how to insert audio files into mysql database using .net.
Thanking you.....
|
by: Suresh P |
last post by:
Hi All,
I tried to access the mysql database in ODBC using ip address and
username/password.
It returns, "cannot connect to MySQL server on IP ADDRESS(10060)".
This could be related to Firewall...
|
by: nadeenahmed |
last post by:
I have Connected to a MySQL Database using a neatbeans editor. Now, I want to use that same database I created earlier on another pc. Can anyone help and tell me how that is done, please?
Thank...
|
by: mfaisalwarraich |
last post by:
Hi everyone,
I am trying to add multiple pinpoint to google map using Lon/Lat. All addresses will be fetched from mysql database using PHP.
I have looked at google and searched for it on...
|
by: santhanalakshmi |
last post by:
Hi,
I wrote some coding, to import excel data in mysql database using PHP Script? But my script, its not all inserting the excel data in mysql database. I don't know, what mistake did i made?...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
| |