php - 为什么我无法运行此查询？

Question

这个问题已经有答案了:

Can I mix MySQL APIs in PHP? (4 个回答)

已关闭 7 年前。

我尝试在 php 中运行此代码，但没有打印任何内容。

我的数据库不为空。

<?php
$dbname = "mytest";
$servername = "***";
$username = "mohsen";
$passwords = "****";
// Create connection
$conn = new mysqli($servername, $username, $passwords, $dbname);
// Check connection
if ($conn->connect_error) {
 die("Connection failed: " . $conn->connect_error);
}
$User=$_POST['username'];
$sql="SELECT * FROM Money WHERE Debtor='$User' OR Creditor='$User'  ";
$result = $conn->query($sql);

//
while($field=mysql_fetch_assoc($result))
{

print $field["Debtor"]."|";
print $field["Creditor"]."|";
print $field["Cost"]."|";
print $field["Status"]."|"."\n";

}
$conn->close();
?> 

例如:我的数据库中有该用户的记录用户=莫森链接:

http://test.kholaseketab.ir/Update.php

Answer 1

您正在混合面向对象和过程式查询。

<?php
$dbname = "mytest";
$servername = "***";
$username = "mohsen";
$passwords = "****";
// Create connection
$conn = new mysqli($servername, $username, $passwords, $dbname);
// Check connection
if ($conn->connect_error) {
 die("Connection failed: " . $conn->connect_error);
}
$User=$_POST['username'];
$sql="SELECT * FROM Money WHERE Debtor='$User' OR Creditor='$User'  ";
$result = $conn->query($sql);

//
while($field = $result->fetch_object())
{

print $field->Debtor."|";
print $field->Creditor."|";
print $field->Cost."|";
print $field->Status."|"."\n";

}
$conn->close();
?>