表格怎么插不进数据
郑小亮
2017-04-09 21:14
表格怎么插不进数据
4回答
-
- __init__29
- 2020-03-15 23:32:52
你的 INSERT 后面少写 INTO
-
- 慕粉3531781
- 2017-05-24 21:19:17
你把$password的那个md5去掉试试看 就是不用md5来加密，直接插入数据
-
- 郑小亮
- 2017-04-09 21:28:27
求大神帮忙解答，是数据库的问题吗
-
- 郑小亮
- 2017-04-09 21:27:49
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;
}
Duang~MySQLi扩展库来袭
28645 学习 · 181 问题
相似问题
回答 3
回答 2