无法在PHP上从MYSQL提供数据


Unable to supply data from MYSQL on PHP

好的,所以我在显示MYSQL数据库中的文本时遇到问题。这是我用来显示的文件

<?php
require('db_Connect.php');
$sql = "SELECT * FROM Cust_Details";
$result = mysqli_query($con,$sql)or die(mysqli_error());
echo "<table>";
echo "<tr><td>Date</td><td>Comment</td><td>Amount</td></tr>";
while($row = mysqli_fetch_array($result)) {
    $date = $row['Name'];
    echo "<tr><td style='width: 200px;'>".$date."</td></tr>";
} 
echo "</table>";
mysqli_close($con);
?>  

db_Connect.php文件

<?php
$con=mysqli_connect("MY DB HOST","MY DB USERNAME","MY DB PASS","MY DB NAME");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_close($con);
?> 

这是我的PHPMyAdmin屏幕截图的链接

http://postimg.org/image/afwlvb6gj/

正如Michael所指出的,您已经在db_Connect.php中关闭了连接。删除包含mysqli_close($con);的行,使其看起来如下所示:

<?php
$con=mysqli_connect("MY DB HOST","MY DB USERNAME","MY DB PASS","MY DB NAME");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}