网站上做一个注册板块 :
HTML:
<!DOCTYPE html>
<html>
<body>
<form action="welcome.php" method="POST">
<table border="1" width="600">
<tr>
<td>*用户名:</td>
<td><input type="text" name="username" /> </td>
</tr>
<tr>
<td>*密码:</td>
<td><input type="password" name="password" /> </td>
</tr>
<tr>
<td>*确认密码:</td>
<td><input type="password" name="repass" /> </td>
</tr>
<tr>
<td>*Email:</td>
<td><input type="text" name="email" /> </td>
</tr>
<tr>
<td><input type="submit" value="提交注册信息" /></td>
<td></td>
</tr>
</table>
</form>
</body>
</html>
如果密码和确认密码信息一致,将用户名和密码保存到数据库中:
<?php
//先和mysql服务器连接上
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = ''; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('连接失败: ' . mysqli_error($conn));
}
echo '连接成功<br />';
// 设置编码,防止中文乱码
mysqli_query($conn , "set names utf8");
//具体功能实现
$a = $_POST['username'];
$b = $_POST['password'];
$c = $_POST['repass'];
if($b==$c)
{
//向数据表nume中的字段uname和upassWord中插入要插入的用户名和密码;
$sql = "INSERT INTO nume".
"(uname,upassword)".
"VALUES".
"('$a','$b')";
echo $sql;
}
else
{
echo 'error';
}
mysqli_select_db( $conn, 'zhuche' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
die('无法插入数据: ' . mysqli_error($conn));
}
echo "数据插入成功\n";
mysqli_close($conn);
?>