| Server IP : 82.197.83.129 / Your IP : 216.73.216.166 [ Web Server : LiteSpeed System : Linux us-bos-web1456.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : u489457460 ( 489457460) PHP Version : 7.3.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail Domains : 2 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u489457460/domains/syoft.com/public_html/blogs/application/controllers/ |
Upload File : |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Home extends CI_Controller {
public function index()
{
$q=$this->db->query("SELECT * FROM `home_page_settings` limit 1");
$data['home_page_settings'] = $q->row_array();
$data['result_data'] = $this->db->query("select s.*,c.course_name,c.course_id,cy.*,c.course_slug from schedule s
inner join courses c on s.course_id=c.course_id
left join cities cy on cy.city_id=s.city_id order by c.course_slug ASC limit 15")->result_array();
$data['test_data'] = $this->db->query("select s.*,c.exam_type from online_tests s
inner join exam_types c on s.exam_type_id=c.exam_type_id where s.status='1'
order by s.test_name ASC limit 25")->result_array();
// print_r($data['test_data']);exit;
$q=$this->db->query("SELECT * FROM `exam_types` where status='1'");
$data['exam_types'] = $q->result_array();
$q=$this->db->query("SELECT test_name,test_id FROM `online_tests` where status='1'");
$data['online_tests'] = $q->result_array();
$this->load->view('user/index.php',$data);
}
public function filter()
{
$category_id=$this->input->post('category_id');
$city_id=$this->input->post('city_id');
$traning_type=$this->input->post('traning_type');
$sql="select s.*,c.course_name,c.course_id,cy.*,c.course_slug from schedule s
inner join courses c on s.course_id=c.course_id
left join cities cy on cy.city_id=s.city_id where s.status='1' ";
if($category_id!='')
{
$sql.= " and s.course_id='$category_id'";
}
if($city_id!='' && ($traning_type!='eLearning' || $traning_type!='Live Virtual'))
{
$sql.= " and s.city_id='$city_id'";
}
if($traning_type!='')
{
$sql.= " and s.traning_type='$traning_type'";
}
$sql.= " order by c.course_slug ASC limit 50";
$q=$this->db->query($sql);
$data['result_data']=$q->result_array();
$this->load->view('user/result_data.php',$data);
}
public function exam_filter()
{
$exam_name=$this->input->post('exam_name');
$exam_types=$this->input->post('exam_types');
$sql="select s.*,c.exam_type from online_tests s
inner join exam_types c on s.exam_type_id=c.exam_type_id
where s.status='1' ";
if($exam_types!='')
{
$sql.= " and s.exam_type_id='$exam_types'";
}
if($exam_name!='')
{
$sql.= " and s.test_name like '%$exam_name%'";
}
$sql.= " order by s.test_name ASC limit 50";
$q=$this->db->query($sql);
$data['test_data']=$q->result_array();
$this->load->view('user/exam_filter.php',$data);
}
public function load_more()
{
$data['result_data'] = $this->db->query("select s.*,c.course_name,c.course_id,cy.*,c.course_slug from schedule s
inner join courses c on s.course_id=c.course_id
left join cities cy on cy.city_id=s.city_id order by c.course_slug ASC limit 15,100")->result_array();
$this->load->view('user/load_more.php',$data);
}
public function get_test_data()
{
$test_id=$this->input->post('test_id');
$data['view_data'] = $this->db->query("select * from online_tests where test_id='$test_id'")->row_array();
$this->load->view('user/get_test_data.php',$data);
}
}