Jump to content

codeigniter pagination help plz

hamed86

By hamed86
in PHP Coding Help

Recommended Posts

hamed86 Newbie

hamed86

Posted
Posted

Hi need help with pagination of my page where the advertiser is showing. here is my website. photoagahi.com

 

search.php controller looks like this:

 

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

class Search extends Application
{
public function __construct()
{
	parent::__construct();
	$this->load->model('meta_model');
	$this->load->helper('url');
	$this->load->model('category_model');
	$this->load->model('advert_model');
	$this->load->helper('Fdate');
	$this->load->helper('form');
	$this->load->library('table');
	$this->load->helper('advert');
	$this->load->library('form_validation');
	$this->load->helper('security');
	$this->config->add_to_item(KCI_LANG, 'search');

      
     $this->load->library('pagination');


      $config['base_url'] = base_url();
      $config['total_rows'] = '50';
      $config['per_page'] = '30';
      $config['full_tag_open'] = '<p>';
      $config['full_tag_close'] = '</p>';
      $config['last_link'] = 'Last';
      $config['uri_segment'] = '4';
   
     $this->pagination->initialize($config); 

}

/**
 * Returns the search with based on the requested county.
 * If the county was recently visited, the municipality and locality aren't updated.
 * 
 * The primary search is also made to determine the latest search.
 *
 * @param unknown_type $slug
 */
public function index($county, $target = ADVERT_TARGET_ALL_SLUG, $sort = null, $type = null, $category = null, $municipality = null, $text = null)
{

	$county = $this->meta_model->county(xss_clean($county));
	if(!$county)
		redirect('');
	$this->load_banner(array($county->county_id,BANNER_SECTION_SEARCH));	
	if(!get_county() || get_county()->county_id != $county->county_id)
		set_county($county);

	$this->form_validation->set_rules('text', lang('advert_freetext'), 'max_length[100]');		

	$adverts = array();
	$count = array();
	if($this->form_validation->run())
	{
		$url = array();
		$url[] = $county->county_slug;
		$url[] = $this->input->post('advert_target') ? $this->input->post('advert_target') : ADVERT_TARGET_ALL_SLUG;
		$url[] = $this->input->post('advert_sort') ? $this->input->post('advert_sort') : ADVERT_SORT_TIME;
		$url[] = $this->input->post('advert_type') ? implode('-',$this->input->post('advert_type')) : ADVERT_TYPE_SALE;
		$url[] = $this->input->post('category_id') ? $this->input->post('category_id', true) : 0;
		$url[] = $this->input->post('municipality_id') ? $this->input->post('municipality_id', true) : 0;

		if($this->input->post('text'))
			$url[] = urlencode($this->input->post('text', true));

		$slug = '/'.implode('/', $url);
		redirect($slug);
	}
	else 
	{
		$params = array();

		//Convert to objects
		if($type)
		{
			$type = explode('-', xss_clean($type));
			if($type)
			{
				$params['advert_type'] = $type;

				foreach($type as $t)
				populate('advert_type['.$t.']', true);
			}
		}
		else 
		{
			$params['advert_type'] = array(ADVERT_TYPE_SALE);
			populate('advert_type['.ADVERT_TYPE_SALE.']', true);
		}


		if($category)
			$category = $this->category_model->get(xss_clean($category));
		populate('category_id', $category ? $category->category_id : null);
		$params['category_id'] = $category ? $category->category_id : null;

		if($municipality == ADVERT_CODE_ENTIRE_COUNTY)
		{
			$params['county_id'] = $county->county_id;
			populate('municipality_id', ADVERT_CODE_ENTIRE_COUNTY);
		}
		else if($municipality == ADVERT_CODE_ENTIRE_COUNTRY)
			populate('municipality_id', ADVERT_CODE_ENTIRE_COUNTRY);
		else if($municipality)
		{
			$municipality = $this->meta_model->municipality(xss_clean($municipality));
			if($municipality)
			{
				$params['municipality_id'] = $municipality->municipality_id;
				populate('municipality_id', $municipality->municipality_id);
			}
		}
		else 
			$params['county_id'] = $county->county_id;

		if($target && $target != ADVERT_TARGET_ALL_SLUG)
		{
			$target = $this->advert_model->slug_target(xss_clean($target));
			if($target)
			{
				populate('advert_target',  $target->target_slug);
				$params['advert_target'] = $target->target_id;
			}
		}
		else 
			populate('advert_target', ADVERT_TARGET_ALL_SLUG);

		$params['advert_sort'] = $sort ? $sort : ADVERT_SORT_TIME;
		populate('advert_sort', $params['advert_sort']);
		$params['text'] = $text ? xss_clean($text) : null;
		populate('text', $text ? xss_clean($text) : null);

		$adverts = $this->advert_model->search($params, $count);
	}

	$months = months();
	$advert_types = $this->advert_model->types();
	$municipalities = $this->meta_model->municipalities($county);
	$categories = $this->category_model->all();
	$this->_view('search_view', array(
							  'months' => $months,
							  'municipalities' => $municipalities, 
							  'categories'=>$categories,
							  'county' => $county,
							  'adverts' => $adverts,
							  'advert_types'=>$advert_types,
							  'count' => $count));
}

/**
 * Returns the municipalities as JSON for a specified county
 * This is used by the AJAX request on the search filter
 *
 */
public function municipalities()
{
	$result = array();
	$county_id = $this->input->post('id', true);

	if($county_id == 0)
	{
		$result['message'] = lang('ar_county_not_choosen');
		set_county(null);
	}
	else 
	{
		$county = $this->meta_model->county_by_id($county_id);

		if(!$county)
		{
			$result['error'] = lang('ar_county_not_found');	
		}
		else 
		{
			set_county($county);

			$result['county_name'] = utf8_encode($county->county_name);

			foreach($this->meta_model->municipalities_for_json($county) as $municipality)
				$result['municipalities'][] = array_map('utf8_encode', $municipality);
		}
	}

	echo json_encode($result);
	die();
}

/**
 * Returns the localities as JSON for a specified municipality
 * This is used by the AJAX request on the search filter
 *
 */
public function localities()
{
	$result = array();
	$municipality_id = $this->input->post('id', true);

	if($municipality_id == 0)
	{
		$result['message'] = lang('ar_municipality_not_choosen');
		set_municipality(null);
	}
	else 
	{
		$municipality = $this->meta_model->municipality($municipality_id);

		if(!$municipality)
		{
			$result['error'] = lang('ar_municipality_not_found');	
		}
		else 
		{
			set_municipality($municipality);

			$result['municipality_name'] = utf8_encode($municipality->municipality_name);

			foreach($this->meta_model->localities_for_json($municipality) as $locality)
				$result['localities'][] = array_map('utf8_encode', $locality);
		}
	}

	echo json_encode($result);
	die();
}

/**
 * Updates the session container with the 
 * latest requested locality. Used by 
 * the AJAX request in the search filter
 * 
 *
 */
public function locality_set()
{
	$locality_id = $this->input->post('id', true);

	if($locality_id == 0 || !is_numeric($locality_id))
		set_locality(null);

	$locality = $this->meta_model->locality($locality_id);

	if(!$locality)
		set_locality(null);
	else 
		set_locality($locality);
}

/**
 * Updates the session container with the 
 * latest requested category. Used by 
 * the AJAX request in the search filter
 * 
 *
 */
public function category_set()
{
	$category_id = $this->input->post('id', true);

	if($category_id == 0 || !is_numeric($category_id))
		set_category(null);

	$category = $this->category_model->get($category_id);

	if(!$category)
		set_category(null);
	else 
		set_category($category);
}

/**
 * Lodge search that returns the info as JSON.
 * Used by the AJAX request in the search filter.
 *
 */
public function process_search()
{
	$text = utf8_decode($this->input->post('text', true));
	$offset = utf8_decode($this->input->post('offset', true));

	if(!is_numeric($offset))
		$offset = 0;

	$result = array();
	$result_count = 0;
	$lodges = $this->lodge_model->search($text, 10, $offset, true, $result_count);

	$result['result_count'] = $result_count;

	foreach($lodges as $lodge)
	{
		$tmp = array_map('utf8_encode', get_object_vars($lodge));

		foreach($this->lodge_model->facilities($lodge) as $facility)
			$tmp['facilities'][] = array_map('utf8_encode', get_object_vars($facility));

		foreach($this->lodge_model->distances($lodge) as $distance)
			$tmp['distances'][] = array_map('utf8_encode', get_object_vars($distance));

		foreach($this->lodge_model->prices($lodge) as $price)
			$tmp['prices'][] = array_map('utf8_encode', get_object_vars($price));

		$image = $this->lodge_model->image($lodge);
		if($image)
			$tmp['image'] = array_map('utf8_encode', get_object_vars($image));

		$result['lodges'][] = $tmp;
	}

	echo json_encode($result);
}

}

 

