Search Data From Database In Codeigniter With Example

#codeigniter #php

This tutorial is search data from database in Codeigniter based on CodeIgniter and Bootstrap design and other designs I share with you how to display data from database in PHP using Codeigniter. When we want to retrieve a record filtered by a keyword, we have to use the search function. we have to search for all records to get the needed one record. So, here I will explain to you how to display data from database in Codeigniter simple search button.

Search Data From Database In Codeigniter With Example

Controller

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Searchcontroller extends CI_Controller {

  public function searchfunction()
        {
            $data['searchdata']=$this->Search_Model->GetSearchdata();
            $this->load->view('search',$data);
        }
}

Model

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Search_Model extends CI_Model {

public function GetSearchdata()
    {
        $this->db->select("*"); 
        $this->db->like('tutorial_name',$this->input->get('search'));
        $query = $this->db->get("tutorial_name"); 
        return $query->result();
    }
}