php把上传的图片保存到数据库并显示代码
<?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= width=144><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>
本文链接:http://www.phprm.com/develop/fs5445.html
收藏随意^^请保留教程地址.