PHP 上传 JavaScript
include_once 'include/config.php';
include_once 'include/db.php';
include_once 'check.php';
$sss = new haya_check();
$applyuser = $sss->user();
//list
$username = $_request["username"];
$gender = $_request["gender"];
$testdate = ($_request["testdate"]=="") ? "0000-0-0" : $_request["testdate"];
$monaddate = ($_request["monaddate"]=="") ? "0000-0-0" : $_request["monaddate"];
$email = $_request["email"];
$tel1 = $_request["tel1"];
$tel2 = $_request["tel2"];
//$listtype = $_request["listtype"]);
$parentinfo = $_request["parentinfo"];
$studentinfo = $_request["studentinfo"];
$continueclass = $_request["continueclass"];
$studiedclassno = $_request["studiedclassno"];
$teachername = $_request["teachername"];
$consultant = $_request["consultant"];
$assistant = $_request["assistant"];
$senateclass = $_request["senateclass"];
$senateaudit = $_request["senateaudit"];
$classno = $_request["classno"];
$classname = $_request["classname"];
$grade = $_request["grade"];
$classsuffix = $_request["classsuffix"];
$startdate = ($_request["startdate"]=="") ? "0000-0-0" : $_request["startdate"];
$enddate = ($_request["enddate"]=="") ? "0000-0-0" : $_request["enddate"];
$classfrequency = $_request["classfrequency"];
$classplace = $_request["classplace"];
$fee = ($_request["fee"] == "") ? 0 : $_request["fee"];
$describe = $_request["describe"];
$transferfee = ($_request["transferfee"] == "") ? 0 : $_request["transferfee"];
$normalnumber = ($_request["normalnumber"] == "") ? 0 : $_request["normalnumber"];
$classroom = $_request["classroom"];
$classarrange = $_request["classarrange"];
$discount = $_request["discount"];
$discountreson1 = $_request["discountreson1"];
$discountreson2 = $_request["discountreson2"];
$discountreson3 = $_request["discountreson3"];
$unitprice = $_request["unitprice"];
$allclassfrequency = ($_request["allclassfrequency"] == "") ? 0 : $_request["allclassfrequency"];
$allclasstimes = ($_request["allclasstimes"] == "") ? 0 : $_request["allclasstimes"];
$allfee = ($_request["allfee"] == "") ? 0 : $_request["allfee"];
$teachbookapplier = $_request["teachbookapplier"];
$teachbookapplyno = $_request["teachbookapplyno"];
$lesoncardno = $_request["lesoncardno"];
$books = $_request["books"];
// course
$cl = array(
array("name"=>$_request["cl1_1"],"number"=>$_request["cl1_2"],"classtime"=>$_request["cl1_3"],"teacher"=>$_request["cl1_4"]),
array("name"=>$_request["cl2_1"],"number"=>$_request["cl2_2"],"classtime"=>$_request["cl2_3"],"teacher"=>$_request["cl2_4"]),
array("name"=>$_request["cl3_1"],"number"=>$_request["cl3_2"],"classtime"=>$_request["cl3_3"],"teacher"=>$_request["cl3_4"]),
array("name"=>$_request["cl4_1"],"number"=>$_request["cl4_2"],"classtime"=>$_request["cl4_3"],"teacher"=>$_request["cl4_4"]),
array("name"=>$_request["cl5_1"],"number"=>$_request["cl5_2"],"classtime"=>$_request["cl5_3"],"teacher"=>$_request["cl5_4"]),
array("name"=>$_request["cl6_1"],"number"=>$_request["cl6_2"],"classtime"=>$_request["cl6_3"],"teacher"=>$_request["cl6_4"]),
array("name"=>$_request["cl7_1"],"number"=>$_request["cl7_2"],"classtime"=>$_request["cl7_3"],"teacher"=>$_request["cl7_4"]),
array("name"=>$_request["cl8_1"],"number"=>$_request["cl8_2"],"classtime"=>$_request["cl8_3"],"teacher"=>$_request["cl8_4"]),
array("name"=>$_request["cl9_1"],"number"=>$_request["cl9_2"],"classtime"=>$_request["cl9_3"],"teacher"=>$_request["cl9_4"]),
array("name"=>$_request["cl10_1"],"number"=>$_request["cl10_2"],"classtime"=>$_request["cl10_3"],"teacher"=>$_request["cl10_4"])
);
// arrangetype
$arrangetype = $_request["arrangetype"];
$arrangetypestr = "";
for($i=0;$i
$arrangetypestr .= $arrangetype[$i];
}
// netclass cards
$netclasscards = $_request["netclasscards"];
$netclasscardstr = "";
for($i=0;$i
$netclasscardstr .= $netclasscards[$i];
}
//echo $netclasscardstr;
$uploadfilepath = "";
if($_files["file"]["name"] != ""){
include_once 'uploadfile.php';
if($upfilename != "" && $upfilename != null) $uploadfilepath = "upload/" . $upfilename;
}
$s = new haya_db();
$qinsert = "insert into jwlist (".
"username,".
"gender,".
"testdate,".
"monaddate,".
"email,".
"tel1,".
"tel2,".
//"listtype,".
"parentinfo,".
"studentinfo,".
"continueclass,".
"studiedclassno,".
"teachername,".
"consultant,".
"assistant,".
"senateclass,".
"senateaudit,".
"classno,".
"classname,".
"grade,".
"classsuffix,".
"startdate,".
"enddate,".
"classfrequency,".
"classplace,".
"fee,".
"describes,".
"transferfee,".
"normalnumber,".
"classroom,".
"arrangetype,".
"classarrange,".
"discount,".
"discountreson1,".
"discountreson2,".
"discountreson3,".
"unitprice,".
"allclassfrequency,".
"allclasstimes,".
"allfee,".
"teachbookapplier,".
"teachbookapplyno,".
"lesoncardno,".
"books,".
"netclasscards,".
"status,".
"applytime,".
"applyuser,".
"uploadfilepath".
") values (".
"'" . $username . "', '" .
$gender . "', '" .
$testdate . "', '" .
$monaddate . "', '" .
$email . "', '" .
$tel1 . "', '" .
$tel2 . "', '" .
//$listtype . "', '" .
$parentinfo . "', '" .
$studentinfo . "', '" .
$continueclass . "', '" .
$studiedclassno . "', '" .
$teachername . "', '" .
$consultant . "', '" .
$assistant . "', '" .
$senateclass . "', '" .
$senateaudit . "', '" .
$classno . "', '" .
$classname . "', '" .
$grade . "','" .
$classsuffix . "', '" .
$startdate . "', '" .
$enddate . "', '" .
$classfrequency . "', '" .
$classplace . "', '" .
$fee . "', '" .
$describe . "', '" .
$transferfee . "', '" .
$normalnumber . "', '" .
$classroom . "', '" .
$arrangetypestr . "', '" .
$classarrange . "', '" .
$discount . "', '" .
$discountreson1 . "', '" .
$discountreson2 . "', '" .
$discountreson3 . "', '" .
$unitprice . "', '" .
$allclassfrequency . "', '" .
$allclasstimes . "', '" .
$allfee . "', '" .
$teachbookapplier . "', '" .
$teachbookapplyno . "', '" .
$lesoncardno . "', '" .
$books . "', '" .
$netclasscardstr . "', '" .
"1',".
"now(),'".
$applyuser."','".
$uploadfilepath . "'" .
")";
//echo $qinsert;
$resultstr = $s->query($qinsert);
$lastid = $s->getlastinsertid();
if(!$resultstr) echo '<script>alert("upload not successful!");history.go(-1);</script>';
else{
//$q2 = "select max(id) from jwlist";
//$rsid = $s->query($q2);
//echo $lastid;
//echo "cl count : ".count($cl);
for($i=0;$i
$qinsert2 = "insert into course (".
"listid,".
"name,".
"number,".
"classtime,".
"teacher".
") values (".
"'" . $lastid . "', '" .
$cl[$i]["name"] . "', '" .
$cl[$i]["number"] . "', '" .
$cl[$i]["classtime"] . "', '" .
$cl[$i]["teacher"] . "'" .
")";
//echo $qinsert2;
$result2 = $s->query($qinsert2);
if(!$result2) echo "false";
else echo "true";
}
echo '<script>alert("upload successful!");history.go(-1);</script>';
}
//echo '<script>history.go(-1);</script>';
?>
====================== ================
=============php 配置文件=======================
;;;;;;;;;;;;;;;;
; file uploads ;
;;;;;;;;;;;;;;;;
; whether to allow http file uploads.
; http://www.php.net/manual/en/ini.core.php#ini.file-uploads
file_uploads = on
; temporary directory for http uploaded files (will use system default if not
; specified).
; http://www.php.net/manual/en/ini.core.php#ini.upload-tmp-dir
upload_tmp_dir = /var/www/html/upload
; maximum allowed size for uploaded files.
; http://www.php.net/manual/en/ini.core.php#ini.upload-max-filesize
upload_max_filesize = 10m
回复讨论(解决方案)
所有文件都不行？小文件试了吗？
所有文件都不行？小文件试了吗？ 其他可以正常上传。
之前有一份正常运行的网页程序，都可以正常上传，现在发的这个代码和这个代码相关的.php文件都已经确认跟之前程序 代码以至。 变的 只是 平台 由windows 变为 linux apache配置 和 mysql配置和mysql库都 都跟以前是一致的，（当然linux 和windows配置有区别这个可以忽略） 网页其他运行都正常。 就是这个表单总是提交以后提示 NOT successful...
if(!$resultstr) echo '<script>alert("Upload NOT successful!");history.go(-1);</script>';
显然是查询失败了 $resultstr = $s->query($qinsert);
你打印出 $qinsert 看看
如果有中文请注意编码
if(!$resultstr) echo '<script>alert("Upload NOT successful!");history.go(-1);</script>';
显然是查询失败了 $resultstr = $s->query($qinsert);
你打印出 $qinsert 看看
如果有中文请注意编码 utf8_general_ci可以不 是包含中文的
utf8_general_ci 只是说内容按 utf8 存储，不表示你给他的数据是正确的
除非你在安装 mysql 时做了字符集设置（即便做了也不见得就是utf8的），否则都是 latin1 的
所以都应该有执行 set names 页面编码
$resultstr = $s->query($qinsert);输出$resultstr瞧瞧。
utf8_general_ci 只是说内容按 utf8 存储，不表示你给他的数据是正确的
除非你在安装 mysql 时做了字符集设置（即便做了也不见得就是utf8的），否则都是 latin1 的
所以都应该有执行 set names 页面编码
都已经设置成 UTF8 PHP里是默认 mysql_query("set names ‘utf8’")问题依旧
$resultstr = $s->query($qinsert);输出$resultstr瞧瞧。
$resultstr = $s->query($qinsert);输出$resultstr瞧瞧。
具体怎么输出呢
如果以前有编码问题，那么只用修改后插入的数据才可能是正确的
如果以前有编码问题，那么只用修改后插入的数据才可能是正确的 以前没有编码问题
