Set Peginaation in Searching in codeigniter
<?php
if (!defined(‘BASEPATH’)) exit(‘No direct script access allowed’);
class User extends CI_Controller {
function __construct() {
// Call the Model constructor
parent::__construct();
$this->load->helper(‘url’);
$this->load->model(‘nj_user’);
$this->load->library(“session”);
$username = $this->session->userdata(‘username’);
if (empty($username)) {
redirect($this->config->base_url() . ‘login’);
}
$this->load->library(“pagination”);
}
public function index() {
redirect($this->config->base_url() . ‘user/view’);
}
//sarching
public function searchterm_handler($searchterm) {
if ($searchterm) {
$this->session->set_userdata(‘searchterm’, $searchterm);
return $searchterm;
} elseif ($this->session->userdata(‘searchterm’)) {
//print_r ($_SESSION[‘searchterm’]);exit;
$searchterm = $this->session->userdata(‘searchterm’);
return $searchterm;
} else {
$searchterm = “”;
return $searchterm;
}
}
public function searh()
{
$this->load->view(‘layout/header’);
$this->load->view(‘layout/sidebar’);
//pagination//
$searchterm = $this->searchterm_handler($_POST, TRUE);
$config = array();
$config[“base_url”] = $this->config->base_url() . “user/searh”;
$config[“total_rows”] = $this->nj_user->count_search($searchterm);
$config[“per_page”] = 3;
$config[“uri_segment”] = 3;
$choice = $config[“total_rows”] / $config[“per_page”];
$config[“num_links”] = round($choice);
//config for bootstrap pagination class integration
$config[‘full_tag_open’] = ‘‘;
$config[‘full_tag_close’] = ‘‘;
$config[‘first_link’] = false;
$config[‘last_link’] = false;
$config[‘first_tag_open’] = ‘‘;
$config[‘first_tag_close’] = ‘‘;
$config[‘prev_link’] = ‘«’;
$config[‘prev_tag_open’] = ‘‘;
$config[‘prev_tag_close’] = ‘‘;
$config[‘next_link’] = ‘»’;
$config[‘next_tag_open’] = ‘‘;
$config[‘next_tag_close’] = ‘‘;
$config[‘last_tag_open’] = ‘‘;
$config[‘last_tag_close’] = ‘‘;
$config[‘cur_tag_open’] = ‘‘;
$config[‘cur_tag_close’] = ‘‘;
$config[‘num_tag_open’] = ‘‘;
$config[‘num_tag_close’] = ‘‘;
$this->pagination->initialize($config);
$page = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0;
//searching… //
$data[‘result’]= $this->nj_user->get_search($searchterm, $page, $config[“per_page”]);
//end searching…//
$data[“link”] = $this->pagination->create_links();
$data[‘hms’] = $page;
$this->load->view(‘user/userview’, $data);
$this->load->view(‘layout/footer’);
}
}
?>
<?php
class nj_user extends CI_model
{
function get_search($searchterm, $start, $limit)
{
$query =”select * from nj_user where name='”.$searchterm[‘uname’].”‘ || email='”.$searchterm[’email’].”‘ || mobile='”.$searchterm[‘mobil’].”‘ limit “.$start.”, ” .$limit;
$res = $this->db->query($query);
return $res->result();
}
function count_search( $searchterm)
{
$query =”select * from nj_user where name='”.$searchterm[‘uname’].”‘ || email='”.$searchterm[’email’].”‘ || mobile='”.$searchterm[‘mobil’].”‘ “;
$res = $this->db->query($query);
$Data=$res->result();
return count($Data);
}
}
?>
$(document) .on(“click”,”.search”,function(){
var name = document.getElementById(‘uname’);
var mail = document.getElementById(’email’);
var mob = document.getElementById(‘mobil’);
if (name.value != “” || mail.value != “” || mob.value != “”){
document.frmusers.submit();
}
})Users
<form method="post" action="user/searh” name=”frmusers”>Search User :
Search
<a href="user/view”>Clear Search.
<?php No. Name Address Gender Mobile Join Date
$srno = $hms + 1;
foreach($result as $row)
{?>user_id;?> name;?> address;?> email;?> gender;?> mobile;?> joindate?> <?php
$srno++; }?>Code By Harshit Shingala
but how to use ony with js ?????