/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 votes149 views3 answers
How to get parameter from url in laravel blade
PHP Laravel
7 votes172 views2 answers
Transaction commit rollback in laravel
PHP
0 vote135 views1 answer
Php mail in localhost wamp
PHP
8 votes166 views4 answers
Laravel get all session data
PHP Laravel
1 vote158 views1 answer
Wordpress is_archive
PHP Wordpress
0 vote133 views1 answer
Wp query meta in array
PHP
0 vote143 views2 answers
How to use a session in blade
PHP
49 votes143 views6 answers
Laravel clear all cache
PHP
8 votes134 views6 answers
Fatal error: Allowed memory size of 1610612736 bytes exhausted
PHP
0 vote153 views1 answer
Laravel - Comparison betweeon two column values - whereColumn
PHP