环境php 5.2.13 mysql 5.5.3
创建register.html
注册用户名
密码
创建register.php
$mysqli=mysqli_connect("localhost","root","******","test");
$name=$_POST["name"];
$password=$_POST["password"];
$hashpw=md5($password);
if ($name && $password){
$sql = "SELECT * FROM login WHERE user='$name'";
$res = mysqli_query($mysqli,$sql);
$rows=mysqli_num_rows($res);
if($rows){
echo "已有人注册此名,请重新选择名字!";
echo "返回";
exit;
}
else{
$ins = "insert into login values('$name','$hashpw')";
$result = mysqli_query($mysqli,$ins);
if($result){
echo "祝贺你,注册成功!";
echo "登入";
exit;}
}
mysqli_free_result($res);
mysqli_close($mysqli);
}
?>
创建 login.html
用户名
密码
创建login1.php
$mysqli=mysqli_connect("localhost","root","******","test");
$name=$_POST["name"];
$password=$_POST["password"];
$hashpw=md5($password);
if ($name && $password){
$sql = "SELECT * FROM login WHERE user='$name' and password='$hashpw'";
$res = mysqli_query($mysqli,$sql);
$rows=mysqli_num_rows($res);
if($rows){
header("location:index.php");
exit;
}
else{
echo "登入失败,请验证!";
}
mysqli_free_result($res);
mysqli_close($mysqli);
}
?>
通过以上代码可以知道实现简单的注册和登入测试,可以了解PHP和mysql简单的调用和交互过程。