PHP+Ajax查询数据库、完成表单注册

1、HTML代码

<div class="sct2">
	<form action="2.php" method="POST">
		<table>
			<tr>
				<td>用户编号:</td>
				<td>
					<input type="text" name="uid" id="uid" placeholder="请输入用户编号" />
				</td>
			</tr>
			<tr>
				<td>用户名:</td>
				<td>
					<input type="text" name="uname" id="uname" placeholder="请输入用户名" />
				</td>
			</tr>
			<tr>
				<td>密码:</td>
				<td>
					<input type="password" name="pwd" id="pwd" placeholder="请输入密码" />
				</td>
			</tr>
			<tr>
				<td>年龄:</td>
				<td>
					<input type="text" name="age" id="age" placeholder="请输入年龄" />
				</td>
			</tr>
			<tr>
				<td></td>
				<td>
					<button type="submit" id="regist">注册</button>
				</td>
			</tr>
		</table>
	</form>
</div>

2、JS代码

var uname=$("#uname").val();
var pwd=$("#pwd").val();
var age=$("#age").val();
var dataString = 'uname='+uname + '&pwd=' + pwd + '&age=' + age;
$("#regist").click(function(){
	$.ajax({
		type:'POST',
		url:'2.php',
		data:'dataString',
		success:function(){
			alert("发送表单成功!");
		},
		error:function(){
			alert("发送表单失败!");
		}
	});
});

3、PHP代码

//获取前端表单数据
$uid=$_REQUEST['uid'];
$uname=$_REQUEST['uname'];
$pwd=$_REQUEST['pwd'];
$age=$_REQUEST['age'];

echo $uid."<br/>";
echo $uname."<br/>";
echo $pwd."<br/>";
echo $age."<br/>";

//连接数据库
mysql_connect("127.0.0.1","root","");//连接MySQL
mysql_select_db("taobao");//选择数据库
mysql_query("set names 'utf8' ");

//验证用户名是否存在
$uname = $_REQUEST["uname"];
$sql="SELECT  user_name  from taobao_user where user_name='$uname' ";
$query=mysql_query($sql);
$rows = mysql_num_rows($query);

//如果用户名不存在,插入数据
if($rows>0){
	echo "用户名已存在,注册失败"; 
}else{
	$sql = "INSERT INTO taobao_user (user_id,user_name,user_pwd,user_age) values 
		('$uid','$uname','$pwd','$age')";
	mysql_query($sql);
	echo "注册成功!";
}