PHP MySQL method to count the number of records in each table in the library and arrange them in descending order, number of mysql records_PHP tutorial

How PHP MySQL counts the number of records in each table in the library and arranges them in descending order, the number of mysql records

The example in this article describes how PHP MySQL counts each table in the library The number of records in a table and sorted in descending order. Share it with everyone for your reference, the details are as follows:

This is a simple code that can count the number of records in each table in the database and arrange them in descending order

$host = '127.0.0.1';
$port = 3306;
$dbname = 'test';
$username = 'root';
$password = '';
function ee($p)
{
  if(PHP_SAPI == 'cli')
  {
    echo "\n";
  }else{
    echo "<pre class="brush:php;toolbar:false">";
  }
  print_r($p);
  if(PHP_SAPI == 'cli')
  {
    echo "\n";
  }else{
    echo "<pre class="brush:php;toolbar:false">";
  }
}
$dsn = "mysql:host={$host};port={$port};dbname={$dbname}";
$opts = array(PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION, PDO::ATTR_AUTOCOMMIT=>0);
try {
  $pdo = new PDO($dsn, $username, $password, $opts);
}catch(PDOException $e){
  echo $e->getMessage();
}
//有查询结果
function query($sql)
{
  global $pdo;
  $stmt = $pdo->query($sql);
  $data = $stmt->fetchAll(Pdo::FETCH_BOTH);
  return $data;
}
//无查询结果
function execute($sql)
{
  global $pdo;
  $affect_rows = $pdo->query($sql);
  return $affect_rows;//影响条数
}
$tables = query("show tables");
$sort_data = array();
foreach($tables as $table)
{
  //表记录条数
  $count_sql = "select count(*) as num from {$table[0]}";
  $stmt = $pdo->query($count_sql);
  $info = $stmt->fetch(Pdo::FETCH_BOTH);
  $pad_table = str_pad($table[0], 25, ' ');
  $sort_data[] = array('table'=>$pad_table, 'num'=>$info['num']);
  $sort_index[] = $info['num'];
}
array_multisort($sort_index, SORT_DESC, $sort_data);
foreach($sort_data as $val)
{
  $row_str = <<<eof
 {$val['table']} [{$val['num']}]
eof;
 ee($row_str);
}

Readers who are interested in more PHP-related content can check out the special topics of this site: "Introduction Tutorial on PHP MySQL Database Operation", "Summary of Common PHP Database Operation Skills", "Summary of PHP Database Operation Skills Based on PDO" and "PHP Basics" Grammar introductory tutorial》

I hope this article will be helpful to everyone in PHP programming.

Articles you may be interested in:

• PHP uses redis to implement statistical caching mysql pressure
• PHP Mysql jQuery China map area data statistics example explanation
• PHP Mysql jQuery file download count statistics example explanation
• The PHP spider statistics plug-in can be used as long as there is mysql
• php mysql implementation of database random rearrangement example
• Executed in PHP Sorting and sorting in MySQL
• PHP MYSQL implements two major functions of login and fuzzy query
• PHP’s mysql class implemented based on singleton mode
• Comparative analysis of PHP database connection mysql and mysqli
• PHP encapsulated connection Mysql class and usage analysis