创建action.php 文件
本文件使用了switch,case语句,将删除,修改,添加等对数据的处理放在同一个页面,减少了代码的重复性
代码如下<?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?"";
}else{
echo?"";
}
header('Location:?index.php');
break;
case?'del'://get
$id?=?$_GET['id'];
$sql?=?"delete?from?stu?where?id='$id'";
$rw?=?mysqli_query($conn,$sql);
if?($rw?>?0){
echo?"";
}else{
echo?"";
}
header('Location:?index.php');
break;
case?'edit'://post
$id?=?$_POST['id'];
$name?=?$_POST['name'];
$age?=?$_POST['age'];
$class?=?$_POST['class'];
$sex?=?$_POST['sex'];
//????echo?$id,?$age,?$age,?$name;
$sql?=?"update?stu?set?name='$name',?age='$age',sex='$sex',class='$class'?where?id='$id';";
//????$sql?=?"update?myapp.stu?set?name='jike',sex='女',?age=24,classid=44?where?id=17";
//????????????print?$sql;
$rw?=?mysqli_query($conn,$sql);
//????????????var_dump($rw);
//????????????die();
if?($rw?>?0){
echo?"";
}else{
echo?"";
}
header('Location:?index.php');
break;
default:
header('Location:?index.php');
break;
}
}else{
die('数据库连接失败'?.mysqli_connect_error());
}
?>
BC链 http://www.chinabic.com/?id=235 转载需授权!
网友评论