php学生管理系统（最简易）

<?php /** * Created by PhpStorm. * User: Administrator * Date: 2018/1/17 * Time: 14:17 */ //1.连接数据库 try{ $pdo = new PDO("mysql:host=10.30.164.166:3306;dbname=student","root","surecims"); }catch (Exception $e){ die("数据库连接失败".$e->getMessage()); } //2.防止中文乱码 $pdo->query("SET NAMES 'UTF-8'"); //3.根据flag对应操作 if($_GET['flag']=="add"){ $student_name = $_POST['student_name']; $student_sex = $_POST['student_sex']; $student_age = (int)$_POST['student_age']; $student_class = $_POST['student_class']; //获取随机数 $randomID = date("YmdHis").rand(100,999); $sql = "insert into student(student_id,student_name,student_sex,student_age,student_class) values('{$randomID}','{$student_name}','{$student_sex}',{$student_age},'{$student_class}')"; $result = $pdo->exec($sql); echo $result; echo "<script>window.location = 'index.php'</script>"; //跳转到首页 } elseif($_GET['flag']=="delete"){ echo "delete"; $student_id = $_GET["id"]; $sql = "delete from student where student_id = {$student_id}"; $result = $pdo->exec($sql); echo "<script>window.location = 'index.php'</script>"; }elseif($_GET["flag"]=="update") { echo "update"; $student_id = $_GET["student_id"]; $student_name = $_POST['student_name']; $student_sex = $_POST['student_sex']; $student_age = (int)$_POST['student_age']; $student_class = $_POST['student_class']; $sql = "UPDATE student SET student_name='{$student_name}',student_sex='{$student_sex}',student_age={$student_age},student_class='{$student_class}' WHERE student_id='{$student_id}'"; $result = $pdo->exec($sql); echo "<script>window.location = 'index.php'</script>"; }else{ }