php 上传 保存 代码,php把上传的图保存到数据库并显示代码_PHP教程

php把上传的图保存到数据库并显示代码

php教程把上传的图保存到数据库教程并显示代码

// Connect to database

$errmsg = “”;

if (! @mysql教程_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 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 ();

}

?>

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.comtrueTechArticlephp把上传的图保存到数据库并显示代码 php教程把上传的图保存到数据库教程并显示代码 // Connect to database $errmsg = ; if (! @mysql教程_connect(loc…