php - 多表分页

Question

如果你有以下功能:如何为每个表添加 LIMIT 序列？

function find($page=2,$num_of_page=30){
   $query_1 = "SELECT COUNT(*) FROM table_1";
   $query_2 = "SELECT COUNT(*) FROM table_2";
   $query_3 = "SELECT COUNT(*) FROM table_3";

   .
   .
   .
   /*
   $total_count   == 100;
   $table_1_count ==  33;
   $table_2_count ==  10;
   $table_3_count ==  57; 
   */

   $offset = $page -1 * $num_of_page;
   $limit  = $num_of_page;
   .
   .

}

如果 $page == 2 和 $num_of_page ==30；你应该执行

SELECT * FROM table_1 LIMIT 30,3
SELECT * FROM table_2 LIMIT 0,10
SELECT * FROM table_3 LIMIT 0,17

请原谅我丑陋的英文

Answer 1

如果这些表都具有相同的结构，您可以执行 SELECT * FROM table1 UNION ALL SELECT * FROM table2 UNION ALL SELECT * FROM table3 然后使用单个 LIMIT 用于查询。