Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /**
- *
- */
- class API extends CI_Controller
- {
- public function index()
- {
- date_default_timezone_set('Asia/Jakarta');
- error_reporting(E_ALL);
- ini_set('display_errors', 1);
- $this->load->helper('date');
- }
- public function getSlider(){
- $data = array();
- $sql = "SELECT * FROM tb_kategori_wisata, tb_wisata WHERE tb_wisata.id_kategori = tb_kategori_wisata.id_kategori AND tb_wisata.is_slider = 1 ORDER BY tb_wisata.id_wisata DESC";
- $q = $this->db->query($sql);
- if($q->num_rows() > 0){
- $data['result'] = 'true';
- $data['msg'] = 'Data Slider';
- $data['data'] = $q->result();
- }else{
- $data['result'] = 'false';
- $data['msg'] = 'Tidak ada data menu';
- }
- #pre($this->db->last_query());
- echo json_encode($data);
- }
- public function get_kategori(){
- $data = array();
- $sql = "SELECT * FROM tb_kategori_wisata";
- $q = $this->db->query($sql);
- if($q->num_rows() > 0){
- $data['result'] = 'true';
- $data['msg'] = 'Data Kategori';
- $data['data'] = $q->result();
- }else{
- $data['result'] = 'false';
- $data['msg'] = 'Tidak ada data';
- }
- #pre($this->db->last_query());
- echo json_encode($data);
- }
- public function wisataByIdKategori(){
- $data = array();
- $id_kategori = $this->input->post('id_kategori');
- //$this->db->where('id_resto', $idresto);
- $sql = "SELECT * FROM tb_kategori_wisata, tb_wisata WHERE tb_wisata.id_kategori = tb_kategori_wisata.id_kategori AND tb_wisata.id_kategori = '$id_kategori' ORDER BY tb_wisata.id_wisata DESC";
- $q = $this->db->query($sql);
- if($q->num_rows() > 0){
- $data['result'] = 'true';
- $data['msg'] = 'Data Wisata';
- $data['data'] = $q->result();
- }else{
- $data['result'] = 'false';
- $data['msg'] = 'Tidak ada data wisata';
- }
- #pre($this->db->last_query());
- echo json_encode($data);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement