[eluser]novarli[/eluser]
I have scripts
Controller
Code:
function search(){
if($this->account['role'] != 'admin'){
show_error('You cannot access this page');
exit();
}
$data['head']['title'] = 'City - FirstLabor';
$data['head']['style'] = '<link href="'.base_url().'css/form.css" rel="stylesheet" type="text/css" media="screen" />'."\n";
$data['head']['script'] = '[removed][removed]'."\n";
$data['head']['script'] .= '[removed]window.onload=focus_country[removed]'."\n";
$data['tab'] = $this->config->item('tab');
$data['account'] = $this->session->userdata('account');
$data['page']['primary'] = 'Administration';
$data['page']['secondary'] = 'File';
$data['page']['title'] = 'CITY';
$data['form']['action'] = 'city/search_res';
$data['form']['submit'] = 'Search';
$data['tab'] = $this->config->item('tab');
$data['account'] = $this->session->userdata('account');
$data['province'] = $this->cities->getProvince();
$rules['txtName'] = 'required';
$this->load->view('city/search', $data);
}
function search_res(){
$data['head']['title'] = 'City - FirstLabor';
$data['head']['style'] = '<link href="'.base_url().'js/jquery/tablesorter/themes/blue/style.css" rel="stylesheet" type="text/css" media="screen" />';
$data['head']['script'] = '[removed][removed]'."\n";
$data['head']['script'] .= '[removed][removed]'."\n";
$data['page']['primary'] = 'Administration';
$data['page']['secondary'] = 'File';
$data['page']['title'] = 'CITY';
$data['tab'] = $this->config->item('tab');
$data['account'] = $this->account;
$config['base_url'] = base_url().'city/search_res';
$txtName=$this->input->post('txtName');
$province=$this->input->post('province');
$data['count_result'] = $this->cities->count_result($txtName,$province);
$config['total_rows'] = $data['count_result'];
$config['per_page'] = 10;
$this->pagination->initialize($config);
$offset = $this->uri->segment(3);
$data['search_res'] = $this->cities->getSearchResult($txtName,$province, $config['per_page'], $offset);
$this->load->view('city/search_res', $data);
}
Model
Code:
function getSearchResult($city,$province,$limit,$offset){
$this->db->select('cities.id,cities.name as city_name,provinces.name as province_name');
$this->db->from('cities');
$this->db->join('provinces','cities.province = provinces.id');
if (!empty($city))
{
$this->db->like('cities.name',$city);
}
if ($offset)
{
$this->db->limit($limit,$offset);
}
else
{
$this->db->limit($limit);
}
if ($province!=0){
$this->db->where('province', $province);
}
$this->db->order_by('cities.name');
return $this->db->get();
}
function count_result($city,$province)
{
$this->db->select('cities.id,cities.name as city_name,provinces.name as province_name');
$this->db->from('cities');
$this->db->join('provinces','cities.province = provinces.id');
if (!empty($city))
{
$this->db->like('cities.name',$city);
}
if ($province!=0){
$this->db->where('province', $province);
}
return $this->db->get();
}
and view (search_res.php)
Code:
<? foreach ($search_res as $p): ?>
<?php echo $p->city_name; ?><br>
<? endforeach; ?>
Error appears
Severity: Notice
Message: Trying to get property of non-object
Filename: city/search_res.php
Line Number: 24
Code:
<?php echo $p->city_name; ?><br>
What happen?
[/code]