Home  >  Article  >  Backend Development  >  PHP saves the uploaded image to the database and displays the code_PHP tutorial

PHP saves the uploaded image to the database and displays the code_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 17:04:31773browse

php saves the uploaded image to the database and displays the code

php tutorial saves the uploaded image to the database tutorial and displays the code
// Connect to database

$errmsg = "";
if (! @mysql tutorial_connect("localhost","root","")) {
$errmsg = "Cannot connect to database";
}
@mysql_select_db("db1");

$q = << create table pix (
pid int primary key not null auto_increment,
title text,
imgdata longblob)
CREATE;
@mysql_query($q);



// Insert any new image into database

if ($_REQUEST[completed] == 1) {
Move_uploaded_file($_FILES['imagefile']['tmp_name'],"latest.img");
$instr = fopen("latest.img","rb");
$image = addslashes(fread($instr,filesize("latest.img")));
if (strlen($instr) < 149000) {
mysql_query ("insert into pix (title, imgdata) values ​​("".
$_REQUEST[whatsit].
"", "".
$image.
"")");
} else {
$errmsg = "Too large!";
}
}



// Find out about latest image

$gotten = @mysql_query("select * from pix order by pid desc limit 1");
if ($row = @mysql_fetch_assoc($gotten)) {
$title = htmlspecialchars($row[title]);
$bytes = $row[imgdata];
} else {
$errmsg = "There is no image in the database yet";
$title = "no database image available";
// Put up a picture of our training center
$instr = fopen("../wellimg/ctco.jpg","rb");
$bytes = fread($instr,filesize("../wellimg/ctco.jpg"));
}


// If this is the image request, send out the image

if ($_REQUEST[gim] == 1) {
header("Content-type: image/jpeg");
Print $bytes;
exit ();
}
?>



Upload an image to a database

Here's the latest picture








Please upload a new picture and title





Please choose an image to upload:

Please enter the title of that picture:

then:




www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630871.htmlTechArticlephp save the uploaded image to the database and display the code php tutorial save the uploaded image to the database tutorial and display the code // Connect to database $errmsg = ; if (! @mysql tutorial_connect(loc...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn