学生信息管理 浏览学生信息
getMessage()); } //2.执行sql $sql_select = "select * from stu"; //3.data 解析 foreach ( $pdo->query($sql_select) as $row) { echo " ID 姓名 性别 年龄 班级 操作 "; echo " "; } ?>{$row['id']} "; echo "{$row['name']} "; echo "{$row['sex']} "; echo "{$row['age']} "; echo "{$row['classid']} "; echo "修改 删除 "; echo "
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; }
学生管理系统 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']}"); } ?> 修改学生信息
已抢185220个
抢已抢66844个
抢已抢351927个
抢已抢665251个
抢已抢119729个
抢已抢19537个
抢