query("set names utf8");
$sql = "SELECT * FROM User? WHERE name = $username";
$result = $mysql->query($sql);
//查詢返回的記錄數(shù)
if ($result->num_rows){
while ($result2-$result2->fetch_assoc()) {
if ($result2["password"] == $password) {
echo "登陸成功";
break;
}else {
echo "密碼不正確";
break;
}
}
}else{
echo "沒(méi)有該用戶";
}
}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 "插入失敗";
}
}
?>
