Codeigniter - Please suggest me that how to add pagination in this search engine -


--

-- database: ci-intro

create database ci-intro default character set utf8 collate utf8_general_ci; use ci-intro;

--

-- table structure table posts

create table if not exists posts ( id int(11) unsigned not null auto_increment, title varchar(100) default null, body text, created datetime default null, modified datetime default null, primary key (id) ) engine=innodb default charset=utf8 auto_increment=6 ;

--

-- dumping data table posts

insert posts (id, title, body, created, modified) values (1, 'another day still looking', 'my lion ran off', '2013-04-02 08:20:20', '2013-04-03 12:43:49'), (2, 'a day', 'the lion in 1 piece.', '2013-04-02 08:20:44', '2013-04-02 08:20:44'), (3, 'thank god', 'everything belongs father', '2013-04-02 08:21:03', '2013-04-02 08:21:03'), (4, 'at seaside', 'we went down sea side, started raining!', '2013-04-02 08:21:35', '2013-04-03 19:28:48'), (5, 'boring posts', 'the events diary not interesting', '2013-04-02 08:21:55', '2013-04-03 19:35:25');

application\controllers\posts.php

function search() {     $data['title'] = "blogging";     $data['heading'] = "bloging";      $this->load->view('view_search', $data); }

application\views\view_search.php

    <?php echo form_fieldset('<b>search post!</b>');?>      <?php echo form_open('posts/execute_search'); ?>     <table width="100%" border="0" align="center" cellpadding="0" cellspacing="5" style="border:dashed"  bgcolor="#ffcc99">         <tr>             <td align="right">                 <?php echo form_label('search: enter keyword, title, content '); ?>             </td>             <td>                  <?php  echo form_input(array('name'=>'search')); ?>             </td>         </tr>         <tr>             <td align="right" valign="top"><?php echo nbs(1); ?></td>             <td valign="top" class="style1"><?php echo form_submit('search_submit','submit'); ?></td>         </tr>      </table>     <?php echo form_close(); ?>     <?php echo form_fieldset_close(); ?>

application\controllers\posts.php

public function execute_search($search_term) {     $data['title'] = "blogging";     $data['heading'] = "bloging";       $search_term = $_post['search'];      $rs = $this->db->like('title', trim($search_term))             ->or_like('body', trim($search_term))             ->get('posts');     $total = $rs->num_rows();      $data['results'] = $rs->result();      $this->load->view("view_index", $data);  }

to use pagination.. need use pagination class library of codeigniter ... load library

 $this->load->library('pagination');

and call function in controller

 $config['base_url'] = 'http://example.com/index.php/test/page/';  $config['total_rows'] = 200;  $config['per_page'] = 20;    $this->pagination->initialize($config);

and print create_lnks want pagination stay...(view)..

  echo $this->pagination->create_links();

you can go through docs here... read more pagination class.. , customization


Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

wpf - PdfWriter.GetInstance throws System.NullReferenceException -

i'm trying create pdf document using itextsharp 5.3.4 using following document document = new document(); filestream stm = new filestream(filename, filemode.create); pdfwriter writer = pdfwriter.getinstance(document, stm); i'm getting system.nullreferenceexception following stack trace: system.nullreferenceexception occurred hresult=-2147467261 message=la référence d'objet n'est pas définie à une instance d'un objet. source=itextsharp stacktrace: à itextsharp.text.version.getinstance() innerexception: i've verified neither document nor stm null, , if select "continue" in vs12 document created - exception thrown. updated itextsharp 5.4.0 , it's still occurring. can't find information on anywhere - got ideas? make sure not catching exceptions. nullreferenceexception can 1 caught , handled inside itextsharp, don't care it. fact can continue supports theory. change following setting verify: debug -> exceptions ...
Read more