/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

6 votes132 views1 answer
A2dismod
PHP
0 vote139 views1 answer
Laravel simplexmlelement not found
PHP Laravel
0 vote100 views1 answer
Replicating claims as headers is deprecated and will removed from v4.0. Please manually set the header if you need it replicated.",
PHP
14 votes107 views6 answers
How to install laravel
PHP
4 votes116 views3 answers
Laravel cmd command to watch logs
PHP Laravel
1 vote95 views1 answer
Spatie media library retrieve media from url
PHP
0 vote53 views2 answers
Php get previous url
PHP
1 vote126 views2 answers
Use multiple database in laravel
PHP Laravel
0 vote98 views1 answer
Laravelstart project
PHP
0 vote131 views1 answer
Woocommerce php products list div
PHP