图片存储与浏览一例(Linux+Apache+PHP+MySQL)

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("localhost","test","") or die("无法连接数据库服务器");

mysql_select_db("test",$server) or die("无法连接数据库");

$sql = "select filetype,filedata from image where id='$id'";

$rst = mysql_query($sql,$server) or die("$sql查询出错");

if($row=mysql_fetch_row($rst)){

header("Content-Type:" . $row[0]);

echo $row[1];

}

else{

echo "没有找到该记录";

}

mysql_free_result($rst);

mysql_close($server) or die("无法与数据库服务器断开连接");

break;

case 'list':

//?cmd=list

//显示所有图片

echo '';

echo '';

echo '';

echo '显示所有图片';

echo "";

echo '上传图片';

$server = mysql_connect("localhost","test","") or die("无法连接数据库服务器");

mysql_select_db("test",$server) or die("无法连接数据库");

$sql = "select id,description,filename,filetype,filesize from image";

$rst = mysql_query($sql,$server) or die("$sql查询出错");

while($row=mysql_fetch_row($rst)){

echo "

echo "描述:" . $row[1] . "

";

echo "文件名:" . $row[2] . "

";

echo "类型:" . $row[3] . "

";

echo "大小:" . $row[4] . "

";

echo '';

}

mysql_free_result($rst);

mysql_close($server) or die("无法与数据库服务器断开连接");

echo '';

echo '';

break;

case 'form':

?>

break;

case 'store':

//?cmd=store&description={}&file={}&file_size={}&file_type={}&file_name={}

//存储图片

echo '';

echo '';

echo '';

echo '显示所有图片';

echo "";

echo '上传图片';

$server = mysql_connect("localhost","test","") or die("无法连接数据库服务器");

mysql_select_db("test",$server) or die("无法连接数据库");

$data = addslashes(fread(fopen($file,"r"),filesize($file)));

$sql = "insert into image(description,filename,filetype,filesize,filedata)

values('$description','" . basename($file_name) . "','$file_type',$file_size,'$data')";

mysql_query($sql,$server) or die("$sql执行出错");

$id = mysql_insert_id();

echo "

";

echo '';

mysql_close($server) or die("无法与数据库服务器断开连接");

echo '';

echo '';

break;

}

?>