Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /*-------------------------------cara setting---------------------- */
- ?>
- 1.buka folder application/config/config.php
- 1.2 isi base_url jadi http://localhost/nama_folder_kamu/ dan jika menggunakan .htacces index_page dikosongkan
- 1.3 isi encryption dengan kata bebas
- 2.buka folder application/config/autoload.php
- 2.1 isi libraries dengan 'database','session'
- 2.2 isi helper dengan 'url','form'
- 3.buka folder application/config/router.php
- 3.1 isi default_controller dengan controller yang ingin pertama kali kamu munculkan
- 4.buka folder application/config/database.php
- 4.1 isikan username dengan kata root
- 4.2 isikan nama database dengan database yang kamu buat
- 5. Selesai sekarang mulai coding
- <?php
- /*-------------------------------.htacces---------------------- */
- RewriteEngine On
- RewriteBase /nama_folder_kamu/
- RewriteCond %{REQUEST_FILENAME} !-f
- RewriteCond %{REQUEST_FILENAME} !-d
- RewriteRule ^ index.php [NC,L]
- /*-------------------------------login---------------------- */
- //controller
- public function nama_function(){
- $user=$this->input->post('user');
- $pass=$this->input->post('password');
- if($this->nama_model->nama_function($user,$pass)==true){
- redirect(base_url(''));
- }else{
- redirect(base_url(''));
- }
- }
- //MODEL
- public function nama_function($user,$pass){
- $cek=$this->db->where(array('user'=>$user,'password',$pass))->get('nama_table');
- if($cek->num_rows() > 0){
- $row=$cek->row();
- $session=array('user'=>$row->user,'password'=>$row->password);
- $this->session->set_userdata($session);
- return true;
- }else{
- return false;
- }
- }
- /*-------------------------------Read & Pagging---------------------- */
- //controller
- public function nama_function($id){
- $data['row']=$this->nama_model->nama_function($id);
- $data['pagging']=$this->nama_model->nama_function();
- $this->load->view('nama_view',$data);
- }
- //model
- public function nama_function($id){
- $batas=1;
- $posisi=null;
- if(empty($id)){
- $posisi=0;
- $id=1;
- }else{
- $posisi=($id-1)* $batas;
- }
- $query=$this->db->query("SELECT * FROM nama_table order by kode DESC LIMIT $posisi,$batas");
- return $query->result();
- }
- public function nama_function_pagging(){
- $query=$this->db->query("SELECT * FROM nama_table order by kode DESC");
- return $query;
- }
- //view
- //munculkan data
- foreach($row as $i){
- echo $i->nama_field;
- }
- //pagging
- $batas=1;
- $jumlah_data=$count->num_rows();
- $jumlah_halaman= ceil($jumlah_data / $batas);
- for($i=1; $i <= $jumlah_halaman; $i++){
- if($i != $halaman && $i == $id){
- echo "<a style='border-left:3px solid #45A3AF; padding: 4px 10px; margin:0px 5px; background:#fff; color: black;' href='".base_url()."nama_controller/nama_function/".$i."'>".$i."</a>";
- }elseif($i != $halaman){
- echo "<a style='border-left:3px solid #45A3AF; padding: 4px 10px; margin:0px 5px; background:#fff;' href='".base_url()."nama_controller/nama_function/".$i."'>".$i."</a>";
- }else{
- echo "<b>".$i."</b>";
- }
- }
- /*-------------------------------Tambah Data---------------------- */
- //controller
- public function nama_function(){
- $data['form_action']='nama_controller/nama_function_proses';
- $this->load->view('nama_view',$data);
- }
- public function nama_function_proses(){
- $data=array('nama_filed'=>$this->input->post(''));
- $this->nama_model->nama_function($data);
- redirect(base_url(''));
- }
- //model
- public function nama_function($data){
- $this->db->insert('nama_table',$data);
- }
- //view
- ?>
- <form action="<?php echo $form_action;?>" method="POST" >
- <input type="text" name="nama_field" required/>
- <input type="submit" name="kirim" value="kirim">
- </form>
- <?php
- /*-------------------------------Edit Data---------------------- */
- //contoh klik tombol edit
- ?>
- <a href="<?php site_url('nama_controller/nama_function'.$i->id)?>">EDIT</a>
- <?php
- //controller
- public function nama_function($id){
- $data_model=$this->nama_model->nama_function_ambil_data($id);
- $data['default']['nama_field']=$data_model->nama_field;
- $data['form_action']='nama_controller/nama_function_proses'.$id.'';
- $this->load->view('nama_view',$data);
- }
- public function nama_function_proses($id){
- $data=array('nama_field' => $nama_filed_post, );
- $this->nama_model->nama_function($data,$id);
- redirect(base_url(''));
- }
- //model
- public function nama_function_ambil_data($id){
- return $this->db->get_where('nama_table', array('id' => $id),1)->row();
- }
- public function nama_function($data,$id){
- $this->db->where('id',$id);
- $this->db->update('nama_table',$data);
- }
- //view
- ?>
- <?php echo form_hidden('id',isset($default['id']) ? $default['id']:'');?>
- <form action="<?php echo $form_action;?>" method="POST" >
- <input type="text" name="nama_field" value="<?php echo isset($default['nama_field'])? $default['nama_field']:''; ?>"required/>
- <input type="submit" name="kirim" value="Update">
- </form>
- <?php
- /*-------------------------------Delete Data---------------------- */
- //contoh klik delete
- ?>
- <a href="<?php site_url('nama_controller/nama_function'.$i->id)?>">DELETE</a>
- <?php
- //controller
- public function nama_function($id){
- $this->nama_model->nama_function($id);
- redirect(base_url(''));
- }
- //model
- public function nama_function($id){
- $this->db->query("DELETE FROM nama_table WHERE id=$id");
- }
- /*-------------------------------Upload & EDIT Gambar---------------------- */
- //Upload Gambar
- $config['upload_path'] = "./foleder/";
- $config['allowed_types'] = 'gif|jpg|png|jpeg';
- $config['max_size'] = '2000';
- $config['max_width'] = '2000';
- $config['max_height'] = '2000';
- $this->load->library('upload', $config);
- if ($this->upload->do_upload("nama_post")) {
- $data = $this->upload->data();
- $source = "./folder/".$data['file_name'] ;
- $nama=$data['file_name'] ;
- chmod($source, 0777) ;
- $this->load->library('image_lib') ;
- $img['image_library'] = 'GD2';
- $img['create_thumb'] = TRUE;
- $img['maintain_ratio']= TRUE;
- //contoh Edit Gambar
- $config['upload_path'] = "./folder";
- $config['allowed_types'] = 'gif|jpg|png|jpeg';
- $config['max_size'] = '2000';
- $config['remove_spaces'] = true;
- $config['encrypt_name'] = false;
- $config['max_width'] = '2000';
- $config['max_height'] = '2000';
- $this->load->library('upload', $config);
- if($this->upload->do_upload('foto')==null){
- $data = array(
- "nama_field" =>$this->input->post('nama_post'),
- );
- $this->m_Backend->edit_user($data,$id);
- redirect(site_url('Backend/user'));
- }else{
- if(!$this->upload->do_upload('foto')){
- }else{
- $uploaded=$this->upload->data();
- $data = array(
- "nama_field" =>$this->input->post('nama_post'),
- "foto" =>$uploaded['file_name'],
- );
- //
- /*-------------------------------Script Export Excel or PDF or World---------------------- */
- header("Content-type: application/octet-stream");
- header("Content-Disposition: attachment; filename=nama_file.xls");
- header("Pragma: no-cache");
- header("Expires: 0");
- /*-------------------------------Lain-Lain---------------------- */
- ?>
- Untuk mengambil id_autoincrement menggunakan
- <?php mysql_insert_id() ?>
- untuk multiple upload menggunakan
- <!--view-->
- <form action="" method="POST" enctype="multipart/form-data">
- <input type="file" name="foto[]" multiple required/>
- <input type="submit" name="kirim" value="kirim"/>
- </form>
- <!--Controller-->
- <?php
- foreach (foreach($_FILES['foto']['tmp_name'] as $key => $tmp_name ){
- $file_name = $_FILES['nama_gambar']['name'][$key];
- $file_tmp =$_FILES['nama_gambar']['tmp_name'][$key];
- //script upload gambar
- //dan script tambah
- }
- ?>
- <!--Model-->
- Seperti contoh di atas
- <script>
- function printDiv(divName){
- var printContents = document.getElementById(divName).innerHTML;
- var originalContents = document.body.innerHTML;
- document.body.innerHTML = printContents;
- window.print();
- document.body.innerHTML = originalContents;
- }
- </script>
- <div id="printableArea">
- </div>
- <input onclick="printDiv('printableArea')" style="border:none;color:white;margin-bottom:20px;margin-top:10px;
- border-radius:2px;background:#006044;height:30px;width:120px;font-size:12px" type="submit" value="Cetak Data"></input>
Advertisement
Add Comment
Please, Sign In to add comment