php把上传的图片保存到数据库并显示代码
- WBOYOriginal
- 2016-05-24 13:25:281746Durchsuche
<?php
// Connect to database
$errmsg = "";
if (! @mysql_connect("localhost","root","")) {
$errmsg = "Cannot connect to database";
}
@mysql_select_db("db1");
$q = <<<CREATE
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 centre
$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 ();
}
?><html><head> <title>Upload an image to a database</title> <body bgcolor=white><h2>Here's the latest picture</h2> <font color=red><?= $errmsg </font> <center><img src= style="max-width:90%"php把上传的图片保存到数据库并显示代码 " ><br> <b><?= $title </center> <hr> <h2>Please upload a new picture and title</h2> <form enctype="multipart/form-data" method="post"> <input type="hidden" name="MAX_FILE_SIZE" value=150000> <input type="hidden" name="completed" value=1> Please choose an image to upload: <input type="file" name="imagefile"><br> Please enter the title of that picture: <input name="whatsit"><br> then: <input type="submit"></form><br> </body> </html>
本文链接:
收藏随意^^请保留教程地址.
Stellungnahme：
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Vorheriger Artikel：php mb_substr实现中文字符串截取无乱码的方法 Nächster Artikel：PHP获取301重定向页面跳转后真实URL地址