无法insert 数据进入mysql-php教程-PHP中文网

无法insert 数据进入mysql

php中文网

发布： 2016-06-23 13:49:34

原创

1104人浏览过

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head>    <body>	    <form action="registerProc.php" method="post">		<table align="center">			<tr>				<td width="80">用户名：</td>				<td width="180"><input type="text" name="username"					id="username"></td>				<td id="mes_username"></td>			</tr>			<tr>				<td>密码：</td>				<td><input type="password" name="password" id="password"></td>				<td id="mes_password"></td>			</tr>			<tr>				<td>确认密码：</td>				<td><input type="password" name="password2" id="password2"></td>				<td id="mes_password2"></td>			</tr>			<tr>				<td colspan="2" align="center"><input type="submit" value="注册">					<input type="reset" value="重填"></td>				<td></td>			</tr>		</table>	</form>    </body></html>

登录后复制

registerProc.php Post处理代码

<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head>    <body>	    <?php	    require_once 'db.php';	    $username = $_POST['username'];	    $password = $_POST['password'];	    $password2 = $_POST['password2'];	  	    $registdate = date("Y-m-d H:i:s");	    $sql = "INSERT INTO users (USERNAME,PASSWORD,REGISTDATE) values (?,?,?)";	    $sth = $conn->prepare($sql);		$sth->execute(array($username,$password,$registdate));		if($sth->rowCount())		{		   echo "insert success";		}		 else {		   echo "insert error";		 }		$conn = null;	    ?>	    注册成功，请<a href="login.php">登录</a>或继续<a href="register.php">注册</a>    </body></html>

登录后复制

db.php 连接数据库代码

<?php	$url = 'localhost';	$dbname = 'bbs';	$dsn = "mysql:host=$url;dbname=$dbname";	$dbusername = 'root';	$dbpasswd = 'root';	try{	$conn = new PDO($dsn, $dbusername, $dbpasswd);	$conn->query("set names utf8");	}catch(PDOException $e){	die("mysql connected error: ".$e->getMessage());	}?>

登录后复制

是PDO写错了吗？我找了好久都没发现在哪出错。我用的数据库是MySQL server 5.6版本的，PHP5.3