图片存储与浏览一例(Linux+Apache+PHP+MySQL)_PHP教程_编程语言

注意本程序使用的表结构为:
    use test;
    create table image(
                       id int unsigned auto_increment primary key,
                       description text,
                       filename varchar(50),
                       filesize int,
                       filetype varchar(50),
                       filedata longblob
                      );
*/

//?cmd={read|list|form|store}

//检查cmd参数的合法性
switch($cmd){
   case 'read':
      break;
   case 'list':
      break;
   case 'form':
      break;
   Case 'store':
      break;
   default:
      $cmd = 'list';
      break;
}

switch($cmd){
   case 'read':
      //?cmd=read&id={}
      //读一个图片
      $server = mysql_connect(http://www.lexue001.com/skin/default/image/nopic.giflocalhosthttp://www.lexue001.com/skin/default/image/nopic.gif,http://www.lexue001.com/skin/default/image/nopic.giftesthttp://www.lexue001.com/skin/default/image/nopic.gif,http://www.lexue001.com/skin/default/image/nopic.gifhttp://www.lexue001.com/skin/default/image/nopic.gif) or die(http://www.lexue001.com/skin/default/image/nopic.gif无法连接数据库服务器http://www.lexue001.com/skin/default/image/nopic.gif);
      mysql_select_db(http://www.lexue001.com/skin/default/image/nopic.giftesthttp://www.lexue001.com/skin/default/image/nopic.gif,$server) or die(http://www.lexue001.com/skin/default/image/nopic.gif无法连接数据库http://www.lexue001.com/skin/default/image/nopic.gif);
      $sql = http://www.lexue001.com/skin/default/image/nopic.gifselect filetype,filedata from image where id='$id'http://www.lexue001.com/skin/default/image/nopic.gif;
      $rst = mysql_query($sql,$server) or die(http://www.lexue001.com/skin/default/image/nopic.gif$sql查询出错http://www.lexue001.com/skin/default/image/nopic.gif);
      if($row=mysql_fetch_row($rst)){
         header(http://www.lexue001.com/skin/default/image/nopic.gifContent-Type:http://www.lexue001.com/skin/default/image/nopic.gif . $row[0]);
         echo $row[1];
      }
      else{
         echo http://www.lexue001.com/skin/default/image/nopic.gif没有找到该记录http://www.lexue001.com/skin/default/image/nopic.gif;
      }
      mysql_free_result($rst);
      mysql_close($server) or die(http://www.lexue001.com/skin/default/image/nopic.gif无法与数据库服务器断开连接http://www.lexue001.com/skin/default/image/nopic.gif);
      break;
   case 'list':
      //?cmd=list
      //显示所有图片
      echo '<html>';
      echo '<head><title>图片存储与浏览一例</title></head>';
      echo '<body>';
      echo '<a href=http://www.lexue001.com/skin/default/image/nopic.gif' . $PHP_SELF . '?cmd=listhttp://www.lexue001.com/skin/default/image/nopic.gif>显示所有图片</a>';
      echo http://www.lexue001.com/skin/default/image/nopic.gif    http://www.lexue001.com/skin/default/image/nopic.gif;
      echo '<a href=http://www.lexue001.com/skin/default/image/nopic.gif' . $PHP_SELF . '?cmd=formhttp://www.lexue001.com/skin/default/image/nopic.gif>上传图片</a>';
      $server = mysql_connect(http://www.lexue001.com/skin/default/image/nopic.giflocalhosthttp://www.lexue001.com/skin/default/image/nopic.gif,http://www.lexue001.com/skin/default/image/nopic.giftesthttp://www.lexue001.com/skin/default/image/nopic.gif,http://www.lexue001.com/skin/default/image/nopic.gifhttp://www.lexue001.com/skin/default/image/nopic.gif) or die(http://www.lexue001.com/skin/default/image/nopic.gif无法连接数据库服务器http://www.lexue001.com/skin/default/image/nopic.gif);
      mysql_select_db(http://www.lexue001.com/skin/default/image/nopic.giftesthttp://www.lexue001.com/skin/default/image/nopic.gif,$server) or die(http://www.lexue001.com/skin/default/image/nopic.gif无法连接数据库http://www.lexue001.com/skin/default/image/nopic.gif);
      $sql = http://www.lexue001.com/skin/default/image/nopic.gifselect id,description,filename,filetype,filesize from imagehttp://www.lexue001.com/skin/default/image/nopic.gif;
      $rst = mysql_query($sql,$server) or die(http://www.lexue001.com/skin/default/image/nopic.gif$sql查询出错http://www.lexue001.com/skin/default/image/nopic.gif);
      while($row=mysql_fetch_row($rst)){
         echo http://www.lexue001.com/skin/default/image/nopic.gif<hr>http://www.lexue001.com/skin/default/image/nopic.gif;
         echo http://www.lexue001.com/skin/default/image/nopic.gif描述:http://www.lexue001.com/skin/default/image/nopic.gif . $row[1] . http://www.lexue001.com/skin/default/image/nopic.gif<br>http://www.lexue001.com/skin/default/image/nopic.gif;
         echo http://www.lexue001.com/skin/default/image/nopic.gif文件名:http://www.lexue001.com/skin/default/image/nopic.gif . $row[2] . http://www.lexue001.com/skin/default/image/nopic.gif<br>http://www.lexue001.com/skin/default/image/nopic.gif;
         echo http://www.lexue001.com/skin/default/image/nopic.gif类型:http://www.lexue001.com/skin/default/image/nopic.gif . $row[3] . http://www.lexue001.com/skin/default/image/nopic.gif<br>http://www.lexue001.com/skin/default/image/nopic.gif;
         echo http://www.lexue001.com/skin/default/image/nopic.gif大小:http://www.lexue001.com/skin/default/image/nopic.gif . $row[4] . http://www.lexue001.com/skin/default/image/nopic.gif<br>http://www.lexue001.com/skin/default/image/nopic.gif;
         echo '<img src=http://www.lexue001.com/skin/default/image/nopic.gif' . $PHP_SELF . '?cmd=read&id=' . $row[0] . 'http://www.lexue001.com/skin/default/image/nopic.gif>';
      }
      mysql_free_result($rst);
      mysql_close($server) or die(http://www.lexue001.com/skin/default/image/nopic.gif无法与数据库服务器断开连接http://www.lexue001.com/skin/default/image/nopic.gif);
      echo '</body>';
      echo '</html>';
      break;
   case 'form':
?>

<html>
<head><title>图片存储与浏览一例</title></head>
<body>
<form action=http://www.lexue001.com/skin/default/image/nopic.gif<?echo $PHP_SELF;?>?cmd=storehttp://www.lexue001.com/skin/default/image/nopic.gif method=http://www.lexue001.com/skin/default/image/nopic.gifposthttp://www.lexue001.com/skin/default/image/nopic.gif enctype=http://www.lexue001.com/skin/default/image/nopic.gifmultipart/form-datahttp://www.lexue001.com/skin/default/image/nopic.gif>
<input type=http://www.lexue001.com/skin/default/image/nopic.gifhiddenhttp://www.lexue001.com/skin/default/image/nopic.gif name=http://www.lexue001.com/skin/default/image/nopic.gifMAX_FILE_SIZEhttp://www.lexue001.com/skin/default/image/nopic.gif value=http://www.lexue001.com/skin/default/image/nopic.gif2097152http://www.lexue001.com/skin/default/image/nopic.gif>
描述:<br>
<textarea name=http://www.lexue001.com/skin/default/image/nopic.gifdescriptionhttp://www.lexue001.com/skin/default/image/nopic.gif rows=http://www.lexue001.com/skin/default/image/nopic.gif5http://www.lexue001.com/skin/default/image/nopic.gif cols=http://www.lexue001.com/skin/default/image/nopic.gif100http://www.lexue001.com/skin/default/image/nopic.gif></textarea><br>
文件:<input type=http://www.lexue001.com/skin/default/image/nopic.giffilehttp://www.lexue001.com/skin/default/image/nopic.gif name=http://www.lexue001.com/skin/default/image/nopic.giffilehttp://www.lexue001.com/skin/default/image/nopic.gif><br>
<input type=http://www.lexue001.com/skin/default/image/nopic.gifsubmithttp://www.lexue001.com/skin/default/image/nopic.gif value=http://www.lexue001.com/skin/default/image/nopic.gif上传http://www.lexue001.com/skin/default/image/nopic.gif>
</form>
</body>
</html>

<?
      break;
   case 'store':
      //?cmd=store&description={}&file={}&file_size={}&file_type={}&file_name={}
      //存储图片
      echo '<html>';
      echo '<head><title>图片存储与浏览一例</title></head>';
      echo '<body>';
      echo '<a href=http://www.lexue001.com/skin/default/image/nopic.gif' . $PHP_SELF . '?cmd=listhttp://www.lexue001.com/skin/default/image/nopic.gif>显示所有图片</a>';
      echo http://www.lexue001.com/skin/default/image/nopic.gif    http://www.lexue001.com/skin/default/image/nopic.gif;
      echo '<a href=http://www.lexue001.com/skin/default/image/nopic.gif' . $PHP_SELF . '?cmd=formhttp://www.lexue001.com/skin/default/image/nopic.gif>上传图片</a>';
      $server = mysql_connect(http://www.lexue001.com/skin/default/image/nopic.giflocalhosthttp://www.lexue001.com/skin/default/image/nopic.gif,http://www.lexue001.com/skin/default/image/nopic.giftesthttp://www.lexue001.com/skin/default/image/nopic.gif,http://www.lexue001.com/skin/default/image/nopic.gifhttp://www.lexue001.com/skin/default/image/nopic.gif) or die(http://www.lexue001.com/skin/default/image/nopic.gif无法连接数据库服务器http://www.lexue001.com/skin/default/image/nopic.gif);
      mysql_select_db(http://www.lexue001.com/skin/default/image/nopic.giftesthttp://www.lexue001.com/skin/default/image/nopic.gif,$server) or die(http://www.lexue001.com/skin/default/image/nopic.gif无法连接数据库http://www.lexue001.com/skin/default/image/nopic.gif);
      $data = addslashes(fread(fopen($file,http://www.lexue001.com/skin/default/image/nopic.gifrhttp://www.lexue001.com/skin/default/image/nopic.gif),filesize($file)));
      $sql = http://www.lexue001.com/skin/default/image/nopic.gifinsert into image(description,filename,filetype,filesize,filedata)
              values('$description','http://www.lexue001.com/skin/default/image/nopic.gif . basename($file_name) . http://www.lexue001.com/skin/default/image/nopic.gif','$file_type',$file_size,'$data')http://www.lexue001.com/skin/default/image/nopic.gif;
      mysql_query($sql,$server) or die(http://www.lexue001.com/skin/default/image/nopic.gif$sql执行出错http://www.lexue001.com/skin/default/image/nopic.gif);
      $id = mysql_insert_id();
      echo http://www.lexue001.com/skin/default/image/nopic.gif<hr>你上传的图片效果:<br>http://www.lexue001.com/skin/default/image/nopic.gif;
      echo '<img src=http://www.lexue001.com/skin/default/image/nopic.gif' . $PHP_SELF . '?cmd=read&id=' . $id . 'http://www.lexue001.com/skin/default/image/nopic.gif>';
      mysql_close($server) or die(http://www.lexue001.com/skin/default/image/nopic.gif无法与数据库服务器断开连接http://www.lexue001.com/skin/default/image/nopic.gif);
      echo '</body>';
      echo '</html>';
      break;
}
?>