溫瑞烘老師的教學歷程檔案(Teaching ePortfolio) - 104-1-資料庫程式設計-基礎 - 第17週-MySQL-PHP-Insert

資訊管理系
副教授
温瑞烘

歷程檔案 Portfolio

關於我 About Me

第17週-MySQL-PHP-Insert

<?php

include "config.php";

if (isset($_POST["command"])) $command=$_POST["command"];

else $command="";

if ($command=="") {

display_first_page($conn);

}

elseif ($command=="新增") {

display_insert_page($conn);

display_first_page($conn);

}

elseif ($command=="查詢") {

display_search_page($conn);

}

elseif ($command=="更新") {

display_modify_page($conn);

}

elseif ($command=="確認") {

display_confirm_page($conn);

}

elseif ($command=="刪除") {

display_delete_page($conn);

}

mysqli_close($conn);

function display_first_page($conn) { // 第一個頁面

echo "<html><head><title>MySql與PHP結合-查詢範例</title>

</head><body><center>

<tr class='alt0'><td colspan=4>MySql與PHP結合-查詢-新增-範例</td></tr>

</form></center></body></html>";

}

function display_search_page($conn) {

$depart_class=trim($_POST["depart_class"]);

$student_no=trim($_POST["student_no"]);

$student_name=trim($_POST["student_name"]);

$address=trim($_POST["address"]);

if ($depart_class=="") $depart_class="%";

else $depart_class="%".$depart_class."%";

if ($student_no=="") $student_no="%";

else $student_no="%".$student_no."%";

if ($student_name=="") $student_name="%";

else $student_name="%".$student_name."%";

if ($address=="") $address="%";

else $address="%".$address."%";

$sql="select * from stmd where depart_class like '$depart_class' and ";

$sql.="student_no like '$student_no' and student_name like '$student_name' ";

$sql.="and address like '$address' order by depart_class,student_no";

$result=mysqli_query($conn,$sql); // SQL命令執行

echo "<html><head><title>MySql與PHP結合-更新-刪除-範例</title>

</head><body><center>

<tr class='alt0'><td colspan=5>MySql與PHP結合-更新-刪除-範例</td></tr>

<tr class='alt1'><td>班級</td><td>學號</td><td>姓名</td><td>地址</td><td>選擇</td></tr>";

$cnt=0;

while ($myrow=mysqli_fetch_array($result)) {

$depart_class=$myrow["depart_class"];

$student_no=$myrow["student_no"];

$student_name=$myrow["student_name"];

$address=$myrow["address"];

$bgcolor=$cnt % 2+ 2;

echo "<tr class='alt$bgcolor'><td>$depart_class</td><td>$student_no</td>

<td>$student_name</td><td>$address</td>

<td><input type=radio name=student_no value='$student_no'></td></tr>";

$cnt++;

}

echo "</table>

<input class='cmd' type='submit' name='command' value='刪除'

onclick=\"return confirm('??? 確定要刪除嗎 ???')\" >

</form></center></body></html>";

}

function display_insert_page($conn) {

$depart_class=$_POST["depart_class"];

$student_no=$_POST["student_no"];

$student_name=$_POST["student_name"];

$address=$_POST["address"];

if ($depart_class=="" || $student_no=="" || $student_name=="" || $address=="") {

display_first_page($conn); exit();

}

$sql="insert into stmd values('$depart_class','$student_no','$student_name','$address')";

mysql_iquery($conn,$sql);

}

function display_modify_page($conn) {

$student_no=$_POST["student_no"];

if ($student_no=="") return;

$sql="select * from stmd where student_no='$student_no'";

$result=mysqli_query($conn,$sql);

$myrow=mysqli_fetch_array($result);

$depart_class=$myrow["depart_class"]; // 取出欄位

$student_name=$myrow["student_name"]; // 取出欄位

$address=$myrow["address"]; // 取出欄位

echo "<html><head><title>MySql與PHP結合-查詢範例</title>

</head><body><center>

<tr class='alt0'><td colspan=4>MySql與PHP結合-查詢-新增-範例</td></tr>

</table>

</form></center></body></html>";

}

function display_confirm_page($conn) {

$depart_class=$_POST["depart_class"];

$student_no=$_POST["student_no"];

$student_name=$_POST["student_name"];

$address=$_POST["address"];

if ($depart_class=="" || $student_no=="" || $student_name=="" || $address=="") {

display_first_page($conn); exit();

}

$sql="update stmd set ..... where student_no=..... ";

mysqli_query($conn,$sql);

}

function display_delete_page($conn) {

$student_no=$_POST["student_no"];

if ($student_no=="") return;

// 加入刪除的程式碼

}

全部共 0則留言

登入帳號密碼代表遵守學術網路規範

文章分類 Labels

最新文章 Top10

中華科技大學數位化學習歷程 - 意見反應