[心得] chap14-1.php
<!doctype html public "-//W3C//DTD HTML 4.01//EN">
<html>
<head>
<title>作業上傳</title>
<meta http-equiv="generator" content="PHP Designer 2005" />
</head>
<body bgcolor="#FFFFFF" text="#000000" link="#0000FF" vlink="#800080"
alink="#FF0000">
<br>
<form enctype="multipart/form-data" action = "chap14-1.php?CB=1"
method="post">
輸入要上傳的檔案名稱: <input name="userUploadFile" type="file"><br><br>
學號:<input name="studentno" type="text"><br><br>
作業名稱:<input name="workname" type="text"><br><br>
姓名:<input name="name" type="text"><br><br>
<input type="submit" name="Submit1" value="檔案上傳">
</form>
<?php
if($_GET['CB'] == "1") {
$fileNameSet = $_FILES['userUploadFile']['name'] ;
$fileTypeSet = $_FILES['userUploadFile']['type'] ;
$fileSizeSet = $_FILES['userUploadFile']['size'] ;
$fileTempSet = $_FILES['userUploadFile']['tmp_name'] ;
$_POST['studentno']=$studentno;
$_POST['workname'] = $workname;
$_POST['name'] = $name;
copy ($fileTempSet,"C:\\AppServ\\www\\Temp\\".$fileNameSet) ;
echo "<br>" ;
echo "上傳檔案名稱->".$fileNameSet."<br>" ;
echo "<br>" ;
echo "上傳檔案類型->".$fileTypeSet."<br>" ;
echo "<br>" ;
echo "上傳檔案大小->".$fileSizeSet."<br>" ;
echo "<br>" ;
echo "上傳檔案暫存->".$fileTempSet."<br>" ;
echo "<br>" ;
echo "上傳檔案複製為->"."C:\\AppServ\\www\\Temp\\".$fileNameSet."<br>" ;
echo "<br>" ;
echo "學號->".$_POST['studentno']."<br>" ;
echo "<br>" ;
echo "作業名稱->".$_POST['workname']."<br>" ;
echo "<br>" ;
echo "姓名->".$_POST['name']."<br>" ;
echo "<br>" ;
}
putenv("TZ=Asia/Taipei");
$nowDate =date("Y/m/d H:i:s");
$_POST['studentno']=$studentno;
$_POST['nowDate'] = $nowDate;
$_POST['workname'] = $workname;
$_POST['name'] = $name;
$_POST['fileNameSet'] = $fileNameSet;
if (trim ($_GET ['CB'])!=0)
{
$intODBCConnectHandle = odbc_connect("WORKODBC","Sa","") ;
if ($intODBCConnectHandle != 0)
{
$boolOpenTableResultExec = odbc_exec($intODBCConnectHandle,"INSERT INTO
homework (studentno,workname,name,nowDate,fileNameSet) VALUES
('$_POST[studentno]','$_POST[workname]','$_POST[name]','".$nowDate."','$_POST[fileNameSet]')")
;
if($boolOpenTableResultExec)
echo "";
else
echo "ERROR-資料表格新增資料錄失敗" ;
odbc_close ($intODBCConnectHandle) ;
}
else
{
echo "ERROR-資料庫連結失敗 !!!" ;
}
exit (1) ;
}
?>
</body>
</html>
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.128.142.226