ikan Uploader :
Directory : /var/www/html/chalkbank.com/application/models/
Upload File : |
| Current File : /var/www/html/chalkbank.com/application/models/Registration_model.php |
<?php
class Registration_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
/*
* Function: deleteCourse
* Description : delete course details
*/
public function deleteRecord($id, $field_name= 'id', $tbl_name = 'su_registration_setting')
{
$this->db->where($field_name, $id);
$data = array();
$data = array('is_deleted'=> '1','status'=>'0');
if (!$this->db->update($tbl_name, $data)) {
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
/*
* Function : removeSpecialChars
*/
function removeSpecialChars($post)
{
$newArray = array();
foreach($post as $key=>$string)
{
//$string = preg_replace('/[^a-zA-Z0-9_ -]/s','',$string);
$string = str_replace( array( '\'', '"', ',' , ';','—','’','~','!','@','#','#','^','*', '|'), ' ', $string);
$newArray[$key] = $string;
}
return $newArray;
}
/*
* Function : getCommonRecords
* Description : Get all courses details
*/
function getCommonRecords($tbl_name='su_registration_setting', $condition_array) {
$this->db->select('*');
$this->db->from($tbl_name);
$this->db->where('is_deleted', '0');
foreach($condition_array as $key=>$val){
$this->db->where($key, $val);
}
$queryResult = $this->db->get();
//echo $this->db->last_query(); die;
return $queryResult->row_array();
}
/*
* Function : getRecords
* Description : Get all courses details
*/
function getRecords($tbl_name='su_registration_setting', $dy_id = NULL, $condition_array) {
$this->db->select('*');
$this->db->from($tbl_name);
$this->db->where('is_deleted', '0');
if($dy_id>0){
$this->db->where('id', $dy_id);
}
foreach($condition_array as $key=>$val){
$this->db->where($key, $val);
}
$this->db->or_where('admin_id', '0');
$queryResult = $this->db->get();
//echo $this->db->last_query(); die;
if ($dy_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function: setRecordDetails
* Description : set course details
*/
function setRecordDetails($post, $tbl_name = 'su_registration_setting')
{
unset($post['submit']);
// Remove Special Character
$post = $this->removeSpecialChars($post);
if ($post['edit'] > 0) {
$this->db->where('id', $post['edit']);
unset($post['edit']);
unset($post['id']);
if (!$this->db->update($tbl_name, $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
} else {
unset($post['edit']);
unset($post['id']);
if (!$this->db->insert($tbl_name, $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
}
}
Kontol Shell Bypass