/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

0 vote154 views1 answer
PHP (WordPress) - Increase Maximum Upload File Size
PHP Wordpress
0 vote136 views2 answers
Php create 404 error
PHP
0 vote160 views1 answer
Smtp php test
PHP
0 vote134 views1 answer
Wordpress loop over posts but exclude current post
PHP
2 votes134 views1 answer
Is php still used
PHP
2 votes184 views2 answers
Laravel validate form data unique
PHP Laravel
0 vote131 views1 answer
Phpunit assert not false
PHP
0 vote164 views1 answer
Codeigniter sms send
PHP CodeIgniter
3 votes144 views2 answers
Create variable in laravel blade
PHP
0 vote125 views6 answers
Php email
PHP