<?php
extract($HTTP_POST_VARS);// 如果提交了表单,代码将被执行:
if ($submit) {
// 连接到数据库
// (你可能需要调整主机名,用户名和密码) mysql_connect();
mysql_select_db("test"); //假定表在test库中
$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
$result=mysql_qurery( "INSERT INTO binary_data (description,bin_data,filename,filesize,filetype) ".
"VALUES ('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')"); $id= mysql_insert_id();
print "<p>This file has the following Database ID: <b>$id</b>"; mysql_close(); } else {
// 否则显示储存新数据的表单
echo <<< FORM
<form method="post" action=" <?php echo $HTTP_SERVER_VARS[PHP_SELF]; ?>" enctype="multipart/form-data">
<input type="text" name="form_description" size="40">
<input type="file" name="form_data" size="40">
<input type="submit" name="submit" value="submit">
</form>
FORM;
} ?>
<p> </p>
<img src="getdata.php?id=1"><br>getdata.php
<?php
// 调用方法: getdata.php?id=<id>
extract($HTTP_GET_VARS);
if($id) {
// 你可能需要调整主机名,用户名和密码:
@mysql_connect();
@mysql_select_db("test"); $query = "select bin_data,filetype from binary_data where id=$id";
$result = @mysql_query($query); $data = @mysql_result($result,0, "bin_data");
$type = @mysql_result($result,0, "filetype"); Header( "Content-type: $type");
echo $data; };
?>
extract($HTTP_POST_VARS);// 如果提交了表单,代码将被执行:
if ($submit) {
// 连接到数据库
// (你可能需要调整主机名,用户名和密码) mysql_connect();
mysql_select_db("test"); //假定表在test库中
$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
$result=mysql_qurery( "INSERT INTO binary_data (description,bin_data,filename,filesize,filetype) ".
"VALUES ('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')"); $id= mysql_insert_id();
print "<p>This file has the following Database ID: <b>$id</b>"; mysql_close(); } else {
// 否则显示储存新数据的表单
echo <<< FORM
<form method="post" action=" <?php echo $HTTP_SERVER_VARS[PHP_SELF]; ?>" enctype="multipart/form-data">
<input type="text" name="form_description" size="40">
<input type="file" name="form_data" size="40">
<input type="submit" name="submit" value="submit">
</form>
FORM;
} ?>
<p> </p>
<img src="getdata.php?id=1"><br>getdata.php
<?php
// 调用方法: getdata.php?id=<id>
extract($HTTP_GET_VARS);
if($id) {
// 你可能需要调整主机名,用户名和密码:
@mysql_connect();
@mysql_select_db("test"); $query = "select bin_data,filetype from binary_data where id=$id";
$result = @mysql_query($query); $data = @mysql_result($result,0, "bin_data");
$type = @mysql_result($result,0, "filetype"); Header( "Content-type: $type");
echo $data; };
?>
//$_FILES['upfile']['size'] 得到上传图片大小。
echo "请选择需要上传的图片";
}else{
//getimagesize函数返回数组变量,得到上传图片的相关信息.
//0是图片的长,1是图片的宽,2是图片的后缀名
$imageinfo=getimagesize($_FILES['upfile']['tmp_name']);
if($imageinfo[0] > 120 or $imageinfo[1] > 80{
echo "图片大小不符合标准";
}elseif($imageinfo[2] < 1 or $imageinfo[2] > 3){
echo "简介图片只能是GIF,JPG,PNG格式";
}
//$imageinfo[2] 的值得于1,表示是gif格式, 2是jpg格式,3是png
if($imageinfo[2] == 1){
$imageinfo[2] = ".gif";
}elseif($imageinfo[2] == 2){
$imageinfo[2] = ".jpg";
}else{
$imageinfo[2] = ".png";
}
//文件名:把时间和文件名的md5值组合,加上后缀得到文件名。
$imgname = date(YmdHis).substr(md5($fname),0,5).$imageinfo[2];
//复制上传图片至你的接收上传图片目录。此例中为$root/$set[flashimgdir]/$imgname
copy($_FILES['upfile']['tmp_name'], "$root/$set[flashimgdir]/$imgname");
}