Use MySQL and mysqli to get all the tables in MySQL's database and library

Source: Internet
Author: User

function: Use MySQL and mysqli two ways to connect to the database to get all the tables in all databases and libraries on the MySQL server.

Environment: Use separate installation of Apache MySQL PHP built Environment

Operating system is: Windows 10

The code is as follows:

<?php
/**
* mysqli op mysql Demo
*/
/**
* Common functions
*/

/**
* function: List all tables of a database
* @param$dbname
* @param$con
*/
functionList_tables($dbname,$con)
   {
mysql_select_db ($dbname,$con) or die("failed to select Database!");
       $res= mysql_query ("SHOW TABLES");

       $tables= Array();

        while($row= Mysql_fetch_array ($res))
       {
           Echo$row[0] .' <br> ';
       }
Mysql_free_result ($res);


//return $tables;

   }

/**
* UseMSYQLmethod to get the names of all libraries
*/
$mysqlCon= mysql_connect (' localhost ',' Root ',' + ');
$set= mysql_query (' SHOW DATABASES; ');
$dbs= Array();
while($db= Mysql_fetch_row ($set))
   $dbs[] = $db[0];

//var_dump ($dbs);
Echo' this isMySQLresults of the operation output:;
//print_r ($dbs);

/**
* This is used to display the database name
*/
foreach($dbs as$key=$value){
  Echo' <b> '.$key. "=". $value.' </b><br> ';
   List_tables ($value,$mysqlCon);

}


Echo' this isMsyqliresults of the operation output:;
$mysqliCon= Mysqli_connect (' localhost ',' Root ',' + ');
$result= Mysqli_query ($mysqliCon,' show databases ');
$dbs 2=Array();
while($db=mysqli_fetch_row ($result))
       $dbs 2[] = $db[0];
Print_r ($dbs 2);

The results are as follows:

This is the result of the MySQL operation output:

0=>information_schema
Character_sets
Collations
Collation_character_set_applicability
COLUMNS
Column_privileges
ENGINES
EVENTS
FILES
Global_status
Global_variables
Key_column_usage
PARAMETERS
Partitions
PLUGINS
Processlist
PROFILING
Referential_constraints
ROUTINES
Schemata
Schema_privileges
Session_status
Session_variables
STATISTICS
TABLES
Tablespaces
Table_constraints
Table_privileges
TRIGGERS
User_privileges
Views
Innodb_buffer_page
Innodb_trx
Innodb_buffer_pool_stats
Innodb_lock_waits
Innodb_cmpmem
innodb_cmp
Innodb_locks
Innodb_cmpmem_reset
Innodb_cmp_reset
Innodb_buffer_page_lru
1=>access_control
Collection
Collection2permission
Permission
Signup
User
User2collection
2=>db_bcty365
Tb_bb
Tb_bbqb
Tb_bbs
Tb_bccd
Tb_bccdjj
Tb_city
Tb_cjwt
Tb_dd
Tb_leaveword
Tb_reply
Tb_sjxz
Tb_soft
Tb_tell
Tb_type
Tb_type_big
Tb_type_small
Tb_user
Tb_xlh
3=>db_nethard
Tb_member
Tb_upfile
Tb_uptype
4=>db_reglog
Tb_member
5=>mysql
Columns_priv
Db
Event
Func
General_log
Help_category
Help_keyword
Help_relation
Help_topic
Host
Ndb_binlog_index
Plugin
Proc
Procs_priv
Proxies_priv
Servers
Slow_log
Tables_priv
Time_zone
Time_zone_leap_second
Time_zone_name
Time_zone_transition
Time_zone_transition_type
User
6=>performance_schema
Cond_instances
Events_waits_current
Events_waits_history
Events_waits_history_long
Events_waits_summary_by_instance
Events_waits_summary_by_thread_by_event_name
Events_waits_summary_global_by_event_name
File_instances
File_summary_by_event_name
File_summary_by_instance
Mutex_instances
Performance_timers
Rwlock_instances
Setup_consumers
Setup_instruments
Setup_timers
Threads
7=>php_study
8=>phpbook
AddressBook
9=>regi
Member
10=>test
11=>world
City
Country
Countrylanguage

This is the result of the msyqli operation output:

Array ([0] = information_schema [1] = Access_control [2] = db_bcty365 [3] = = Db_nethard [4] = Db_reglog [5] = = MySQL [6] = Performance_schema [7] = php_study [8] = = Phpbook [9] => ; Regi [Ten] = Test [one] = world)


Use MySQL and mysqli to get all the tables in MySQL's database and library

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.