Catatanku: Februari 2014

di Controller...
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class bioskop extends CI_Controller {

    public function index()
    {
        $this->load->view('bioskop');
    }
    public function login_admin()
    {
        $this->load->view('login_admin');
    }
    public function trailer(){
            $this->load->model('bioskopmodel');
            $data['data'] = $this->bioskopmodel->bioskop('film');
            $this->load->view('trailer',$data);
    }

    public function usrjdl(){
            $this->load->model('bioskopmodel');
            $data['data'] = $this->bioskopmodel->bioskop('Jadwal');
            $this->load->view('usrjdl',$data);

    }

    public function film()
        {
            //jika tidak ada session login
            if(!$this->session->userdata('login')){
                //redirect ke home
                redirect();
            }
            $this->load->model('bioskopmodel');
            $data['data'] = $this->bioskopmodel->bioskop('film');
            $this->load->view('film',$data);
        }

    public function Jadwal()
        {

            //jika tidak ada session login
            if(!$this->session->userdata('login')){
                //redirect ke home
                redirect();
            }
            $this->load->model('bioskopmodel');
            $data['data'] = $this->bioskopmodel->bioskop('Jadwal');
            $this->load->view('Jadwal',$data);
        }

        public function pemesan()
        {

            //jika tidak ada session login
            if(!$this->session->userdata('login')){
                //redirect ke home
                redirect();
            }
            $this->load->model('bioskopmodel');
            $data['data'] = $this->bioskopmodel->bioskop('tiket');
            $this->load->view('pemesan',$data);
        }
    public function detail()
        {
            $id = $this->uri->segment(3);
            $this->load->model('bioskopmodel');
            $data['data'] = $this->bioskopmodel->detail($id);
            $this->load->view('detail',$data);
        }

    public function hapuspemesan()
    {
        $this->load->helper('url');
        $id = $this->uri->segment(3);
        $this->load->model('bioskopmodel');
        $this->bioskopmodel->hapuspemesan($id);
        redirect('bioskop/pemesan');

    }

    public function hapus()
    {
        $this->load->helper('url');
        $id = $this->uri->segment(3);
        $this->load->model('bioskopmodel');
        $this->bioskopmodel->hapus($id);
        redirect('bioskop/film');

    }


    public function hapusjdl()
    {
        $this->load->helper('url');
        $id = $this->uri->segment(3);
        $this->load->model('bioskopmodel');
        $this->bioskopmodel->hapusjdl($id);
        redirect('bioskop/jadwal');

    }
    function tambahfilm(){
        $this->load->view('tambahfilm');
    }
    function tambah(){
        $this->load->model('bioskopmodel');
        $this->bioskopmodel->tambah();
        redirect('bioskop/film');
    }

    function tambahjadwal(){
        $this->load->view('tambahjadwal');
    }
    function tambahjdl(){
        $this->load->model('bioskopmodel');
        $this->bioskopmodel->tambahjdl();
        redirect('bioskop/jadwal');
    }

    function editdata(){
        $this->load->model('bioskopmodel');
            $data['data'] = $this->bioskopmodel->editdata();
            $this->load->view('editdata',$data);
        }

    function edit(){
            $this->load->model('bioskopmodel');
            $edit1 = $this->bioskopmodel->edit();
            redirect('bioskop/film');
        }

    function editdatajdl(){
        $this->load->model('bioskopmodel');
            $data['data'] = $this->bioskopmodel->editdatajdl();
            $this->load->view('editdatajdl',$data);
        }

    function editjdl(){
            $this->load->model('bioskopmodel');
            $edit1 = $this->bioskopmodel->editjdl();
            redirect('bioskop/jadwal');
        }

    function tiket(){
        $this->load->view('tiket');
    }
    function pesan_tiket(){
        $d = $this->db->get_where("tiket",array('no_bangku'=>$this->input->post('no_bangku')));
        if($d->num_rows() == 0){
            $this->load->model('bioskopmodel');
            $this->bioskopmodel->tiket();
            echo "<script> alert('Berhasil Di Pesan'); location='bioskop'</script>";
        }else{
            echo "<script>alert('Nomor Bangku Sudah Di Pesan');location='".base_url()."index.php/bioskop'</script>";
        }
    }

    function login(){
        $username = $this->input->post('user');
        $password = md5($this->input->post('pass'));
        $sql = $this->db->get_where('user',array('username'=>$username,'password'=>$password))->row();
        if($sql != null){
            $this->session->set_userdata('login',true);
            $this->session->set_userdata('id_user',$sql->id_user);
            echo "<script> alert ('selamat datang admin..!'); location='film'</script>";
        }
    }

    function logout()
    {
        $this->session->sess_destroy();
        echo "<script> alert ('anda berhasil keluar..!'); location='".base_url()."'</script>";
    }
}

