Databases en tables weergeven
Ik kan daar niks vinden over het weergeven van databases en tables.
Databases lukt me wel:
Code (php)
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
<?php
mysql_connect('localhost','admin','*****');
$sqlquery = mysql_query("SHOW DATABASES");
while ($rowdb = mysql_fetch_assoc($sqlquery)){
echo '<a href="editor.php?act=sqlmanager&currdb='.$rowdb['Database'].'">
'.$rowdb['Database'].'</a><br>';
}
?>
mysql_connect('localhost','admin','*****');
$sqlquery = mysql_query("SHOW DATABASES");
while ($rowdb = mysql_fetch_assoc($sqlquery)){
echo '<a href="editor.php?act=sqlmanager&currdb='.$rowdb['Database'].'">
'.$rowdb['Database'].'</a><br>';
}
?>
Alleen tabellen weergeven in de geselecteerde database lukt me niet.
//// EDIT ////
Al gefixed.
Code (php)
1
2
3
4
5
6
2
3
4
5
6
<?php
$tabellen = mysql_query("SHOW TABLES IN ".$_GET['currdb'],$conn)or die(mysql_error());
while($tabel = mysql_fetch_assoc($tabellen)) {
echo $tabel['Tables_in_'.$_GET['currdb']].'<br>';
}
?>
$tabellen = mysql_query("SHOW TABLES IN ".$_GET['currdb'],$conn)or die(mysql_error());
while($tabel = mysql_fetch_assoc($tabellen)) {
echo $tabel['Tables_in_'.$_GET['currdb']].'<br>';
}
?>
Gewijzigd op 01/01/1970 01:00:00 door Jelle Posthuma