Advertisement
GWibisono

tes1

Jun 26th, 2013
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.26 KB | None | 0 0
  1. Karena terlalu panjang singkat saja sampai dari k15 manjadi k5
  2. --------------------------------- Start Controller ----------------------------------
  3. <?php
  4. var $modul = 'transparansikeuangan';
  5. function index($kodeprov = NULL)
  6.     {
  7.         $data['kodeprov']     = $kodeprov; 
  8.         if(isset($kodeprov) && is_numeric($kodeprov))
  9.         {
  10.             $this->db->order_by("id_transparansikeuangan", "asc");
  11.             $get = $this->db->get_where("tbl_transparansikeuangan", array('kodeprov' => $kodeprov));
  12.             $data['tampil']   = $get;
  13.             $data['totalrow'] = $get->num_rows();
  14.         }else{
  15.             $this->db->order_by("id_transparansikeuangan", "asc");
  16.             $get = $this->db->get_where("tbl_transparansikeuangan", array('kodeprov' => '1'));
  17.             $data['tampil']   = $get;
  18.             $data['totalrow'] = $get->num_rows();
  19.         }
  20.         $data['form_action']  = site_url('admin/transparansikeuangan/update');
  21.         $data['main_content'] = $this->modul.'/transparansikeuangan';
  22.         $this->load->view('core_theme', $data);
  23.     }
  24.  
  25.  
  26. /*
  27. yang dibuat mas Gunawan Mujur Wibisono
  28. */
  29.  
  30. function update()
  31.     {
  32.         $count = $this->input->post("totalrow");
  33.         $data=array();
  34.         for($i=1; $i<=$count; $i++)
  35.         {
  36.                 $data = array(
  37.                 'id_transparansikeuangan' => $_POST['id_transparansikeuangan'][$i],
  38.                 'namakab' => $_POST['namakab'][$i],
  39.                 'k2' => $_POST['k2'][$i],
  40.                 'k3' => $_POST['k3'][$i],
  41.                 'k4' => $_POST['k4'][$i],
  42.                 'k5' => $_POST['k5'][$i]
  43.                 );
  44.                         $cari=array('id_transparansikeuangan'=>$_POST['id_transparansikeuangan'][$i]);
  45.             $this->db->update ('tbl_transparansikeuangan',$data, $cari);   
  46. //$this->db->update('mytable', $data, array('id' => $id));    
  47.         }
  48.         //$this->db->update_batch('tbl_transparansikeuangan',$data, 'id_transparansikeuangan');    
  49.     }
  50.  
  51. ------------------------------------ End Controller ----------------------------------
  52.  
  53.  
  54. Dan saya mempunyai view seperti ini
  55.  
  56. ------------------------------------ Start View --------------------------------
  57.       <form action="<?php echo $form_action; ?>" method="post">
  58.       <?php echo form_hidden('totalrow', isset($totalrow) ? $totalrow : ''); ?>
  59.       <?php $no = 1; ?>
  60.         <?php
  61.          $i=1;   
  62.          $checked   = 'checked="checked"';
  63.          foreach ($tampil->result() as $row): ?>
  64.         <tr>
  65.         <?php echo form_hidden('id_transparansikeuangan['.$i.']', isset($row->id_transparansikeuangan) ? $row->id_transparansikeuangan : ''); ?>
  66.           <td><?php echo $no++; ?></td>
  67.           <td><input type="text" name="namakab[<?php echo $i ?>]" value="<?php echo set_value('namakab', isset($row->namakab) ? $row->namakab : ''); ?>" /></td>
  68.           <td><input type="text" name="k2[<?php echo $i ?>]" value="<?php echo set_value('k2', isset($row->k2) ? $row->k2 : ''); ?>" /></td>
  69.           <td><input type="checkbox" name="k3[<?php echo $i ?>]" value="1"  <?php if(isset($row->k3) && $row->k3 == '1') echo $checked; ?> /></td>
  70.           <td><input type="checkbox" name="k4[<?php echo $i ?>]" value="1"  <?php if(isset($row->k4) && $row->k4 == '1') echo $checked; ?> /></td>
  71.           <td><input type="checkbox" name="k5[<?php echo $i ?>]" value="1"  <?php if(isset($row->k5) && $row->k5 == '1') echo $checked; ?> /></td>
  72.         </tr>
  73.        
  74.     <?php
  75.         $i++;
  76.         endforeach;
  77.     ?>
  78. -------------------------------------- End View ------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement