Post请求在PHP中的phpmyadmin中返回false，但返回true

Question

我一直在尝试发布订单id、扩展id。。。使用JavaScriptPOST方法，但即使SQL查询为true，它也总是返回false。演示数据：

Javascript

var order_id = "1232";
var extension_id = "12";
var email = "[e-mail]";
var dom = "www.youtube.com";

$.post(
"checkdata.php",
{
order_id: order_id,
extension_id: extension_id,
email: email,
dom:dom
},
function (data, status) {
//console.log("Data: " + JSON.parse(data) + "nStatus: " + status);
console.log(data + "status:" + status);
}
);

此数据存在于表"osmo"中。此外，我已经将所有列声明为VARCHAR。请说明我对这个问题做了什么。

PHP

if ($_SERVER['REQUEST_METHOD'] == 'POST') {


if (!empty($_POST['order_id']) && !empty($_POST['extension_id']) && !empty($_POST['email']) && !empty($_POST['dom'])) {

//store in variables
$order_id = $_POST['order_id'];
$extension_id = $_POST['extension_id'];
$email = $_POST['email'];
$dom = $_POST['dom'];
//server config
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "foroc";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

//sql query
$sql = "SELECT *
FROM ocorders
WHERE order_id='$order_id'
AND extension_id='$extension_id'
AND email='$email'
AND order_status='Complete'
AND dom='$dom'
";

$result = mysqli_query($conn, $sql);
//check if sql query is returning true or false
if (mysqli_num_rows($result) > 0) {
// output data of each row
while ($row = mysqli_fetch_assoc($result)) {
print json_encode("true");
}
} else {
print json_encode("false");
}



//close connection
$conn->close();
} 
}

Answer 1

经过这么多建议，我终于找到了我的"True"。$result=mysqli_query($conn，$sql(；

if (mysqli_num_rows($result) > 0) {
// output data of each row
while ($row = mysqli_fetch_assoc($result)) {
print json_encode("True");
}
} else {
print json_encode("False");
}

有些小错误有时会让人头疼。