Jump to content

codeigniter pagination help plz

hamed86

By hamed86
in PHP Coding Help

 Share

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
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
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.