lalu di models

<?php
class bioskopmodel extends CI_model
{
    function bioskop($film)
    {
        $this->load->database();
        $data= $this->db->get($film)->result();
        return $data;
    }

    function Jadwal($jadwal)
    {
        $this->load->database();
        $data= $this->db->get($jadwal)->result();
        return $data;
    }

    function pemesan($tiket)
    {
        $this->load->database();
        $data= $this->db->get($tiket)->result();
        return $data;
    }
    function detail($id){
            $this->load->database();
            $data = $this->db->get_where('film', array('id_film'=>$id));
            return $data->result_array();
        }

    public function hapuspemesan($id)
    {
        $this->load->database();
        $this->db->delete('tiket',array('id_pemesan' => $id));
        return;
    }

    public function hapus($id)
    {
        $this->load->database();
        $this->db->delete('film',array('id_film' => $id));
        return;
    }

    public function hapusjdl($id)
    {
        $this->load->database();
        $this->db->delete('jadwal',array('id_jadwal' => $id));
        return;
    }

    function tambah(){

        $this->load->database();
        $data = array('nama_film' => $this->input->post('nfilm'),
                    'screenshoot' => $this->input->post('screenshoot'),
                    'sinopsis' => $this->input->post('sinopsis'),
                    'jenis_film' => $this->input->post('jfilm'),
                    'sutradara' => $this->input->post('sutradara')

                    );


        $tambah = $this->db->insert('film',$data);
        return $tambah;
    }


    function tambahjdl(){
        $this->load->database();
        $data = array('nama_film' => $this->input->post('nfilm'),
                    'jam' => $this->input->post('jam'),
                    'jadwal' => $this->input->post('jadwal'),
                    'tempat' => $this->input->post('tempat'),
                    'teather' => $this->input->post('teather')
                    );

        $tambahjdl = $this->db->insert('jadwal',$data);
        return $tambahjdl;
    }

    function editdata(){
            $this->load->database();
            $nama_film = $this->uri->segment(3);
            $edit1 = $this->db->query("SELECT * FROM film WHERE id_film= '$nama_film'")->result();
            return $edit1;

        }
    function edit(){
            $this->load->database();
            $data = array('nama_film' => $this->input->post('nfilm'),
                            'sinopsis' => $this->input->post('sinopsis'),
                        'jenis_film' => $this->input->post('jfilm'),
                        'sutradara' => $this->input->post('sutradara')
                        );

            $this->db->WHERE('id_film',$this->input->post('id'));
            $edit4 = $this->db->update('film',$data);
            return $edit4;


        }


    function editdatajdl(){
            $this->load->database();
            $nama_film = $this->uri->segment(3);
            $edit2 = $this->db->query("SELECT * FROM jadwal WHERE id_jadwal= '$nama_film'")->result();
            return $edit2;

        }
    function editjdl(){
            $this->load->database();
            $data = array('nama_film' => $this->input->post('nfilm'),
                        'jam' => $this->input->post('jam'),
                        'jadwal' => $this->input->post('jadwal'),
                        'tempat' => $this->input->post('tempat'),
                        'teather' => $this->input->post('teather')
                        );

            $this->db->WHERE('id_jadwal',$this->input->post('id'));
            $edit4 = $this->db->update('jadwal',$data);
            return $edit4;


        }

