溫瑞烘老師的教學歷程檔案(Teaching ePortfolio) - 105-1-資料庫程式設計 - 第13週-MySQL-PHP-CHECKBOX-新增-查詢-刪除-更新範例

資訊管理系
副教授
温瑞烘

歷程檔案 Portfolio

關於我 About Me

第13週-MySQL-PHP-CHECKBOX-新增-查詢-刪除-更新範例

壹

.DROP DATABASE IF EXISTS mydb;

CREATE DATABASE mydb DEFAULT CHARACTER SET utf8;

USE mydb;

CREATE TABLE stmd (

oid INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '遞增識別碼',

depart_class VARCHAR(16) COMMENT '甲班、乙班、丙班、丁班',

student_no VARCHAR(16) COMMENT '1號、2號、3號、4號',

student_name VARCHAR(16) COMMENT '陳生、林生、張生、謝生',

address VARCHAR(16) COMMENT '台北、新北、台中、高雄',

primary key(oid)

);

貳

<?php

include "config.php";

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

else $command="";

if ($command=="" || $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);

display_first_page($conn);

}

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

display_delete_page($conn);

display_first_page($conn);

}

mysqli_close($conn);

function display_first_page($conn) {

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

</head><body><center>

<tr class='alt0'><td colspan=2>MySql與PHP結合-CHECKBOX-新增-查詢-刪除-更新範例</td></tr>

<td><input type='checkbox' name='depart_class[]' value='甲班'/>甲班

<input type='checkbox' name='depart_class[]' value='乙班'/>乙班

<input type='checkbox' name='depart_class[]' value='丙班'/>丙班

<input type='checkbox' name='depart_class[]' value='丁班'/>丁班

</td></tr></table>

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

}

function display_search_page($conn) {

$depart_class=$_POST["depart_class"];

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

else $depart_class="%".implode(",",$depart_class)."%";

$sql="select * from stmd where depart_class like '$depart_class' order by oid";

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

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

</head><body><center>

<tr class='alt0'><td colspan=2>MySql與PHP結合-CHECKBOX-新增-查詢-刪除-更新範例</td></tr>

<tr class='alt1'><td>班級代碼</td><td>選擇</td></tr>";

$cnt=0;

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

$oid=$myrow["oid"];

$depart_class=$myrow["depart_class"];

$bgcolor=$cnt % 2+ 2;

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

<td><input type='radio' name='oid' value='$oid'></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"];

if ($depart_class!="") $depart_class=implode(",",$depart_class);

if ($depart_class=="") {

display_first_page($conn); exit;

}

$sql="insert into stmd values(null,'$depart_class','','','')";

mysqli_query($conn,$sql);

}

function display_modify_page($conn) {

$dept_list=array("甲班","乙班","丙班","丁班");

$oid=$_POST["oid"];

if ($oid=="") {

display_first_page($conn); exit();

}

$sql="select * from stmd where oid=$oid";

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

$myrow=mysqli_fetch_array($result);

$depart_class_list=explode(",",$myrow["depart_class"]);

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

</head><body><center>

<tr class='alt0'><td colspan=2>MySql與PHP結合-CHECKBOX-新增-查詢-更新-刪除範例</td></tr>

<tr><td class='alt1'>班級代碼</td><td>";

for ($i=0; $i<count($dept_list); $i++) {

$dp=$dept_list[$i];

if (in_array($dp,$depart_class_list))

echo "<input type='checkbox' name='depart_class[]' value='$dp' checked />$dp";

else

echo "<input type='checkbox' name='depart_class[]' value='$dp' />$dp";

}

echo "</td></tr></table>

<input class='cmd1' type='submit' name='command' value='更新確認'

onclick=\"return confirm('確定要更新嗎');\" >

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

}

function display_delete_page($conn) {

$oid=$_POST["oid"];

if ($oid=="") {

display_first_page($conn); exit();

}

$sql="delete from stmd where oid=$oid";

mysqli_query($conn,$sql);

}

function display_confirm_page($conn) {

$oid=$_POST["oid"];

$depart_class=$_POST["depart_class"];

if ($depart_class!="") $depart_class=implode(",",$depart_class);

if ($depart_class=="") {

display_first_page($conn); exit;

}

$sql="update stmd set depart_class='$depart_class' where oid=$oid";

mysqli_query($conn,$sql);

}

參

根據資料表寫出完整的程式

全部共 0則留言

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

文章分類 Labels

最新文章 Top10

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