tegarkurniawan

Tutorial by Tegar

Feb 1st, 2015
311
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.38 KB | None | 0 0
  1. <?php
  2. /*-------------------------------cara setting---------------------- */
  3. ?>
  4. 1.buka folder application/config/config.php
  5. 1.2 isi base_url jadi http://localhost/nama_folder_kamu/ dan jika menggunakan .htacces index_page dikosongkan
  6. 1.3 isi encryption dengan kata bebas
  7. 2.buka folder application/config/autoload.php
  8. 2.1 isi libraries dengan 'database','session'
  9. 2.2 isi helper dengan 'url','form'
  10. 3.buka folder application/config/router.php
  11. 3.1 isi default_controller dengan controller yang ingin pertama kali kamu munculkan
  12. 4.buka folder application/config/database.php
  13. 4.1 isikan username dengan kata root
  14. 4.2 isikan nama database dengan database yang kamu buat
  15. 5. Selesai sekarang mulai coding
  16. <?php
  17. /*-------------------------------.htacces---------------------- */
  18. RewriteEngine On
  19. RewriteBase /nama_folder_kamu/
  20. RewriteCond %{REQUEST_FILENAME} !-f
  21. RewriteCond %{REQUEST_FILENAME} !-d
  22. RewriteRule ^ index.php [NC,L]
  23. /*-------------------------------login---------------------- */
  24.  
  25. //controller
  26. public function nama_function(){
  27. $user=$this->input->post('user');
  28. $pass=$this->input->post('password');
  29. if($this->nama_model->nama_function($user,$pass)==true){
  30. redirect(base_url(''));
  31. }else{
  32. redirect(base_url(''));
  33. }
  34. }
  35.  
  36. //MODEL
  37. public function nama_function($user,$pass){
  38. $cek=$this->db->where(array('user'=>$user,'password',$pass))->get('nama_table');
  39. if($cek->num_rows() > 0){
  40. $row=$cek->row();
  41. $session=array('user'=>$row->user,'password'=>$row->password);
  42. $this->session->set_userdata($session);
  43. return true;
  44. }else{
  45. return false;
  46. }
  47. }
  48.  
  49. /*-------------------------------Read & Pagging---------------------- */
  50.  
  51. //controller
  52.  
  53. public function nama_function($id){
  54. $data['row']=$this->nama_model->nama_function($id);
  55. $data['pagging']=$this->nama_model->nama_function();
  56. $this->load->view('nama_view',$data);
  57. }
  58. //model
  59. public function nama_function($id){
  60. $batas=1;
  61. $posisi=null;
  62. if(empty($id)){
  63. $posisi=0;
  64. $id=1;
  65. }else{
  66. $posisi=($id-1)* $batas;
  67. }
  68. $query=$this->db->query("SELECT * FROM nama_table order by kode DESC LIMIT $posisi,$batas");
  69. return $query->result();
  70. }
  71. public function nama_function_pagging(){
  72. $query=$this->db->query("SELECT * FROM nama_table order by kode DESC");
  73. return $query;
  74. }
  75. //view
  76. //munculkan data
  77. foreach($row as $i){
  78. echo $i->nama_field;
  79. }
  80. //pagging
  81. $batas=1;
  82.  
  83.  
  84. $jumlah_data=$count->num_rows();
  85.  
  86. $jumlah_halaman= ceil($jumlah_data / $batas);
  87. for($i=1; $i <= $jumlah_halaman; $i++){
  88. if($i != $halaman && $i == $id){
  89. 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>";
  90. }elseif($i != $halaman){
  91. 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>";
  92. }else{
  93. echo "<b>".$i."</b>";
  94. }
  95. }
  96.  
  97. /*-------------------------------Tambah Data---------------------- */
  98.  
  99. //controller
  100. public function nama_function(){
  101. $data['form_action']='nama_controller/nama_function_proses';
  102. $this->load->view('nama_view',$data);
  103. }
  104. public function nama_function_proses(){
  105. $data=array('nama_filed'=>$this->input->post(''));
  106. $this->nama_model->nama_function($data);
  107. redirect(base_url(''));
  108. }
  109. //model
  110. public function nama_function($data){
  111. $this->db->insert('nama_table',$data);
  112. }
  113. //view
  114. ?>
  115. <form action="<?php echo $form_action;?>" method="POST" >
  116. <input type="text" name="nama_field" required/>
  117. <input type="submit" name="kirim" value="kirim">
  118. </form>
  119. <?php
  120.  
  121.  
  122.  
  123. /*-------------------------------Edit Data---------------------- */
  124.  
  125. //contoh klik tombol edit
  126.  
  127. ?>
  128. <a href="<?php site_url('nama_controller/nama_function'.$i->id)?>">EDIT</a>
  129. <?php
  130. //controller
  131. public function nama_function($id){
  132. $data_model=$this->nama_model->nama_function_ambil_data($id);
  133. $data['default']['nama_field']=$data_model->nama_field;
  134. $data['form_action']='nama_controller/nama_function_proses'.$id.'';
  135. $this->load->view('nama_view',$data);
  136. }
  137. public function nama_function_proses($id){
  138. $data=array('nama_field' => $nama_filed_post, );
  139. $this->nama_model->nama_function($data,$id);
  140. redirect(base_url(''));
  141. }
  142. //model
  143. public function nama_function_ambil_data($id){
  144. return $this->db->get_where('nama_table', array('id' => $id),1)->row();
  145. }
  146. public function nama_function($data,$id){
  147. $this->db->where('id',$id);
  148. $this->db->update('nama_table',$data);
  149. }
  150. //view
  151. ?>
  152. <?php echo form_hidden('id',isset($default['id']) ? $default['id']:'');?>
  153. <form action="<?php echo $form_action;?>" method="POST" >
  154. <input type="text" name="nama_field" value="<?php echo isset($default['nama_field'])? $default['nama_field']:''; ?>"required/>
  155. <input type="submit" name="kirim" value="Update">
  156. </form>
  157.  
  158. <?php
  159.  
  160.  
  161. /*-------------------------------Delete Data---------------------- */
  162.  
  163. //contoh klik delete
  164. ?>
  165. <a href="<?php site_url('nama_controller/nama_function'.$i->id)?>">DELETE</a>
  166. <?php
  167. //controller
  168. public function nama_function($id){
  169. $this->nama_model->nama_function($id);
  170. redirect(base_url(''));
  171. }
  172. //model
  173. public function nama_function($id){
  174. $this->db->query("DELETE FROM nama_table WHERE id=$id");
  175. }
  176.  
  177.  
  178.  
  179.  
  180. /*-------------------------------Upload & EDIT Gambar---------------------- */
  181.  
  182.  
  183. //Upload Gambar
  184. $config['upload_path'] = "./foleder/";
  185. $config['allowed_types'] = 'gif|jpg|png|jpeg';
  186. $config['max_size'] = '2000';
  187. $config['max_width'] = '2000';
  188. $config['max_height'] = '2000';
  189. $this->load->library('upload', $config);
  190.  
  191. if ($this->upload->do_upload("nama_post")) {
  192. $data = $this->upload->data();
  193.  
  194. $source = "./folder/".$data['file_name'] ;
  195. $nama=$data['file_name'] ;
  196.  
  197.  
  198.  
  199. chmod($source, 0777) ;
  200.  
  201.  
  202. $this->load->library('image_lib') ;
  203. $img['image_library'] = 'GD2';
  204. $img['create_thumb'] = TRUE;
  205. $img['maintain_ratio']= TRUE;
  206.  
  207.  
  208.  
  209. //contoh Edit Gambar
  210. $config['upload_path'] = "./folder";
  211. $config['allowed_types'] = 'gif|jpg|png|jpeg';
  212. $config['max_size'] = '2000';
  213. $config['remove_spaces'] = true;
  214. $config['encrypt_name'] = false;
  215. $config['max_width'] = '2000';
  216. $config['max_height'] = '2000';
  217.  
  218. $this->load->library('upload', $config);
  219. if($this->upload->do_upload('foto')==null){
  220. $data = array(
  221. "nama_field" =>$this->input->post('nama_post'),
  222. );
  223. $this->m_Backend->edit_user($data,$id);
  224. redirect(site_url('Backend/user'));
  225. }else{
  226. if(!$this->upload->do_upload('foto')){
  227. }else{
  228. $uploaded=$this->upload->data();
  229. $data = array(
  230. "nama_field" =>$this->input->post('nama_post'),
  231.  
  232. "foto" =>$uploaded['file_name'],
  233. );
  234.  
  235. //
  236.  
  237. /*-------------------------------Script Export Excel or PDF or World---------------------- */
  238. header("Content-type: application/octet-stream");
  239. header("Content-Disposition: attachment; filename=nama_file.xls");
  240. header("Pragma: no-cache");
  241. header("Expires: 0");
  242.  
  243. /*-------------------------------Lain-Lain---------------------- */
  244. ?>
  245. Untuk mengambil id_autoincrement menggunakan
  246. <?php mysql_insert_id() ?>
  247. untuk multiple upload menggunakan
  248. <!--view-->
  249. <form action="" method="POST" enctype="multipart/form-data">
  250. <input type="file" name="foto[]" multiple required/>
  251. <input type="submit" name="kirim" value="kirim"/>
  252. </form>
  253. <!--Controller-->
  254. <?php
  255. foreach (foreach($_FILES['foto']['tmp_name'] as $key => $tmp_name ){
  256. $file_name = $_FILES['nama_gambar']['name'][$key];
  257. $file_tmp =$_FILES['nama_gambar']['tmp_name'][$key];
  258. //script upload gambar
  259. //dan script tambah
  260. }
  261.  
  262. ?>
  263. <!--Model-->
  264. Seperti contoh di atas
  265.  
  266.  
  267. <script>
  268. function printDiv(divName){
  269. var printContents = document.getElementById(divName).innerHTML;
  270. var originalContents = document.body.innerHTML;
  271. document.body.innerHTML = printContents;
  272. window.print();
  273. document.body.innerHTML = originalContents;
  274. }
  275. </script>
  276. <div id="printableArea">
  277. </div>
  278. <input onclick="printDiv('printableArea')" style="border:none;color:white;margin-bottom:20px;margin-top:10px;
  279. 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