    function tiket(){
        $this->load->database();
        $data = array('nama_pemesan' => $this->input->post('npemesan'),
                    'nama_film' => $this->input->post('nfilm'),
                    'no_bangku' => $this->input->post('no_bangku'),
                    'email' => $this->input->post('email'),
                    'jml_tkt' => $this->input->post('jumlh'),
                    'telpon' => $this->input->post('no.telp'),
                    'teather' => $this->input->post('teather')
                    );

        $pesan = $this->db->insert('tiket',$data);
        return $pesan;
    }
}
?>

dan di view
<html>
    <head>
        <title>Bioskop24</title>
        <link rel="stylesheet" type="text/css" href="http://localhost/bioskop24/assets/jquery.mobile-1.3.2.min.css" />
        <link rel="stylesheet" type="text/css" href="http://localhost/bioskop24/css/gaya.css" />
        <link rel="stylesheet" type="text/css" href="http://localhost/bioskop24/css/css.css" />
<script src="http://localhost/bioskop24/assets/jquery.js"></script>
<script src="http://localhost/bioskop24/assets/jquery.mobile-1.3.2.min.js"></script>
<script language="JavaScript" src="http://localhost/bioskop24/assets/ts_picker.js">

</script>
    </head>
    <body>

    <div data-role="page" id="jadwal" class="bg">
<div data-role="header"><img src="http://localhost/bioskop24/gambar/h.jpg"></img>

<span class="open left" class="title"><a href="#panel-01"></a></span>
           <span class="title">MENU</span>
            


</div>
<div data-role="content" >

<div class="panel left" data-role="panel" data-position="left" data-display="overlay" id="panel-01">
            <ul>
                <li class="newsfeed"><a href="<?php echo base_url();?>index.php/bioskop/" title="Home">HOME</a></li>
                <li class="profile"><a href="<?php echo base_url();?>index.php/bioskop/film/" title="film">MOVIE</a></li>
                <li class="setting"><a href="<?php echo base_url();?>index.php/bioskop/jadwal/" title="Jadwal">JADWAL</a></li>
                <li class="setting"><a href="<?php echo base_url();?>index.php/bioskop/pemesan/" title="Setting">PESANAN TIKET</a></li>
                 <li class="logout"><a href="<?php echo base_url();?>index.php/bioskop/logout" title="Logout">LOGOUT</a></li>

            </ul>
        </div>


            <table data-role="table" id="movie-table" data-mode="reflow" class="ui-responsive table-stroke">
                <thead>
                    <tr>
                    <th colspan='7'>JADWAL
                    
                    <a href="#popupTambah" data-rel="popup" data-position-to="window" data-role="button" data-inline="true" data-icon="plus" data-iconpos="notext" data-theme="b" data-transition="pop">TAMBAH FILM</a>
<div data-role="popup" id="popupTambah" data-overlay-theme="b" data-theme="a" class="ui-corner-all">
    <form class="form-horizontal" name="tstest" action='<?php echo base_url();?>index.php/bioskop/tambahjdl' method='post' enctype="multipart/form-data" data-ajax="false">
        <div style="padding:10px 20px;">
            <h3>TAMBAH JADWAL</h3>
            <label for="nf" class="ui-hidden-accessible">Nama Film:</label>
            <input name="nfilm" id="nf" value="" placeholder="Nama Film" data-theme="a" type="text">

            <label for="pk" class="ui-hidden-accessible">Pukul:</label>
            <input name="jam" id="pkl" value="" placeholder="Pukul" data-theme="a" type="text">

            <label for="jdwll" class="ui-hidden-accessible">Jadwal:</label>
            <input name="jadwal" id="jdwll" value="" placeholder="Jadwal" data-theme="a" type="text">
            <a href="javascript:show_calendar('document.tstest.jadwal', document.tstest.jadwal.value);"><img src="http://localhost/bioskop24/assets/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the timestamp"></a>

            <label for="tmp" class="ui-hidden-accessible">Tempat:</label>
            <input name="tempat" id="tmp" value="" placeholder="Tempat" data-theme="a">

            <label for="kt" class="ui-hidden-accessible">Teather:</label>
            <input name="teather" id="kt" value="" placeholder="Teather" data-theme="a" type="text">

            <button type="submit" data-theme="b" data-icon="check">save</button>
        </div>
    </form>
