tag:blogger.com,1999:blog-9105807667536228286.post5729446172309529036..comments2024-03-09T05:35:22.812+01:00Comments on Developer Paradize: How to use Codeigniter pagination library together with jQuery and AJAX with complete sourcecode?Anup Shakyahttp://www.blogger.com/profile/17559758035513914889noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-9105807667536228286.post-81959861987298781262017-12-18T12:11:10.459+01:002017-12-18T12:11:10.459+01:00I still prefer the old fashion pagination in codei...I still prefer the old fashion pagination in codeigniter (https://www.cloudways.com/blog/pagination-in-codeigniter/ ) without any magic JS script. Why make the process so difficult when you can do it so quickly?oliverhttps://www.blogger.com/profile/16138843829014825922noreply@blogger.comtag:blogger.com,1999:blog-9105807667536228286.post-50051697726497669702014-12-05T13:57:28.800+01:002014-12-05T13:57:28.800+01:00Hii, Can anybody comment out Pagination library fi...Hii, Can anybody comment out Pagination library file which is loaded in this code. please...HotPickshttps://www.blogger.com/profile/02775302060512537023noreply@blogger.comtag:blogger.com,1999:blog-9105807667536228286.post-69373582430957842742014-03-04T13:22:47.282+01:002014-03-04T13:22:47.282+01:00hi,
How does this works in when the content with ...hi,<br /><br />How does this works in when the content with ajax pagination is to loaded only in a part of the page which contains other content?<br /><br />MuraliMuralihttps://www.blogger.com/profile/06401188460245270763noreply@blogger.comtag:blogger.com,1999:blog-9105807667536228286.post-64247434802220255362014-02-24T09:16:34.212+01:002014-02-24T09:16:34.212+01:00Hello Javier,
I didn't get the clear pictur...Hello Javier,<br /> <br />I didn't get the clear picture of your tables structure. But I converted your query to <br />CI active record. I haven't tested it, but it should work.<br /><br /><br /> $this->db->select('adds.*, adsubcat.*, adcat.*'); <br /> $this->db->join('adsubcat', 'adds.subcatid = adsubcat.subcatid', 'left');<br /> $this->db->join('adcat', 'adcat.id = adds.catid', 'left');<br /> $this->db->where('adds.subcatid', $adsubcatID); <br />//get $adsubcatID from somewhere (from controller)<br /> $this->db->where('adds.status', 'activated');<br /> $this->db->order_by('adds.id', 'DESC');<br /> $query = $this->db->get('adds');Anup Shakyahttps://www.blogger.com/profile/17559758035513914889noreply@blogger.comtag:blogger.com,1999:blog-9105807667536228286.post-34377473259594001562014-02-23T12:51:13.290+01:002014-02-23T12:51:13.290+01:00but in this example I don´t see joins anywhere,rig...but in this example I don´t see joins anywhere,right? you mean in a different example you may have.<br />I will show you my sql query which I can not translate it using CI active records, and basicly there lies the whole issue I think.<br /><br /><br /> $sql_query = "SELECT adds.*,date_format(date,'%d/%m/%Y') as fdate,<br /> adds.id as idadd, adsubcat.name as adsubcatname,adcat.name as adcatname <br /> FROM adds LEFT JOIN (adsubcat,adcat)<br /> ON ( adds.subcatid=$this->subcatid AND adcat.id=$this->catid AND status='activated')<br /> WHERE adds.subcatid=adsubcat.id<br /> ORDER BY adds.id desc";<br /> <br /> <br /> $query = $this->db->query($sql_query);<br /> <br />thanks in advance !<br /> Fco. Javier Gargallohttps://www.blogger.com/profile/09123041875570140485noreply@blogger.comtag:blogger.com,1999:blog-9105807667536228286.post-26488780770980642292014-02-19T09:50:27.082+01:002014-02-19T09:50:27.082+01:00It depends how you are using join queries to pull ...It depends how you are using join queries to pull datas from different tables. In my case i have join four different tables, and it is working like charm.<br /><br />It must be something what is messing your query.<br /><br />Good luck. Anup Shakyahttps://www.blogger.com/profile/17559758035513914889noreply@blogger.comtag:blogger.com,1999:blog-9105807667536228286.post-49516773410697870792014-02-18T20:53:00.650+01:002014-02-18T20:53:00.650+01:00just to point out that the whole thing gets really...just to point out that the whole thing gets really tricky if you have to use a Joint sql query which pulls data from different tables, then codeigniter pagination active record queries to pull data don´t work.<br />and it messes all up ! :-(Fco. Javier Gargallohttps://www.blogger.com/profile/09123041875570140485noreply@blogger.comtag:blogger.com,1999:blog-9105807667536228286.post-62015460362530083502013-11-21T11:17:28.631+01:002013-11-21T11:17:28.631+01:00This is also worked for me –
http://yogeshpatilher...This is also worked for me –<br />http://yogeshpatilhere.blogspot.in/2013/11/codeigniter-ajax-pagination-example-code.htmlyogeshhttps://www.blogger.com/profile/16937114940709120672noreply@blogger.com