PHP開發(fā) 學生管理系統(tǒng)之添加信息PHP頁面
接收從add.php頁面?zhèn)鬟^來的數(shù)據(jù),將數(shù)據(jù)保存到數(shù)據(jù)庫中
提示:本教程是將添加,修改,刪除,的PHP代碼放在同一個PHP頁面,我們用了switch,case語句,下面的代碼是不完整的action.php 文件代碼,等我們將添加,修改,刪除的功能完成,會將完整的代碼展示給大家
先鏈接我們的數(shù)據(jù)庫
header("content-type:text/html;charset=utf8");
$conn=mysqli_connect("localhost","root","root","study");
mysqli_set_charset($conn,"utf8");
$conn=mysqli_connect("localhost","root","root","study");
mysqli_set_charset($conn,"utf8");
接收我們從添加頁面?zhèn)鬟^來的信息
$name?=?$_POST['name'];
$sex?=?$_POST['sex'];
$age?=?$_POST['age'];
$class?=?$_POST['class'];
$sex?=?$_POST['sex'];
$age?=?$_POST['age'];
$class?=?$_POST['class'];
在對我們的數(shù)據(jù)庫進行數(shù)據(jù)插入
$sql?=?"insert?into?stu?(`name`,?sex,?age,?class)?values?('$name',?'$sex','$age','$class')";
$rw?=?mysqli_query($conn,$sql);
$rw?=?mysqli_query($conn,$sql);
添加信息代碼如下
<?php header("content-type:text/html;charset=utf8"); $conn=mysqli_connect("localhost","root","root","study"); mysqli_set_charset($conn,"utf8"); if($conn){ switch ($_GET['action']){ case 'add'://add $name = $_POST['name']; $sex = $_POST['sex']; $age = $_POST['age']; $class = $_POST['class']; $sql = "insert into stu (`name`, sex, age, class) values ('$name', '$sex','$age','$class')"; $rw = mysqli_query($conn,$sql); if ($rw > 0){ echo "<script>alert('添加成功');</script>"; }else{ echo "<script>alert('添加失敗');</script>"; } } } header('Location: index.php'); break; ?>
下一步就是將我們添加的信息展示出來