// Method 1:
// Orderby + $ this-> DB-> get_where
$ This-> DB-> orderby ("Dateline", "DESC ");
$ This-> DB-> limit (5000 );
$ Dateline = 1282000000; // 2010.08.16
$ Query = $ this-> DB-> get_where ('pre _ forum_thread ', array ('dateline>' => $ Dateline ));
// Use like this:
// Foreach ($ query-> result_array () as $ row ):
// $ Row-> authorid or $ row ['authorid']
Return $ query;
// Method 2:
// $ This-> DB-> query, which is set to $ this-> DB-> orderby ("Dateline", "DESC"); invalid
$ SQL = "select * From bbs_threads where Dateline>? ";
Return $ this-> DB-> query ($ SQL, array (1285224679 ));
// Use like this:
// Foreach ($ query-> result_array () as $ row)
//{
// Echo $ row ['dateline '];
// Echo "<br> ";
//}
Method 3:
In the model:
$ This-> DB-> limit ($ per_nums, $ start_position );
$ Query = $ this-> DB-> get ($ tablename );
$ DATA = $ query-> result ();
$ Data2 ['total _ nums'] = $ this-> DB-> count_all ($ tablename );
Control:
$ Page_num = '2'; // data on each page
$ This-> Load
-> Model ('fenmodel ');
$ DATA = $ this-> fenmodel
-> Page ('bbs _ Threads', $ page_num, $ this-> URI
-> Segment (3 ));
$ Total_nums = $ data ['total _ nums']; // obtain the total number of pages in the database.
$ Data ['query'] = $ data [0]; // put the query result in $ data ['query ']
View:
<? PHP
Foreach ($ query as $ row ):
Echo ($ row-> author );
Echo ($ row-> subject );
Echo ("<br> ");
// Var_dump ($ row );
Endforeach
;