Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/adimi/application/modules/dashboard/models/ |
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Search_history extends CI_Model {
public function __construct()
{
parent::__construct();
}
public function search_histries(){
$query = $this->db->select('*')
->from('search_history')
->order_by('hits','DESC')
->limit(5)
->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
//insert Search History
public function insert_search_history($search_data)
{
$this->db->select('*');
$this->db->from('search_history');
$this->db->where('keyword',$search_data['keyword']);
$query = $this->db->get()->result();
if (count($query) > 0) {
$this->db->set('hits',($query[0]->hits)+1);
$this->db->set('results',$query[0]->results);
$this->db->where('keyword',$query[0]->keyword);
$result = $this->db->update('search_history');
return TRUE;
}else{
$search_data['hits'] = 1;
$this->db->insert('search_history',$search_data);
return TRUE;
}
}
public function all_search_histries(){
$query = $this->db->select('*')
->from('search_history')
->order_by('hits','DESC')
->get();
if ($query->num_rows() > 0) {
return $query->result_array();
}
return false;
}
}