PHP - Automatic Database Error Logging In Codeigniter

will the following code work to log any php errors i may have on the page this code is included?

Code: [Select]
ini_set('error_reporting', E_ALL);
error_reporting(E_ALL);
ini_set('log_errors',TRUE);
ini_set('html_errors',FALSE);
ini_set('error_log','./error_log.txt');
ini_set('display_errors',FALSE);

Hi All

I am building a website and I basically want to be able to log my own Error Logging.

This could be anything from a usual PHP Notice, An SQL Query failing, a 404 page or a user reaching an activity they should not have (For example, hitting a default: on a switch when they shouldn't have)

I have 3 options that I can think off
1) MySQL
2) Email
3) File Write

All have pros and cons
MySQL - Pro - I can build an admin script to read the errors and display them for me to handle and mark when completed.
MySQL - CON - What is the Queries fail for what ever reason (too many connections), then the query to log the error would also fail, thus I would never know

Email: PRO - Should always work, I will know straight away
Email: CON - Getting the data from an email to a user friendly screen, instead of clogging up my email box

File Write - PRO - I can put the data into MySQL at any point, Should near enough always work
File Write - CON - Other people could possibly see the the errors, which could give away directories or weaknesses in the web project.

Does anyone have any suggestions?

Hi,

hello....   I am a  new bee to PHP...can any one please let me know...why OOPs PHP...what make difference...between procedural(Generic) PHP  and OOPs PHP...if possible provide me any referal links...   and i have gone through Codeigniter user guide....it was quite good...but can any one let me know how to develop an entire web-application...in Codeigniter....if possible provide me any referal links...     Thanks & Regards Shankaar

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;
}
}