Output MySQL Database Variables to a Table

>> Using PHP to output all your MySQL database variables

RESOURCE ADDED ON THURSDAY 13 JULY 2006, 16:44:28

Category: PHP Code

Language(s): PHP, MySQL

Description: Using PHP to output all your MySQL database variables

The code is listed below; click on it to download the code as a text file.

<table>
    <tr>
        <td>Variable Name</td>
        <td>Value</td>
      </tr>
<?php

    $result = mysql_query( "SHOW VARIABLES" );

    while( $row = mysql_fetch_array( $result ) ) {

        extract( $row );

        if( !empty( $Value ) ) {

            echo '<tr>';
            echo "<td>$Variable_name</td><td>$Value</td>";
            echo '</tr>';

        }

    }

?>
</table>

This code has been downloaded 276 time(s) and viewed 5657 time(s).

Back to Resources
Back to Code
Back to PHP Code

Credits

This resource was written by Tim Bennett Bsc (Hons). Tim Bennett has a First Class Degree in Multimedia Systems Computing from Leeds Metropolitan University. He works as a freelance multimedia developer under the company name Texelate creating free and commissioned high-quality multimedia solutions. Find out more by visiting the portfolio section and viewing his blog. If you'd like to request a resource get in touch!