/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

7 votes299 views10 answers
Php .com
PHP
11 votes332 views5 answers
Laravel check auth
PHP
1 vote321 views1 answer
Delete record using laravel
PHP
1 vote353 views2 answers
Laravel compare date timestamp
PHP
0 vote293 views1 answer
Php read text file into array
PHP
0 vote312 views1 answer
Php redirect if not logged in
PHP
0 vote362 views1 answer
Wp change num words exerpct
PHP Wordpress
0 vote316 views1 answer
Create if not exist laravel
PHP
1 vote307 views2 answers
Php password_hash decrypt online
PHP
2 votes318 views1 answer
Php remove null bytes from string
PHP