php file upload php upload file to database

php upload files to database It is nothing more than creating a longblob field in the database to save this file However, if you upload a file of 4-5m, there will be some problems that you need to pay attention to at this time

1, modify php.ini

The value of the 2 parameters, make them larger than the size of the file you need to upload

2, modify my.cnf Modify the value of the max_allowed_packet parameter of the mysql database The meaning of this parameter: max_allowed_packet The maximum size of a bag. The message buffer is initialized to net_buffer_length bytes, but can be increased to max_allowed_packet bytes if needed. By default, this value is too small to capture large (possibly erroneous) packets. If you are using large blob columns, you must increase this value. It should be as large as the largest blob you want to use.

1. PHP uploads pictures to the database

Create 3 php files: readdir.php - code that puts images into the database image.php - code that displays the actual image view.php - code that shows how you call an image from the database

1. Create a database

readdir.php

Specific content:

Category images and read out some of the data being used fopen 'Convert base64_encode 'Insert into table

Close the set directory and process:

Code to read the image: image.php

The code used to read out the image image.php?img=x:

After that, you need to connect to the database and read out:

$result = mysql_query("select * from images where imgid=" . $img . ""); if (!$result) { echo("Request error: " . mysql_error() . ""); exit(); } while ($row = mysql_fetch_array($result)) { $imgid = $row["imgid"]; $encodeddata = $row["sixfourdata"]; } ?>

mysql_close($dbcnx); echo base64_decode($encodeddata); ?>

Understand base64-encoded image data format. "Let's take a look at the specific pictures!" view.php image.php?img=1 image.php?img=357

readdir.php:

############################### # db connection # change these values ############################### $dbcnx = mysql_connect("localhost", "username", "password"); mysql_select_db("base64imgdb"); ############################### # db connection # change these values ############################### $dbcnx = mysql_connect("localhost", "username", "password"); mysql_select_db("base64imgdb");

$path = "./"; $dir_handle = opendir($path) or die("unable to open directory $path"); while ($file = readdir($dir_handle)) { $filetyp = substr($file, -3); if ($filetyp == 'gif' or $filetyp == 'jpg') { $handle = fopen($file,'r'); $file_content = fread($handle,filesize($file)); fclose($handle); $encoded = chunk_split(base64_encode($file_content)); $sql = "insert into images set sixfourdata='$encoded'"; mysql_query($sql); } }

closedir($dir_handle); echo("complete"); mysql_close($dbcnx); ?>

image.php:

$dbcnx = mysql_connect("localhost", "username", "password"); $dbcnx = mysql_connect("localhost", "username", "password");

mysql_select_db("base64imgdb");

$img = $_request["img"];

$result = mysql_query("select * from images where imgid=" . $img . "");

if (!$result) {

echo("error performing query: " . mysql_error() . ""); exit(); } while ($row = mysql_fetch_array($result) ) { $imgid = $row["imgid"]; $encodeddata = $row["sixfourdata"]; } mysql_close($dbcnx); echo base64_decode($encodeddata); ?>

view.php (i shouldn’t need to post this..)

2. How to let php upload files and save them into the database

1.show_info.php

$num=mysql_num_rows($result); if($num

$data = mysql_result($result,0,"file_data"); $type = mysql_result($result,0,"file_type"); $name = mysql_result($result,0,"file_name");

mysql_close($conn);

//First output the corresponding file header and restore the original file name header("content-type:$type"); header("content-disposition: attachment; filename=$name"); echo $data; ?>

2.show_info.php

$sql = "select file_name ,file_size from receive where id=$id"; $result = mysql_query($sql,$conn); if(!$result) die(" error: mysql query");

//If there is no specified record, an error will be reported $num=mysql_num_rows($result); if($num

//The following two sentences of program can also be written like this //$row=mysql_fetch_object($result); //$name=$row->name; //$size=$row->size; $name = mysql_result($result,0,"file_name"); $size = mysql_result($result,0,"file_size");

mysql_close($conn);

echo "

3.submit.php

$myfile=$_files["myfile"];

//Set the timeout limit time. The default time is 30 seconds. When set to 0, there is no time limit. $time_limit=60; set_time_limit($time_limit); //

//Read the file content into a string $fp=fopen($myfile['tmp_name'], "rb"); if(!$fp) die("file open error"); $file_data = addslashes(fread($fp, filesize($myfile['tmp_name']))); fclose($fp); unlink($myfile['tmp_name']);

//File format, name, size $file_type=$myfile["type"]; $file_name=$myfile["name"]; $file_size=$myfile["size"]; die($file_type); //Connect to the database and save the file to the database $conn=mysql_connect("localhost","root","admin"); if(!$conn) die("error : mysql connect failed"); mysql_select_db("nokiapaymentplat",$conn);

$sql="insert into receive (file_data,file_type,file_name,file_size) values ​​('$file_data','$file_type','$file_name',$file_size)"; $result=mysql_query($sql,$conn);

//The following sentence takes out the id of the insert statement just now $id=mysql_insert_id();

mysql_close($conn);

set_time_limit(30); //Restore the default timeout setting

echo "Upload successful--- "; echo "Show uploaded file information"; } else { echo "You did not upload any files"; } ?>

4.upload.php