PHP简单留言板后台

query("set names utf8");

$sql = "SELECT * FROM User  WHERE name = $username";

$result = $mysql->query($sql);

//查询返回的记录数

if ($result->num_rows){

while ($result2-$result2->fetch_assoc()) {

if ($result2["password"] == $password) {

echo "登陆成功";

break;

}else {

echo "密码不正确";

break;

}

}

}else{

echo "没有该用户";

}

}elseif(in_array($_REQUEST["username"],$_REQUEST)) {

$username = $_REQUEST["username"];

$password = $_REQUEST["password"];

$mysql = new mysqli("localhost","root","","message");

$mysql->query("set names utf8");

$sql = "INSERT INTO User (name,password) VALUES ('$username','$password')";

$result = $mysql->query($sql);

if ($result) {

echo "插入成功";

}else {

echo "插入失败";

}

}

?>