显示给定MySQL数据库中的所有表

I'm trying to show all tables within a given MySQL database with php. I'm very new to all this though and can't find a solution for it. Keeps giving an error 'no found file or directory'.

Anyone who can point out my mistakes here please? Much appreciated!

<?php include "../inc/dbinfo.inc"; ?>
<html>
<body>
<h2>LIST TABLES FROM DATABASE</h2>
<?php

// Create connection
$conn = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD);

// Check connection
if ($conn->connect_error) {
    die("Connection with the database failed: </br>" . $conn->connect_error);
}
echo "Connection established with the database! </br>";

// SQL to show tables

$sql = "SHOW TABLES FROM paperlessdb";
$result = mysql_query($sql);

if (!$result) {
    echo "Database error, could not list tables.
</br>";
    echo 'MySQL error: ' . mysql_error();
    exit;
}

while ($row = mysql_fetch_row($result)) {
    echo "- {$row[0]}
 </br>";
}

mysql_free_result($result);
?>

First make up your mind, either use procedural or object orientated. Not a combination of both because its confusing. To avoid that all together use instead.

Now properly connect to the database, you can select the database when connecting to it automatically:

const DB_DATABASE = 'paperlessdb';

$conn = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);

// Check connection
if ($conn->connect_error) {
    die("Connection with the database failed: </br>" . $conn->connect_error);
}

if($result = $conn->query('SHOW TABLES')){
  while($row = $conn->fetch_array($result)){
    $tables[] = $row[0];
  }
}

print_r($tables);

You are using to connect to the database but use the depreciated to query the database.

$conn = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD);

$result = mysql_query($sql);
while ($row = mysql_fetch_row($result)){}

mysql_free_result($result);

You should use mysqli_query() and mysqli_fetch_array() instead.

It'a a bit more complex but mysql is decrecated and remove as PHP 7 so no choice to jump ahead. Check out PDO ass well. I personally go for but most say is more intuitive.

It should look more something like:

$result = mysqli_query($conn,$sql);
if(!$result){
  die('MySQL error: ' . mysqli_error($conn));
}

while ($row = mysqli_fetch_row($result)) {
    echo "- {$row[0]}
 </br>";
}

Use below query,

$sql = "SELECT table_name
           FROM information_schema.tables
        WHERE table_schema = 'paperlessdb'";

We are fetching the data from information_schema db which stores the meta data about our database.