php把上传的图片保存到数据库并显示代码 -php手册-php.cn

Table of Contents

Here's the latest picture

Please upload a new picture and title

Home

php教程

php手册

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

May 24, 2016 pm 01:25 PM

<?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 id="Here-s-nbsp-the-nbsp-latest-nbsp-picture">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 id="Please-nbsp-upload-nbsp-a-nbsp-new-nbsp-picture-nbsp-and-nbsp-title">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

本文链接:

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

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn