codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Show all tables from database

    15th March 2017

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
     
    $dbname="mydatabase";
    $sql = "SHOW TABLES FROM $dbname";
    $result = mysql_query($sql);
     
    while ($row = mysql_fetch_row($result)) {
        echo "<br>Found Table: {$row[0]}\n";
        $alltables[]=$row[0];
    }
    var_dump($alltables);
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN