Php不执行mysqli的query方法,PHP mysqli_query将不会执行

我正在尝试编写我的第一个基本

PHP RESTful API – 我设法使用MAMP在本地计算机上运行它.但是当我上传到托管服务器时,它不想工作.

下面的代码 – 我在那里添加了一些ECHO,以确保一切顺利.在$result = mysqli_query之前,似乎我们都很好.

//header('Content-type:application/json');

// Connect to db

$con = mysqli_connect("HOSTNAME","USER","PASSWORD","DATABASE");

echo "Database: ";

// Check connection

if ($con->connect_error) {

die("Connection failed: " . $con->connect_error);

}

echo "Connected successfully";

echo "
";

// Get value from url

$bid = $_GET['bid'];

echo "BID: ";

echo $bid;

echo "
";

// Define Query

$sql = "SELECT id, bandname, members, bio, songlist FROM bands WHERE id='$bid'";

echo "SQL Query: ";

echo $sql;

echo "
";

// Run Query

$result = mysqli_query($con, $sql);

echo "Result: ";

print_r($result);

echo "
";

// Put Query result into array

$result_array = mysqli_fetch_array($result, MYSQLI_ASSOC);

echo "Result Array: ";

print_r($result_array);

echo "
";

// Encode array as JSON and output

echo "JSON: ";

echo json_encode($result_array);

?>

Database: Connected successfully

BID: 1

SQL Query: SELECT id, bandname, members, bio, songlist FROM bands WHERE id='1'

Result:

Result Array:

JSON: null

当我手动运行查询SELECT id,bandname,members,bio,songlist FROM band WHERE id =’1’在数据库(PHPmyadmin)中,它工作正常,我得到1行返回正确的值.

手动db查询结果：

非常感激任何的帮助！！

*****编辑*****

好吧,我想我发现了这个问题……我的“成功连接”没有正确写入,并且总是回来看起来很好.它看起来像修复后,我有数据库连接问题.

我要去查找数据库连接设置并尝试修复它.

感谢你的帮助！