and the model Meta_model:

 

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


class Meta_model extends KCI_Model
{
public function counties_with_coordinates()
{
	$this->db->join(TBL_COUNTY_COORDINATE, TBL_COUNTY_COORDINATE.'.county_id = '.TBL_COUNTY.'.county_id');
	$this->db->order_by('map_index', 'ASC');
	return $this->db->get(TBL_COUNTY)->result();
}

public function county($slug)
{
	if(!$slug)
		return false;

	$this->db->where('county_slug', $slug);

	$this->db->join(TBL_COUNTY_COORDINATE, TBL_COUNTY_COORDINATE.'.county_id = '.TBL_COUNTY.'.county_id');
	return $this->db->get(TBL_COUNTY, 1)->row();	

}
public function county_by_id($id)
{
	$this->db->where('county_id', $id);
	return $this->db->get(TBL_COUNTY, 1)->row();
}

public function county_by_lodge($lodge)
{
	$this->db->where('lodge_id', $lodge->lodge_id);
	$this->db->join(TBL_LOCALITY, TBL_LOCALITY.'.locality_id = '.TBL_LODGE.'.locality_id');
	$this->db->join(TBL_MUNICIPALITY, TBL_MUNICIPALITY.'.municipality_id = '.TBL_LOCALITY.'.municipality_id');
	$this->db->join(TBL_COUNTY, TBL_COUNTY.'.county_id = '.TBL_MUNICIPALITY.'.county_id');
	$this->db->join(TBL_COUNTY_COORDINATE, TBL_COUNTY_COORDINATE.'.county_id = '.TBL_COUNTY.'.county_id');
	return $this->db->get(TBL_LODGE, 1)->row();
}

public function municipality_by_lodge($lodge)
{
	$this->db->where('lodge_id', $lodge->lodge_id);
	$this->db->join(TBL_LOCALITY, TBL_LOCALITY.'.locality_id = '.TBL_LODGE.'.locality_id');
	$this->db->join(TBL_MUNICIPALITY, TBL_MUNICIPALITY.'.municipality_id = '.TBL_LOCALITY.'.municipality_id');
	return $this->db->get(TBL_LODGE, 1)->row();
}

public function locality_by_lodge($lodge)
{
	$this->db->where('lodge_id', $lodge->lodge_id);
	$this->db->join(TBL_LOCALITY, TBL_LOCALITY.'.locality_id = '.TBL_LODGE.'.locality_id');
	return $this->db->get(TBL_LODGE, 1)->row();
}

public function municipalities_for_json($county = null)
{
	if($county)
		$this->db->where('county_id', $county->county_id);	

	$this->db->select('municipality_id, municipality_name');
	$this->db->order_by('municipality_name', 'ASC');

	return $this->db->get(TBL_MUNICIPALITY)->result_array();
}

public function municipalities($county = null)
{
	if(is_numeric($county))
		$this->db->where('county_id', $county);
	elseif($county)
		$this->db->where('county_id', $county->county_id);	

	$this->db->order_by('municipality_name', 'ASC');

	return $this->db->get(TBL_MUNICIPALITY)->result();
}

public function municipality($id)
{
	$this->db->where('municipality_id', $id);
	return $this->db->get(TBL_MUNICIPALITY, 1)->row();
}

public function localities_for_json($municipality = null)
{
	if($municipality)
		$this->db->where('municipality_id', $municipality->municipality_id);	

	$this->db->where('locality_type', 'T');
	$this->db->select('locality_id, locality_name');
	$this->db->order_by('locality_name', 'ASC');

	return $this->db->get(TBL_LOCALITY)->result_array();
}

public function localities($municipality = null)
{
	if($municipality)
		$this->db->where('municipality_id', $municipality->municipality_id);	

	$this->db->where('locality_type', 'T');
	$this->db->order_by('locality_name', 'ASC');

	return $this->db->get(TBL_LOCALITY)->result();
}

public function locality($id)
{
	$this->db->where('locality_id', $id);
	$this->db->where('locality_type', 'T');
	$this->db->order_by('locality_name', 'ASC');

	return $this->db->get(TBL_LOCALITY, 1)->row();
}

public function locality_parameters_by_municipality($municipality)
{
	$this->db->where('municipality_id', $municipality->municipality_id);
	$this->db->select('locality_id');
	$municipalities = $this->db->get(TBL_LOCALITY)->result();
	$result = array();

	if($municipalities)
		foreach($municipalities as $municipality)
			$result[] = $municipality->municipality_id;

	return $result;
}
}

Link to comment
https://forums.phpfreaks.com/topic/210790-codeigniter-pagination-help-plz/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.