php把两个数组合并 进行分页,php合并2个数组,并且分页,接口的方式请求数据(关键代码片段)...

$a_sql = "    SELECT sr.*,sr.apply_user AS username,s.space_name,sc.NAME AS client_name

FROM space_register AS sr

INNER JOIN SPACE AS s ON s.ID = sr.space_id

INNER JOIN space_client AS sc ON sc.ID = s.master_client_id

WHERE sr.STATUS != '-1'  " . $sql_where . "

AND begin_date < '" . date("Y-m-d", time()) . "'

ORDER BY    begin_date ASC ";

$a_posts = $pdo->query($a_sql);

$b_sql = "    SELECT sr.*, sr.apply_user AS username,s.space_name,sc.NAME AS client_name

FROM space_register AS sr

INNER JOIN SPACE AS s ON s.ID = sr.space_id

INNER JOIN space_client AS sc ON sc.ID = s.master_client_id

WHERE sr.STATUS != '-1'  " . $sql_where . "

AND begin_date >= '" . date("Y-m-d", time()) . "'

ORDER BY  begin_date ASC ";

$b_posts = $pdo->query($b_sql);

$posts = array_merge($b_posts, $a_posts);

//上面的是2个sql查出来的数组  合并成一个 就是期望的结果集

$start = ($page - 1) * $limit; //算出当前页面要从第几个开始输出

$limit_s  = $start  + $limit;  // 算出当前页面到第几个结束输出

$res_array = [];

//取出数组里从开始到结束的20个数据到页面就是当前页要显示的数据了

for ($i = $start; $i < $limit_s; $i++) {

if (!empty($posts[$i])) {

array_push($res_array, $posts[$i]);

}

}