//doaction.php
<?php
header('content-type:text/html;charset=utf-8');
$mysqli=?new?mysqli('localhost','root','127656','class');
if($mysqli->connect_errno){
????die($mysqli->connect_error);
}
$mysqli->set_charset('utf8');
$username=$_POST['username'];
$username=$mysqli->escape_string($username);
$password=($_POST['password']);
$age=$_POST['age'];
$act=$_GET['act'];
$id=$_GET['id'];
switch($act){
????????case?'adduser':
????????$sql="INSERT?user(username,password,age)?VALUES('{$username}','{$password}','{$age}')";
????????$res=$mysqli->query($sql);
????????if($res){
????????????$insert_id=$mysqli->insert_id;
????????????echo?"<script?type='text/javascript'>
????????????????alert('添加成功，網(wǎng)站的第{$insert_id}位用戶');
????????????????location.href='userlist.php';
????????????</script>";
????????????exit;
????????}
????????else{
????????????echo?"<script?type='text/javascript'>
????????????????alert('添加失敗，重新添加');
????????????????location.href='adduser.php';
????????????</script>";
????????????exit;
????????}
????????break;
????????case?'deluser':
????????//echo?'刪除記錄'.$id;
????????$sql="?DELETE?FROM?user?WHERE?id=".$id;
????????$res=$mysqli->query($sql);
????????if($res){
????????????$mes='刪除成功';
????????}
????????else{
????????????$mes?='刪除失敗';
????????}
????????$url='userlist.php';
????????echo?"<script?type='text/javascript'>
????????????????alert('{$mes}');
????????????????location.href='{$url}';
????????????</script>";
????????????exit;
????????break;
???}
?>
//userlist.php
<?php
header('content-type:text/html;charset=utf-8');
$mysqli=new?mysqli('localhost','root','127656','class');
if($mysqli->connect_errno){
????die('CONNECT?ERROR：'.$mysqli->connect_error);
}
$mysqli->set_charset('utf-8');
$sql="SELECT?id,userName,age?FROM?user";
$mysqli_result=$mysqli->query($sql);
if($mysqli_result?&&?$mysqli_result->num_rows>0){
????while($row=$mysqli_result->fetch_assoc()){
????????$rows[]=$row;
????}
}
print_r($rows);
?>
<!DOCTYPE?html>
<html>
????<head>
????????<meta?charset="UTF-8">
????????<title></title>
????
????</head>
????<body>
????????<h2>用戶列表-<a?href="adduser.php">添加用戶</a></h2>
????????<table?border="1"?cellpadding="0"?cellspacing="0"?width="80%"?bgcolor="#abcdef">
????????????<tr>
????????????????<td>編號</td>
????????????????<td>用戶名</td>
????????????????<td>年齡</td>
????????????????<td>操作</td>
????????????</tr>
????????????<?php?$i=1;foreach($rows?as?$row):?>
????????????<tr>
????????????????<td><?php?echo?$i;?></td>
????????????????<td><?php?echo?$row['userName'];?></td>
????????????????<td><?PHP?echo?$row['age'];?></td>
????????????????<td><a?href="edituser.php">更新</a>|<a?href="doaction.php?act=deluser&id=<?php?
????????????????????echo?$row['id'];?>">刪除</a></td>
????????????</tr>
????????????<?php?$i++;?endforeach;?>
????????</table>
????</body>
</html>
//adduser.php
<!?DOCTYPE?html>
<html>
????<head>
????????<meta?charset="UTF-8">
????????<title></title>
????
????</head>
????<body>
????????<form?action="doaction.php?act=adduser"?method='post'>
????????????<table?border="1"?cellpadding="0"?cellspacing="0"?width="80%"?bgcolor="#abcdef">
????????????<tr>
????????????????<td>用戶名</td>
????????????????<td><input?type="text"?name="username"?id=""?placeholder="請輸入合法用戶名"?required="required"/></td>
????????????</tr>
??????????????<tr>
????????????????<td>密碼</td>
????????????????<td><input?type="password"?name="password"?id=""?placeholder="請輸入密碼"?required="required"/></td>
????????????</tr>
??????????????<tr>
????????????????<td>年齡</td>
????????????????<td><input?type="number"?name="age"?id=""?min='1'?max="125"?placeholder="請輸入年齡"?required="required"/></td>
????????????</tr>
??????????????<tr>
????????????????<td?colspan="2"><input?type="submit"?value="添加用戶"/></td>
????????????</tr>
????????????</table>
????</body>
</html>
添加失敗，notice id未定義
qq_Onecallaway_1
2018-05-14 22:25:04