public function set_all_trips() { $key_array = array(); $custom_model = new Custom_model(); $where_cond_str = 'p.post_published = "1"'; $records = $custom_model->get_search_results('p.post_url_key', $where_cond_str); if (count($records) > 0) { foreach ($records as $value) { $key_array[] = $value['post_url_key']; } $this->ci->redis->set('all_trips', json_encode($key_array)); } return $key_array; }
public function search_query($view_type = 'list', $page = 1) { $model = new Common_model(); $custom_model = new Custom_model(); if ($this->input->get('q')) { $params = $this->input->get(); $query = $params['q']; $user_id = isset($this->session->userdata['user_id']) == TRUE ? $this->session->userdata['user_id'] : NULL; if ($model->is_exists('ps_id', TABLE_POST_SEARCHES, array('ps_user_id' => $user_id, 'ps_query' => addslashes($query), 'ps_timestamp >=' => date('Y-m-d'))) == FALSE) { $data_array = array('ps_user_id' => $user_id, 'ps_query' => addslashes($query), 'ps_url' => addslashes(current_url()), 'ps_params' => json_encode($params), 'ps_ipaddress' => USER_IP, 'ps_useragent' => USER_AGENT); $model->insertData(TABLE_POST_SEARCHES, $data_array); } $order_by = get_post_mysql_sort_by(@$params['sort']); $group_by = 'p.post_id'; $where_cond_str = '1'; $search_results = $custom_model->get_search_results('p.post_url_key', $where_cond_str, $order_by, $group_by); $input_arr = array(base_url() => 'Home', '#' => 'Search'); $breadcrumbs = get_breadcrumbs($input_arr); $page_title = 'Search results'; $data["post_records"] = $search_results; $data["view_type"] = $view_type; $data["page"] = $page; $data["breadcrumbs"] = $breadcrumbs; $data["page_title"] = $page_title; $data['meta_title'] = $data["page_title"] . ' - ' . $this->redis_functions->get_site_setting('SITE_NAME'); $this->template->write_view("content", "pages/trip/listing/list-page", $data); $this->template->render(); } else { display_404_page(); } }