</div>
    
                </tr>
                <tr>
                    <th data-priority="1" >No</th>
                    <th data-priority="persist" >Nama Film</th>
                    <th data-priority="2" >Pukul</th>
                    <th data-priority="3" >Jadwal Film</th>
                    <th data-priority="4" >Tempat</th>
                    <th data-priority="5" >Teather</th>
                    <th data-priority="6" >Aksi</th>


                </tr>
                </thead>
                <tbody>
                <?php
                $no = 1;
                foreach($data as $row)
                {
            ?>
                <tr>
                    <td align='center' ><?php echo $no;?></td>
                    <td ><?php echo $row->nama_film;?></td>
                    <td ><?php echo $row->jam;?></td>
                    <td ><?php echo $row->jadwal;?></td>
                    <td ><?php echo $row->tempat;?></td>
                    <td ><?php echo $row->teather;?></td>
                    <td >
                        
                        <a href="#popupEdit<?php echo $row->id_jadwal;?>" data-rel="popup" data-position-to="window" data-role="button" data-inline="true" data-icon="edit" data-iconpos="notext" data-theme="b" data-transition="pop">EDIT FILM</a>
                    <div data-role="popup" data-overlay-theme="b" id="popupEdit<?php echo $row->id_jadwal;?>" data-theme="a" class="ui-corner-all">
                <form class="form-horizontal" action='<?php echo base_url();?>index.php/bioskop/editjdl' method='post' enctype="multipart/form-data" data-ajax="false">
                <div style="padding:10px 20px;">
            <h3>EDIT JADWAL</h3>
            <label for="nf" >Nama Film:</label>
            <input name="nfilm" id="nf" value='<?php echo $row->nama_film; ?>' data-theme="a" type="text">
            <input type='hidden' name='id' readonly value='<?php echo $row->id_jadwal; ?>'>

            <label for="pkl">Pukul:</label>
            <input name="jam" id="pkl" value='<?php echo $row->jam; ?>' type="text">

            <label for="jdll">Jadwal:</label>
            <input name="jadwal" id="jdll" value='<?php echo $row->jadwal; ?>' data-theme="a" type="text">
            <a href="javascript:show_calendar('document.tstest.jadwal', document.tstest.jadwal.value);"><img src="http://localhost/bioskop24/assets/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the timestamp"></a>

            <label for="tmp">Tempat:</label>
            <input name="tempat" id="tmp" value='<?php echo $row->tempat; ?>' data-theme="a" type="text">

            <label for="t">Teather:</label>
            <input name="teather" id="t" value='<?php echo $row->teather; ?>' data-theme="a" type="text">

            <button type="submit" data-theme="b" data-icon="check">save</button>

                </div>
            </form>
            </div>
                    

                        <a href= "<?php echo base_url();?>index.php/bioskop/hapusjdl/<?php echo $row->id_jadwal;?>" data-position-to="window" data-role="button" data-theme="b" data-icon="delete" data-iconpos="notext" class="ui-btn-right">Hapus</a></td>


                </tr>
                <?php
                $no++;
                }
                ?>
                </thead>
            </table>

            </div>
            </div>
        <div data-role="footer" data-position="fixed" data-theme="b">

        <p align="right">@Dede_mardi | 24Bioskop</p>

        </div>
</div>
    </body>
</html>

Catatanku

Senin, 10 Februari 2014

memanggil database dengan codeigniter