TP5 对多个表进行模糊查询
同时对三个表进行模糊查询,字段必须相同,顺序也要相同
$limit = CommonConst::API_LIMIT;
$page = Request::post('page', 1);
$offset = ($page - 1) * $limit;
$sql = sprintf("SELECT * FROM (SELECT paper_id as id,title,orderby,cover,price,'paper' as type FROM table1 UNION SELECT id,t
原创
2020-05-28 14:34:27 ·
1329 阅读 ·
0 评论