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

时间：2015-01-23 来源：西部数据作者：西部数据

// 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>

//开源代码phpfensi.com

</body>

</html>