Get MySQL tables names in PHP

Source code viewer
$schema = array();
$host = 'localhost';
$username = 'root';
$password = '';
$link = mysql_connect($host, $username, $password);
if ($link) {
  $result = mysql_query('SHOW TABLES FROM '.mysql_real_escape_string('database_name'), $link);
  while ($row = mysql_fetch_row($result)) {
      $schema[] = $row[0];
  }
  mysql_close($link);
}
print_r($schema);
Programming Language: PHP