Server IP : 92.204.138.22 / Your IP : 18.226.96.129 Web Server : Apache System : Linux ns1009439.ip-92-204-138.us 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64 User : internationaljou ( 1019) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/internationaljou/SSRG-01-03-2024/application/models/ |
Upload File : |
<?php class Upcoming_conferencelist extends CI_Model { function __construct() { parent::__construct(); } public function conferencelist() { //$this->db->select("*,DATE_FORMAT(conferencedate, '%d/%m/%Y') AS conferencedate"); $this->db->select("*"); $this->db->from('upcoming_conference'); $this->db->where("Status='C'"); $this->db->order_by("STR_TO_DATE(conferencedate,'%d/%m/%Y') desc"); //select * from upcoming_conference order by STR_TO_DATE(conferencedate,'%d/%m/%Y') desc /* $this->db->get(); echo $sql = $this->db->last_query(); exit; */ $query = $this->db->get()->result(); return $query; } public function uc_list_numrows() { $this->db->select("*"); $this->db->from('upcoming_conference'); $this->db->where("Status='C'"); $this->db->order_by("STR_TO_DATE(conferencedate,'%d/%m/%Y') desc"); $query = $this->db->get(); $query= $query->num_rows(); return $query; } public function get_year() { $this->db->select("YEAR(STR_TO_DATE(conferencedate,'%d/%m/%Y')) as getyear"); $this->db->from('upcoming_conference'); $this->db->distinct(); $this->db->where("Status='D'"); $this->db->order_by("STR_TO_DATE(conferencedate,'%d/%m/%Y') desc"); $query = $this->db->get()->result(); $i=0; foreach($query as $year){ //print_r($year->year); $query[$i]->sub = $this->getconference_year_second($year->getyear); $i++; } return $query; } public function getconference_year_second($yearvalue) { $this->db->select('*'); $this->db->from('upcoming_conference'); $this->db->distinct(); $this->db->where('YEAR(STR_TO_DATE(conferencedate,"%d/%m/%Y"))',$yearvalue); $this->db->where('Status','D'); $this->db->order_by("STR_TO_DATE(conferencedate,'%d/%m/%Y') desc"); $query = $this->db->get()->result(); //$query = $this->db->get(); //echo $query = $this->db->last_query(); echo ";"; return $query; $i=0; foreach($query as $year){ //print_r($year->year); $query[$i]->sub = $this->getconference_year_second($year->getyear); $i++; } return $query; } public function conference_details() { $id = $this->uri->segment(3); $this->db->select("*"); $this->db->from('upcoming_conference'); $this->db->where('conference_id',$id); $query = $this->db->get()->result(); //echo $str = $this->db->last_query(); //exit; return $query; } public function conference_committee_details() { $id = $this->uri->segment(3); $this->db->select("*"); $this->db->from('committee_member'); $this->db->where('conferenceid',$id); $query = $this->db->get()->result(); //echo $str = $this->db->last_query(); //exit; return $query; } } ?>