Displaying all table names from MySQL database using php

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "drupal8";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
 
$sql = "SHOW TABLES FROM $dbname"; 

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

while ($row = $result->fetch_row()) { 
  print '<pre>';
  print $row[0];
  print '</pre>';
}
?>