Alle beschikbare mysql tabellen weergeven

SHOW TABLES

SHOW TABLES

<?php

include 'resources/plugins/connection.plugin.php';

$dbname = 'visualmast_dok99';


$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql);

while ($row = mysql_fetch_row($result)) {
    echo "Table: {$row[0]}\n";
}


?> 

<?php
 
include 'resources/plugins/connection.plugin.php';
 
$dbname = 'visualmast_dok99';
 
 
$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql);
 
while ($row = mysql_fetch_row($result)) {
    echo "Table: {$row[0]}\n";
}
 
 
?>

<?php

include 'resources/plugins/connection.plugin.php';

$dbname = 'visualmast_dok99';
$table_prefix = 'rooster_';


$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql);

while ($row = mysql_fetch_row($result)) {
    echo "Table: " . substr($row[0] , strlen($table_prefix)) . "\n";
}


?> 

<?php
 
include 'resources/plugins/connection.plugin.php';
 
$dbname = 'visualmast_dok99';
$table_prefix = 'rooster_';
 
 
$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql);
 
while ($row = mysql_fetch_row($result)) {
    echo "Table: " . substr($row[0] , strlen($table_prefix)) . "\n";
}
 
 
?>