phpå¦ç管çç³»ç»æºç ï¼ä¾å¤§å®¶åèï¼å
·ä½å
容å¦ä¸
åè½ï¼
1.æ·»å ï¼å é¤ï¼ä¿®æ¹
2.æ°æ®åå¨.
çé¢åå¸ï¼
index.php
--->主çé¢
add.php --->stuæ·»å
action ---> sqlä¸add/del/update
(å¤çhtml表å-->mysqlçæ°æ®åå¨ ï¼ï¼ 页é¢è·³è½¬)
edit.php --->stuä¿®æ¹
menu.php
-->é¦é¡µ
1. index.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>å¦çä¿¡æ¯ç®¡ç</title>
<script>
function doDel(id) {
if(confirm('确认å é¤?')) {
window.location='action.php?action=del&id='+id;
}
}
</script>
</head>
<body>
<center>
<?php
include ("menu.php");
?>
<h3>æµè§å¦çä¿¡æ¯</h3>
<table width="500" border="1">
<tr>
<th>ID</th>
<th>å§å</th>
<th>æ§å«</th>
<th>å¹´é¾</th>
<th>ç级</th>
<th>æä½</th>
</tr>
<?php
// 1. é¾æ¥æ°æ®åº
try{
$pdo = new PDO("uri:mysqlPdo.ini","root","1");
}catch (PDOException $e) {
die('connection failed'.$e->getMessage());
}
//2.æ§è¡sql
$sql_select = "select * from stu";
//3.data 解æ
foreach ( $pdo->query($sql_select) as $row) {
echo "<tr>";
echo "<th>{$row['id']} </th>";
echo "<th>{$row['name']}</th>";
echo "<th>{$row['sex']} </th>";
echo "<th>{$row['age']} </th>";
echo "<th>{$row['classid']}</th>";
echo "<td>
<a href='edit.php?id={$row['id']}'>ä¿®æ¹</a>
<a href='javascript:void(0);' onclick='doDel({$row['id']})'>å é¤</a>
</td>";
echo "</tr>";
}
?>
</table>
</center>
</body>
</html>
2. add.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>å¦ç管çç³»ç»</title>
</head>
<body>
<center>
<?php include ('menu.php'); ?>
<h3>å¢å å¦çä¿¡æ¯</h3>
<form action="action.php?action=add" method="post">
<table>
<tr>
<td>å§å</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>å¹´é¾</td>
<td><input type="text" name="age"></td>
</tr>
<tr>
<td>æ§å«</td>
<td><input type="radio" name="sex" value="ç·">ç·</td>
<td><input type="radio" name="sex" value="女">女</td>
</tr>
<tr>
<td>ç级</td>
<td><input type="text" name="classid"></td>
</tr>
<tr>
<!-- <td> </td>-->
<td><a href="index.php">è¿å</td>
<td><input type="submit" value="æ·»å "></td>
<td><input type="reset" value="éç½®"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
3. action.php
<?php
/**
* Created by PhpStorm.
* User: hyh
* Date: 16-7-7
* Time: ä¸å9:37
*/
//1. é¾æ¥æ°æ®åº
try{
$pdo = new PDO("uri:mysqlPdo.ini","root","1");
}catch (PDOException $e) {
// echo 'Connection failed: ' . $e->getMessage();
die('connection failed'.$e->getMessage());
}
//2.action çå¼å对æä½
switch ($_GET['action']){
case 'add'://add
$name = $_POST['name'];
$sex = $_POST['sex'];
$age = $_POST['age'];
$classid = $_POST['classid'];
$sql = "insert into stu (name, sex, age, classid) values ('{$name}', '{$sex}','{$age}','{$classid}')";
$rw = $pdo->exec($sql);
if ($rw > 0){
echo "<script>alter('æ·»å æå');</script>";
}else{
echo "<script>alter('æ·»å 失败');</script>";
}
header('Location: index.php');
break;
case 'del'://get
$id = $_GET['id'];
$sql = "delete from stu where id={$id}";
$rw = $pdo->exec($sql);
if ($rw > 0){
echo "<script>alter('å é¤æå');</script>";
}else{
echo "<script>alter('å é¤å¤±è´¥');</script>";
}
header('Location: index.php');
break;
case 'edit'://post
$id = $_POST['id'];
$name = $_POST['name'];
$age = $_POST['age'];
$classid = $_POST['classid'];
$sex = $_POST['sex'];
// echo $id, $age, $age, $name;
$sql = "update stu set name='{$name}', age={$age},sex='{$sex}',classid={$classid} where id={$id};";
// $sql = "update myapp.stu set name='jike',sex='女', age=24,classid=44 where id=17";
print $sql;
$rw = $pdo->exec($sql);
if ($rw > 0){
echo "<script>alter('æ´æ°æå');</script>";
}else{
echo "<script>alter('æ´æ°å¤±è´¥');</script>";
}
header('Location: index.php');
break;
default:
header('Location: index.php');
break;
}
4.edit.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>å¦ç管çç³»ç»</title>
</head>
<body>
<center>
<?php include ('menu.php');
//1. é¾æ¥æ°æ®åº
try{
$pdo = new PDO("uri:mysqlPdo.ini","root","1");
}catch (PDOException $e) {
die('connection failed'.$e->getMessage());
}
//2.æ§è¡sql
$sql_select = "select * from stu where id={$_GET['id']}";
$stmt = $pdo->query($sql_select);
if ($stmt->rowCount() >0) {
$stu = $stmt->fetch(PDO::FETCH_ASSOC); // 解ææ°æ®
}else{
die("no have this id:{$_GET['id']}");
}
?>
<h3>ä¿®æ¹å¦çä¿¡æ¯</h3>
<form action="action.php?action=edit" method="post">
<input type="hidden" name="id" value="<?php echo $stu['id'];?>">
<table>
<tr>
<td>å§å</td>
<td><input type="text" name="name" value="<?php echo $stu['name'];?>"></td>
</tr>
<tr>
<td>å¹´é¾</td>
<td><input type="text" name="age" value="<?php echo $stu['age'];?>"></td>
</tr>
<tr>
<td>æ§å«</td>
<td>
<input type="radio" name="sex" value="ç·" <?php echo ($stu['sex'] == "ç·")? "checked":"";?> >ç·
</td>
<td>
<input type="radio" name="sex" value="女" <?php echo ($stu['sex'] == "女")? "checked":"";?> >女
</td>
</tr>
<tr>
<td>ç级</td>
<td><input type="text" name="classid" value="<?php echo $stu['classid']?>"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" value="æ´æ°"></td>
<td><input type="reset" value="éç½®"></td>
</tr>
</table>
</form>
</center>
<?php
?>
</body>
</html>
5. menu.php
<!DOCTYPE html>
<html lang="en">
<body>
<h2>å¦ç管çç³»ç»</h2>
<a href="index.php"> æµè§å¦ç</a>
<a href="add.php"> æ·»å å¦ç</a>
<hr>
</body>
</html>
温馨提示:答案为网友推荐,仅供参考