php把上傳的圖保存到資料庫並顯示代碼

來源:互聯網
上載者:User
關鍵字 網路程式設計 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 (tit le, 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 bgcolo r=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="p ost">
<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>
Pl ease enter the title of that picture: <input name="whatsit"><br>
then: <input type="submit"></fo rm><br>
 
</body>
</html>
 

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.