php mysql gets all table names of the specified database_PHP tutorial

php tutorial mysql tutorial get all table names of specified database tutorial
If you want to display the table name of a specified database in MySQL, the method is very simple. MySQL provides a show tables command, which returns a data. Let’s take a look at the detailed example I made. It is fully usable after testing
*/

$cn = mysql_connect('localhost','root','root');
mysql_select_db('test',$cn);
print_r(get_tables());

/*Output results

array
(
[0] => abc
[1] => cn_user
[2] => test1
)
*/

function get_tables() //Get all table names
{
$tables=array();
$r=fetch_all("show tables");
foreach($r as $v)
{
foreach($v as $v_)
{
$tables[]=$v_;
}
}
return $tables;
}

function fetch_all($sql)
{
$rs=mysql_query($sql);
$result=array();
while($rows=mysql_fetch_array($rs,mysql_assoc))
{
$result[]=$rows;
}

return $result;

}

//When reprinting original tutorials on this site, please indicate that the source is http://www.bKjia.c0m. Keep the connection address, otherwise you will be investigated!
?>

http://www.bkjia.com/PHPjc/630783.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630783.htmlTechArticlephp tutorial mysql tutorial getting all table names of the specified database tutorial If you want to display the table name of a specified database in mysql, the method is very easy Simple, mysql provides a show tables command, which returns...