表格怎么插不进数据
表格怎么插不进数据
4 回答
userlist代码：
<?php
$mysqli= new mysqli("localhost","root","","bb");
if($mysqli->errno){
die('Connect Error:'.$mysqli->error);
}else{
$mysqli->set_charset('UTF8');
}
$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 http-equiv="Content-Type" content="text/html; 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">删除</a></td>
</tr>
<?php $i++; endforeach;?>
</table>
</body>
</html>
addUser代码：
/*<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>登录成功</title>
</head>
<body>
<h2>添加用户</h2>
<form action="doAction.php?act=addUser"method='post'>
<table border='1' cellpadding='0' cellspacing='0' bgcolor='#ABCDEF' width='80%'>
<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="" min='1' max='125' placeholder='请输入密码' required="required"/></td>
</tr>
<tr>
<td>年龄</td>
<td><input type="number" name="age" id="" placeholder='请输入合法年龄' required="required"/></td>
</tr>
<tr>
<td colspan='2'><input type="submit" value="添加用户"/></td>
</tr>
</table>
</form>
</body>
</html>
*/
//这是addUser.php页面代码
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8">
<title>添加用户</title>
</head>
<body>
<h2>添加用户</h2>
<form action="doAction.php?act=addUser" method="post">
<table cellpadding="0" cellspacing="0" bgcolor="#ABCDEF" width="45%" border="1">
<tr>
<td>用户名</td>
<td><input type="text" name="username" placeholder="请输入用户名" required="required"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="password" placeholder="请输入密码" required="required"></td>
</tr>
<tr>
<td>年龄</td>
<td><input type="text" name="age" min="1" max="125" placeholder="请输入年龄"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="" value="提交"></td>
</tr>
</table>
</form>
</body>
</html>
doAction代码：
<?php
//接收页面
header('Content-Type" content="text/html; charset=utf-8');
$mysqli= new mysqli("localhost","root","","bb");
if($mysqli->errno){
die('Connect Error:'.$mysqli->error);
}
$mysqli->set_charset('utf8');
$username=$_POST['username'];
$username=$mysqli->escape_string($username);
$password=md5($_POST['password']);
$age=$_POST['age'];
$act=$_GET['act'];
//根据不同操作完成不同功能
switch($act){
case 'addUser':
echo '添加用户的操作';
$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('添加成功，网站的第{$insert_id}位用户');
location.href='userlist.php';
</script>";
}else{
echo "<script type='text/javascript'>
alert('添加失败，重新添加');
location.href='addUser.php';
</script>";
}
break;
}
举报
0/150
提交
取消
