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

WBOY

Release： 2016-05-24 13:25:28

Original

1749 people have browsed it

<?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[&#39;imagefile&#39;][&#39;tmp_name&#39;],"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 ();  
} 
?>

Copy after login

  
<html><head>  
<title>Upload an image to a database</title>  
<body bgcolor=white><h2>Here&#39;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>

Copy after login

本文链接:

收藏随意^^请保留教程地址.