今天在写一个小小的php验证页面,代码如下:
<?php
// 接受表单提交值
$username = $_POST["username"];
$password = $_POST["password"];
// 连接服务器
$dbhost = 'localhost:3306';
// mysql服务器主机地址
$dbuser = 'root';
// mysql用户名
$dbpass = '123';
// mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn ){ die('Could not connect: ' . mysqli_error());
}
//选择test数据库
$selected_table = "test";
if(mysqli_select_db($conn, $selected_table)){
$sql = "select * from user";
$return_value = mysqli_query($conn, $sql);
while($row = mysqli_fetch_array($return_value, MYSQLI_ASSOC)){
if(($username == $row["UserName"]) && ($password==$row["Pass"])){
echo "验证通过!正在为你跳转,请稍候……";
echo "<script>location.href='/go.html?url=welcome.php';</script>";
}else{
echo "验证失败!";
}}
}else{
echo '表格选择失败!';
}mysqli_close($conn); ?>
<?php
// 接受表单提交值
$us