👁 View: Model_search.php
Path: /home/thiqat5/webcms.thiqatech.com/application/models/Model_search.php
Size: 831 B · Modified: 2022-08-23 21:47:34 · Perm: 0644 · Writable
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Model_search extends CI_Model
{
    public function search($search_string)
    {
        $search_string = '%' . $search_string . '%';
        $sql = "SELECT * 
				FROM tbl_news
				WHERE news_title like ? OR news_content like ?
				ORDER BY news_id ASC";
        $query = $this->db->query($sql,array($search_string,$search_string));
        return $query->result_array();
    }
    public function search_total($search_string)
    {
        $search_string = '%' . $search_string . '%';
        $sql = "SELECT * 
				FROM tbl_news
				WHERE news_title like ? OR news_content like ?
				ORDER BY news_id ASC";
        $query = $this->db->query($sql,array($search_string,$search_string));
        return $query->num_rows();
    }
}