PHP Indonesia - Facebook | PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ | |
 | Refresh your vocabulary.
Learn a new word everyday by subscribing to Word of the Day. A great tool if you're studying for the GRE, GMAT or LSAT, or simply want to enhance your lexicon.  | From our sponsors | | |
asalam mualaikum.. nanya lagi donk gan ane mau bik... Oct 10th 2013, 07:44, by Fadhilah Rachman | asalam mualaikum.. nanya lagi donk gan ane mau bikin pagination gan, nah itu pake database lagi gak ya? soalnya datanya bisa ribuan bahkan lebih gan.. kalo ada cara yg lebih mudah dan simple kasih tau ane yaa gan, makasih sebelumnya... :D |
| | donlot aja jquery pagination.. biar tinggal pasang :D |
| | pagination g ada urusan ama DB. dia cuma nampilin sesuatu per page dengan batas tertentu. |
| | wa'alaikumsalam.. pagination sederhana bukannya maenin LIMIT di query?
pertama ngitung jumlah record: records = SELECT COUNT(*) FROM anu WHERE anu
trus ngitung jml maksimal page sesuai jml record yg mau ditampilkan perhalaman: limit = 10 pages = ceil(records / limit)
trus ngitung offset sesuai page yg dimau: page = $_GET['page'] offset = (page - 1) * limit
baru pagination: data = SELECT * FROM anu WHERE anu LIMIT offset, limit
itu semua diproses di server bukan di client/browser (kaya plugin jquery). kl datanya dikit mungkin lebih asik kl pake jquery tp kl datanya jutaan record, belom pernah nyoba tp tebakan mah bs bengong browsernya nerima data sekian banyak. --------------- ato jangan2 bukan itu yg dimaksud? | | |
|
Tidak ada komentar:
Posting Komentar