File manager - Edit - /home/u608250662/domains/rdsolution.org.in/public_html/jevica/application/models/Crud.php
Back
<?php class Crud extends CI_Model { function insert($table,$data) { $result=$this->db->insert($table,$data); return $result; } function update($id,$data,$table) { $this->db->where('id',$id); return $this->db->update($table,$data); } function delete($id,$table) { $this->db->where('id',$id); return $this->db->delete($table); } function deletebydevid($devid,$table) { $this->db->where('devid',$devid); return $this->db->delete($table); } function deletebyurl($url,$table) { $this->db->where('url',$url); return $this->db->delete($table); } public function selecttablemaster() { $result=$this->db->get('tbl_master'); return $result->result(); } public function selectcommonbyurl($url) { $this->db->where('url',$url); $result=$this->db->get('tbl_master'); return $result->result(); } public function select_sub_category($url,$table) { $this->db->where('category_url',$url); $result=$this->db->get($table); return $result->result(); } public function select_products($url,$table) { $this->db->where('sub_cat_url',$url); $result=$this->db->get($table); return $result->result(); } public function select_related_products($url,$table,$product_url) { $this->db->where('sub_cat_url',$url); $this->db->where('product_url !=', $product_url); $result=$this->db->get($table); return $result->result(); } public function select_product($url,$table) { $this->db->where('product_url',$url); $result=$this->db->get($table); return $result->result(); } public function selectbyid($id) { $this->db->where('id',$id); $result=$this->db->get('sarvice'); return $result->result(); } public function selectlimitgallery() { $this->db->order_by('id','desc'); $this->db->where('status','1'); $this->db->limit(8); $result=$this->db->get('wdi_gallery'); return $result->result(); } public function updatecommontable($url,$data) { $this->db->where('url',$url); return $this->db->update('tbl_master',$data); } public function selectseobyurl($url) { $this->db->where('url',$url); $result=$this->db->get('seo'); return $result->result(); } function selectdatabycolumnname($table,$column,$value) { $this->db->where($column, $value); $data=$this->db->get($table); return $data->result(); } function selectblogbycolumnname($table,$column,$value) { $this->db->where($column, $value); $this->db->order_by('id', 'desc'); $data=$this->db->get($table); return $data->result(); } function selectDataByMultipleWhere($table,$where) { $this->db->where($where); $data=$this->db->get($table); return $data->result(); } public function selectDataGroupBy($table,$group) { $this->db->group_by($group); $data=$this->db->get($table); return $data->result(); } public function fetchAllData($table) { if($table=='blue_category'){ $this->db->order_by('category_order','asc'); } if($table=='blue_sub_category'){ $this->db->order_by('sub_category_order','asc'); } $data=$this->db->get($table); return $data->result(); } public function fetchAll_Data($table,$url) { $this->db->where('cate_url',$url); $data=$this->db->get($table); return $data->result(); } public function fetchRandomProducts($table,$url) { $this->db->order_by('id', 'RANDOM'); // random order $this->db->limit(4); // only 4 products $this->db->where('product_url !=',$url); // only 4 products $query = $this->db->get($table); return $query->result(); } public function fetchAllBlogCat($table) { $this->db->where('showonmenu',1); $data=$this->db->get($table); return $data->result(); } // Farook mohammad function get_data($table) { $data = $this->db->get($table); return $data->result(); } function get_blog_data($table,$url) { $this->db->where('url','!=', $url); // latest first $this->db->order_by('created_at', 'DESC'); // latest first $this->db->limit(3); // only top 3 $data = $this->db->get($table); return $data->result(); } }
| ver. 1.4 |
Github
|
.
| PHP 8.0.30 | Generation time: 0.03 |
proxy
|
phpinfo
|
Settings