跳至
[1]
[2]
[3]
[4]
[5]
[全屏预览]
学生信息管理
浏览学生信息
| ID |
姓名 |
性别 |
年龄 |
班级 |
操作 |
getMessage());
}
//2.执行sql
$sql_select = "select * from stu";
//3.data 解析
foreach ( $pdo->query($sql_select) as $row) {
echo "";
echo "| {$row['id']} | ";
echo "{$row['name']} | ";
echo "{$row['sex']} | ";
echo "{$row['age']} | ";
echo "{$row['classid']} | ";
echo "
修改
删除
| ";
echo "
";
}
?>
2. [文件]
add.php ~ 1KB
下载(1)
跳至
[1]
[2]
[3]
[4]
[5]
[全屏预览]
学生管理系统
增加学生信息
3. [文件]
action.php ~ 2KB
下载(1)
跳至
[1]
[2]
[3]
[4]
[5]
[全屏预览]
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 "";
}else{
echo "";
}
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 "";
}else{
echo "";
}
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 "";
}else{
echo "";
}
header('Location: index.php');
break;
default:
header('Location: index.php');
break;
}
4. [文件]
edit.php ~ 2KB
下载(1)
跳至
[1]
[2]
[3]
[4]
[5]
[全屏预览]
学生管理系统
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']}");
}
?>
修改学生信息
5. [文件]
menu.php ~ 179B
下载(1)
跳至
[1]
[2]
[3]
[4]
[5]
[全屏预览]
学生管理系统
浏览学生
添加学生
