ikan Uploader :
Directory : /var/www/html/shardahospital.org/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/application/models/News_model.php |
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class News_model extends CI_Model{
protected $table_name = 'SH_News';
protected $primary_key = 'newsid';
protected $order_by = 'newsidPriorityOrder DESC';
protected $fields_detail = 'newsid, news_title, image, news_description, current_date,news_slug, SH_News.status';
protected $fields_summary = 'newsid, news_title, image, news_description,
current_date, news_slug, status';
public function __construct()
{
parent::__construct();
}
function get_news($id=NULL, $limit=NULL){
if($id!=0){
$records = $this->db->query("SELECT newsid,news_title,image,news_description,news_slug,news_date,current_date FROM `SH_News` where newsid='".$id."' and status='1' order by newsid DESC")->result_array();
}
else {
if($limit){
$records = $this->db->query("SELECT newsid,news_title, image, news_description,news_slug,news_date,current_date FROM `SH_News` where status='1' order by newsid DESC limit $limit")->result_array();
}else{
$records = $this->db->query("SELECT newsid,news_title, image,news_description,news_slug,news_date,current_date FROM `SH_News` where status='1' order by newsid DESC")->result_array();
}
}
return $records;
}
/* function view_testimonials(){
$testimonialss = $this->db->query("SELECT * FROM `SH_News` where status='1' order by newsid DESC")->result_array();
return $testimonialss;
}*/
public function editnews($data, $newsid) {
$data['update_date'] = date('d-m-Y H:i:s');
$this->db->where($this->primary_key, $newsid);
return $this->db->update($this->table_name, $data);
}
public function insert_news($data){
$data['update_date'] = date('Y-m-d H:i:s');
$success = $this->db->insert($this->table_name, $data);
if($success) {
return $this->db->insert_id();
} else {
return FALSE;
}
}
public function delete_news($id) {
$this->db->where($this->primary_key, $id);
return $this->db->delete($this->table_name);
}
}
?>
Kontol Shell Bypass