<?php
/*
//取库名
$connect = mysql_connect("localhost","root","123456");
$dbs = mysql_list_dbs($connect);
$rows = mysql_num_rows($dbs);
$i = 0;
while($i<$rows)
{
$db_name[$i] = mysql_tablename($dbs , $i);
echo $db_name[$i] ."<br>";
$i++;
}
*/
//取表名
$connect = mysql_connect("localhost","root","123456");
$dbs = mysql_list_tables("nbw1",$connect);
$rows = mysql_num_rows($dbs);
$i = 0;
while($i<$rows)
{
$db_name[$i] = mysql_tablename($dbs , $i);
echo $db_name[$i] ."<br>";
$i++;
}?>
/*
//取库名
$connect = mysql_connect("localhost","root","123456");
$dbs = mysql_list_dbs($connect);
$rows = mysql_num_rows($dbs);
$i = 0;
while($i<$rows)
{
$db_name[$i] = mysql_tablename($dbs , $i);
echo $db_name[$i] ."<br>";
$i++;
}
*/
//取表名
$connect = mysql_connect("localhost","root","123456");
$dbs = mysql_list_tables("nbw1",$connect);
$rows = mysql_num_rows($dbs);
$i = 0;
while($i<$rows)
{
$db_name[$i] = mysql_tablename($dbs , $i);
echo $db_name[$i] ."<br>";
$i++;
}?>
from `dbname`