本文實例敘述了PHP實作上傳檔案並儲存資料庫的方法。分享給大家供大家參考。具體如下：
show_add.php檔案如下：
<?php
if(!isset($_REQUEST['id']) or $_REQUEST['id ']=="") die("error: id none");
$id = $_REQUEST['id'];
# //定位記錄,讀出
$conn=mysql_connect("localhost","root","admin");
if(!$conn) die("error: mysql connect failed");
mysql_select_db("nokiapaymentplat",$conn);
$sql = "select * from receive where id=$5";
## =$$result where id=$
## if(!$result) die("error: mysql query");
$num=mysql_num_rows($result);
if($num<1) die ("error: no this recorder");
$data = mysql_result($result,0,"file_data");
# $type = mysql_result($result,0,
#type" );
$name = mysql_result($result,0,"file_name");
mysql_close($conn);
//先輸出對應的檔案頭,並且恢復原來的檔名
header("Content-type:$type");
header("Content-Disposition: attachment; filename=$name");
# echo $data;
?>
show_info.php檔案如下：
##<?php
ifif (!isset($_REQUEST['id']) or $_REQUEST['id']=="") die("error: id none");
# $id = $_REQUEST['id' ];
//定位記錄,讀出
$conn=mysql_connect("localhost","root","admin");
if(!$conn ) die("error: mysql connect failed");
mysql_select_db("nokiapaymentplat",$conn);
$ ;
$result = mysql_query($sql,$conn);
if(!$result) die(" error: mysql query");
#//如果沒有指定的記錄，則報錯誤
$num=mysql_num_rows($result);
if($num<1) die("error: no this recorder");
//下面兩句程式也可以這麼寫
#//$row=mysql_fetch_object($result);
//$name=$row->name;
//$size=$row->size;
$name = mysql_result($result,0,"file_name");
$size = mysql_result($result,0,"file_size");# mysql_close($conn) ;
echo "<hr>上傳的文件的資訊：";
echo "<br>The file's name - $name"; ;br>The file's size - $size";
卷#?>
submit.php檔案如下：
<?php
# if(is_uploaded_file($_FILES['myfile'][ 'tmp_name'])) {
//有了上傳檔案了
$myfile=$_FILES["myfile"];
# //設定逾時限制時間,預設時間為 30秒,設定為0時為不限時
$time_limit=60;
set_time_limit($time_limit); /# set_time_limit($time_limit);/# set_time_limit($time_limit); /# set_time_limit($時間_limit);讀到字串中
$fp=fopen($myfile['tmp_name'], "rb");
if(!$fp) die("file open error");
$file_data = addslashes(fread($fp, filesize($myfile['tmp_name'])));
fclose($fp);##
myfile['tmp_name']);
//檔案格式,姓名,大小
$file_type=$myfile["type"];
# $file_name=$myfile ["name"];
$file_size=$myfile["size"];
die($file_type);
//連接資料庫,將檔案儲存到資料庫中
$conn=mysql_connect("localhost","root","admin");
if(!$conn) die("error : my connect
mysql_select_db("nokiapaymentplat",$conn);
$sql="insert into receive
1(file_data,files.p.name,file,files. ('$file_data','$file_type','$file_name',$file_size)";
$result=mysql_query($sql,$conn);
#//下面這句取出了剛才的insert語句的id
$id=mysql_insert_id();
mysql_close($conn);
## /恢復預設逾時設定
echo "上傳成功--- ";
echo "<a href='show_info.php?id=$id'>顯示上傳檔案資訊資訊</a>";
}
else {
echo "你沒有上傳任何檔案";
# ##}
' ?>
upload.php檔案如下：
<html>
<head>
<title> ;檔案上傳表單</title>
</head>
<body>
<table>
#<form enctype ='multipart/form-data' name='myform' action='submit.php'
method='post'>
<INPUT TYPE = "hidden" NAME = " MAX_FILE_SIZE" VALUE ="1000000">
<選擇上傳檔案</td><td>
看到你這一堆程式碼 實在不寫去看