确保你的PHP服务器正在运行,并且PHP代码位于相应的文件夹中。如果php不在那里,我遇到了同样的问题。我也建议把你的HTML放在同一个文件夹中,以防止测试时出现交叉错误。
如果这不是问题,请确保每个SQL调用在php中都是正确的,并且您正在使用当前的php标准......与html,css和Javascript不同,Php快速更改,因此某些函数可能会被弃用。
另外,我注意到你可能没有正确收集你的变量,这也会导致这个错误。如果您通过表单发送变量,则需要采用适当的格式,并根据您的偏好通过POST或GET发送。举例来说,如果我有一个登录页面的迷宫游戏:
HTML
Username
Password
Sign Up
Login
的JavaScript
function myLogin(username, password){
var datasend=("user="+username+"&pwd="+password);
$.ajax({
url: 'makeUserEntry.php',
type: 'POST',
data: datasend,
success: function(response, status) {
if(response=="Username or Password did not match"){
alert("Username or Password did not match");
}
if(response=="Connection Failure"){
alert("Connection Failure");
}
else{
localStorage.userid = response;
window.location.href = "./maze.html"
}
},
error: function(xhr, desc, err) {
console.log(xhr);
console.log("Details: " + desc + "\nError:" + err);
var response = xhr.responseText;
console.log(response);
var statusMessage = xhr.status + ' ' + xhr.statusText;
var message = 'Query failed, php script returned this status: ';
var message = message + statusMessage + ' response: ' + response;
alert(message);
}
}); // end ajax call
}
PHP
$MazeUser=$_POST['user'];
$MazePass=$_POST['pwd'];
//Connect to DB
$servername="127.0.0.1";
$username="root";
$password="password";
$dbname="infinitymaze";
//Create Connection
$conn = new MySQLi($servername, $username, $password, $dbname);
//Check connetion
if ($conn->connect_error){
die("Connection Failed: " . $conn->connect_error);
echo json_encode("Connection Failure");
}
$verifyUPmatchSQL=("SELECT * FROM mazeusers WHERE username LIKE '$MazeUser' and password LIKE '$MazePass'");
$result = $conn->query($verifyUPmatchSQL);
$num_rows = $result->num_rows;
if($num_rows>0){
$userIDSQL =("SELECT mazeuserid FROM mazeusers WHERE username LIKE '$MazeUser' and password LIKE '$MazePass'");
$userID = $conn->query($userIDSQL);
echo json_encode($userID);
}
else{
echo json_encode("Username or Password did not match");
}
$conn->close();
?>
如果您包含代码的其他部分(如html和JavaScript),这将有所帮助,因为我不必像这样给自己的例子。不过,我希望这些指针能够帮助!