第7週-上傳網頭資料程式介面
<?php
include "epconfig.php";
$command=$_POST["command"];
if ($command=="上傳網頭資料") {
display_first_page($conn);
display_second_page($conn);
}
elseif ($command=="上傳") {
display_upload_page($conn);
display_first_page($conn);
display_second_page($conn);
}
elseif ($command=="刪除") {
display_delete_page($conn);
display_first_page($conn);
display_second_page($conn);
}
mysqli_close($conn);
function display_first_page($conn) {
$msg="上傳Eportfolio的網頭資料";
echo "<html><head><title>$msg</title>
<link rel='stylesheet' type='text/css' href='style.css'>
</head><body><center><table>
<tr class='alt0'><td colspan=4>$msg</td></tr>
<form name=myform method=post enctype=multipart/form-data action=''>
<tr><td class='alt1'>選擇檔案</td>
<td><input type='file' id='filename' name='filename'></td><td>
<input class='cmd' type='submit' name='command' value='上傳'></td>
</tr></table></form></center></body></html>";
}
function display_second_page($conn) {
$msg="上傳Eportfolio的網頭資料";
echo "<html><head><title>$msg</title>
<link rel='stylesheet' type='text/css' href='style.css'>
</head><body><center><table>
<tr class='alt0'><td colspan=2>$msg</td></tr>
<tr class='alt1'><td width=90%>網頭</td><td>選擇</td></tr>";
$sql=" ";
$result=mysqli_query($conn,$sql);
$cnt=0;
while ($myrow=mysqli_fetch_array($result)) {
$oid=$myrow["oid"]; // epheader.oid
$fname=$myrow["fname"]; // epheader.fname
$target="./headers/$fname"; // 存放位置
$bg=$cnt % 2 + 2;
$cnt++;
echo "<tr class='alt$bg'><td><img src='$target' height=80></img></td>
<form name=myform method='post' action=''><td>
<input class='cmd' type=submit name='command' value='刪除'
onclick=\"return confirm('?????確定要刪除嗎?????');\" >
<input type=hidden name='oid' value='$oid'>
<input type=hidden name='fname' value='$fname'>
</td></tr></form>";
}
echo "</table></center></body></html>";
} function display_upload_page($conn) {
$filename=$_FILES["filename"]["name"];
if ($filename=="") {
echo "<script> alert('必須選擇檔案f') </script>"; return;
}
$ext=file_extension($filename);
$ext=strtolower($ext);
if ($ext!="jpg" && $ext!="png" && $ext!="gif") {
echo "<script> alert('檔案型態必須是jpg、png 或 gif') </script>"; return;
}
$target="headers";
if (!file_exists($target)) {
mkdir($target); chmod($target,0777);
}
$target="./headers/$filename";
if (!move_uploaded_file($_FILES["filename"]["tmp_name"], $target)) {
echo "<script> alert('上傳檔案失敗，請聯絡電算中心'); </script>"; return;
}
$sql =" "; // 插入 epheader
mysqli_query($conn,$sql);
echo "<script> alert('上傳成功'); </script>";
} function file_extension($filename) {
$path_info = pathinfo($filename);
return $path_info['extension'];
} function display_delete_page($conn) {
// 刪除資料表內容與資料夾檔案(unlink) }
?>
完成程式後, 請設計至少2個網投,並在建立資料庫與資料表時, 載入網頭
即建立epheader.txt, 並在建立create table epheader後加入 LOAD DATA INFILE
| 
