Php multi-table query and paging implementation

{Code...} uses tp framework SQL to display 5 pieces of data by page, for example, by page. how can this problem be solved?

Public function my_join_activity () {header ('content-type: text/html; charset = utf-8 '); $ Model = M (); $ unionid = session ('unionid '); if (! $ Unionid) {$ inde = A ('index'); $ inde-> login ();} // use native SQL for multi-table queries note the and statement of the where Condition $ list = $ Model-> query ("select * from activity, apply where apply. ac_id = activity. ac_id and apply. unionid = '{$ unionid} 'Order by ap_id desc "); $ this-> assign ('list', $ list); $ this-> display ();}

In tp framework SQL, how does one display 5 pieces of data by page?

Reply content:

Public function my_join_activity () {header ('content-type: text/html; charset = utf-8 '); $ Model = M (); $ unionid = session ('unionid '); if (! $ Unionid) {$ inde = A ('index'); $ inde-> login ();} // use native SQL for multi-table queries note the and statement of the where Condition $ list = $ Model-> query ("select * from activity, apply where apply. ac_id = activity. ac_id and apply. unionid = '{$ unionid} 'Order by ap_id desc "); $ this-> assign ('list', $ list); $ this-> display ();}

In tp framework SQL, how does one display 5 pieces of data by page?

Use count and limit

$ User = M ('user'); // instantiate the User object $ count = $ User-> where ('status = 1')-> count (); // query the total number of records meeting the requirements $ Page = new \ Think \ Page ($ count, 25 ); // The total number of incoming records and the number of records displayed on each Page (25) $ show = $ Page-> show (); // Display output by Page // query paging data. Note that the parameters of the limit method must use the attribute $ list = $ User-> where ('status = 1') of the Page class ') -> order ('create _ time')-> limit ($ Page-> firstRow. ','. $ Page-> listRows)-> select (); $ this-> assign ('list', $ list); // assign a dataset $ this-> assign ('page ', $ show); // value-assigned paging output $ this-> display (); // output Template