【www.gdgbn.com--mysql教程】

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


 



本文来源：http://www.gdgbn.com/shujuku/24919/