php用表单提交到mysql数据库，但是数据库奇怪的出现两天一模一样的数据怎么回事？
给专家们看下我的代码：html中：<!DOCTYPEhtml><html><headlang="en"><metacharset="UTF-8"><title>用户添加<...
给专家们看下我的代码：
html中：
<!DOCTYPE html>
<html>
<head lang="en">
<meta charset="UTF-8">
<title>用户添加</title>
</head>
<body>
<form action="UserInsert.php" method="post" id="ms">
<div>用户名：<input type="text" name="name" /></div>
<div>密码：<input type="text" name="pwd"/> </div>
<div><a href="#2" onclick="document.getElementById('ms').submit()">提交</a> </div>
</form>
</body>
</html>
php中的代码：
<?php
/**
* Created by PhpStorm.
* User: Administrator
* Date: 2015/5/8
* Time: 15:27
*/
header("content-type:text/html;charset=utf-8");
if(isset($_POST['name'])&&isset($_POST['pwd'])){
$username=$_POST['name'];
$password=($_POST['pwd']);
$conn=mysql_connect("localhost","root","root");
mysql_query('SET NAMES utpf8');
mysql_select_db("123",$conn);
$sqlInsert="insert into users(username,password) values('{$username}','{$password}')";
mysql_query($sqlInsert);
$result=mysql_query($sqlInsert,$conn);
mysql_close($conn);
}
只要一提交到数据库，立马出现两条一模一样的数据 展开
html中：
<!DOCTYPE html>
<html>
<head lang="en">
<meta charset="UTF-8">
<title>用户添加</title>
</head>
<body>
<form action="UserInsert.php" method="post" id="ms">
<div>用户名：<input type="text" name="name" /></div>
<div>密码：<input type="text" name="pwd"/> </div>
<div><a href="#2" onclick="document.getElementById('ms').submit()">提交</a> </div>
</form>
</body>
</html>
php中的代码：
<?php
/**
* Created by PhpStorm.
* User: Administrator
* Date: 2015/5/8
* Time: 15:27
*/
header("content-type:text/html;charset=utf-8");
if(isset($_POST['name'])&&isset($_POST['pwd'])){
$username=$_POST['name'];
$password=($_POST['pwd']);
$conn=mysql_connect("localhost","root","root");
mysql_query('SET NAMES utpf8');
mysql_select_db("123",$conn);
$sqlInsert="insert into users(username,password) values('{$username}','{$password}')";
mysql_query($sqlInsert);
$result=mysql_query($sqlInsert,$conn);
mysql_close($conn);
}
只要一提交到数据库，立马出现两条一模一样的数据 展开
2个回答
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
