for($i = 1; $i<= $_POST['file_num']; $i++)
{
$filename = "File".$i ;
$file_name = $_FILES[$filename]['name'];
//设置超时限制时间,缺省时间为 30秒,设置为0时为不限时
$time_limit=60;
set_time_limit($time_limit); //文件被上传后在服务端储存的临时文件名。$_FILES[$filename]['tmp_name']
$fp=fopen($_FILES[$filename]['tmp_name'],"rb");
if(!$fp) die("file open error");
$file_data = addslashes(fread($fp, filesize($_FILES[$filename]['tmp_name'])));
fclose($fp);
unlink($_FILES[$filename]['tmp_name']);
//存储到数据库
$querysql = "select *from BusPic where Name = '$file_name';";
$queryresult = mysql_query($querysql,$dbh);
$errQuery = mysql_error();
if ($errQuery)
{
mysql_close($dbh);
printf($errDB);
exit();
}
$num = mysql_num_rows($queryresult); $idsql = "select max(ID) from BusPic;";
$idresult = mysql_query($idsql,$dbh);
$errQuery = mysql_error();
if($errQuery)
{
mysql_close($dbh);
printf($errDB);
exit();
}
$array = mysql_fetch_row($idresult);
$id = $array[0] + 1; $sequesql = "select max(SequeNum) from BusPic where ParentID = 'b1';";
$sequeresult = mysql_query($idsql,$dbh);
$errQuery = mysql_error();
if($errQuery)
{
mysql_close($dbh);
printf($errDB);
exit();
}
$sequearray = mysql_fetch_row($sequeresult);
$seque = $sequearray[0] + 1;
if($num == 0)
$sql = "insert into BusPic values('$id','$file_name','$file_data','b1','$seque');";
else
$sql ="update BusPic set FileData ='$file_data' where Name = '$file_name';";
$result=mysql_query($sql,$dbh);
$errQuery = mysql_error();
if($errQuery)
{
mysql_close($dbh);
printf($errDB);
exit();
}
}
mysql_close($dbh);代码是最简单的,应该没有什么错误吧!也不专业,大家帮忙改改。
从文件大小上看,文件比原来变大了。这几个文件在一起才能打开,因为文件不一样了所以上传后就打不开啦。
{
$filename = "File".$i ;
$file_name = $_FILES[$filename]['name'];
//设置超时限制时间,缺省时间为 30秒,设置为0时为不限时
$time_limit=60;
set_time_limit($time_limit); //文件被上传后在服务端储存的临时文件名。$_FILES[$filename]['tmp_name']
$fp=fopen($_FILES[$filename]['tmp_name'],"rb");
if(!$fp) die("file open error");
$file_data = addslashes(fread($fp, filesize($_FILES[$filename]['tmp_name'])));
fclose($fp);
unlink($_FILES[$filename]['tmp_name']);
//存储到数据库
$querysql = "select *from BusPic where Name = '$file_name';";
$queryresult = mysql_query($querysql,$dbh);
$errQuery = mysql_error();
if ($errQuery)
{
mysql_close($dbh);
printf($errDB);
exit();
}
$num = mysql_num_rows($queryresult); $idsql = "select max(ID) from BusPic;";
$idresult = mysql_query($idsql,$dbh);
$errQuery = mysql_error();
if($errQuery)
{
mysql_close($dbh);
printf($errDB);
exit();
}
$array = mysql_fetch_row($idresult);
$id = $array[0] + 1; $sequesql = "select max(SequeNum) from BusPic where ParentID = 'b1';";
$sequeresult = mysql_query($idsql,$dbh);
$errQuery = mysql_error();
if($errQuery)
{
mysql_close($dbh);
printf($errDB);
exit();
}
$sequearray = mysql_fetch_row($sequeresult);
$seque = $sequearray[0] + 1;
if($num == 0)
$sql = "insert into BusPic values('$id','$file_name','$file_data','b1','$seque');";
else
$sql ="update BusPic set FileData ='$file_data' where Name = '$file_name';";
$result=mysql_query($sql,$dbh);
$errQuery = mysql_error();
if($errQuery)
{
mysql_close($dbh);
printf($errDB);
exit();
}
}
mysql_close($dbh);代码是最简单的,应该没有什么错误吧!也不专业,大家帮忙改改。
从文件大小上看,文件比原来变大了。这几个文件在一起才能打开,因为文件不一样了所以上传后就打不开啦。
怎么$_FILES里都取的是同一个值呢