/PHP/Displaying all table names in php from MySQL database

Displaying all table names in php from MySQL database

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "dbms";

$conn = new mysqli($servername, $username, $password, $dbname);
$sql = "show tables LIKE '%student%'";

$result = mysqli_query($conn, $sql); // run the query and assign the result to $result
while($table = mysqli_fetch_array($result)) { // go through each row that was returned in $result
    echo($table[0] . "<BR>");    // print the table that was returned on that row.

}

Similar codes

1 vote101 views1 answer
Phpoffice/phpspreadsheet[1.1.0, ..., 1.15.0] require ext-gd * -> it is missing from your system. Install or enable PHP's gd extension
PHP
2 votes105 views1 answer
Php memory_limit cli
PHP
0 vote113 views2 answers
Drupal 8 add message
PHP
9 votes126 views6 answers
Php cors
PHP
0 vote104 views1 answer
How to update a table based on three columns laravel
PHP
2 votes134 views2 answers
Disable Bitnami Banner Wordpress
PHP
1 vote111 views5 answers
Eloquent batch insert
PHP
1 vote104 views1 answer
Laravel start que listener
PHP
0 vote125 views1 answer
Php number format without rounding
PHP
3 votes140 views2 answers
Laravel validation check value should be one of in array
PHP Laravel