コード例 #1
0
 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;
 }
コード例 #2
0
ファイル: trip.php プロジェクト: arp19690/newtravel
 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();
     }
 }