Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Karena terlalu panjang singkat saja sampai dari k15 manjadi k5
- --------------------------------- Start Controller ----------------------------------
- <?php
- var $modul = 'transparansikeuangan';
- function index($kodeprov = NULL)
- {
- $data['kodeprov'] = $kodeprov;
- if(isset($kodeprov) && is_numeric($kodeprov))
- {
- $this->db->order_by("id_transparansikeuangan", "asc");
- $get = $this->db->get_where("tbl_transparansikeuangan", array('kodeprov' => $kodeprov));
- $data['tampil'] = $get;
- $data['totalrow'] = $get->num_rows();
- }else{
- $this->db->order_by("id_transparansikeuangan", "asc");
- $get = $this->db->get_where("tbl_transparansikeuangan", array('kodeprov' => '1'));
- $data['tampil'] = $get;
- $data['totalrow'] = $get->num_rows();
- }
- $data['form_action'] = site_url('admin/transparansikeuangan/update');
- $data['main_content'] = $this->modul.'/transparansikeuangan';
- $this->load->view('core_theme', $data);
- }
- /*
- yang dibuat mas Gunawan Mujur Wibisono
- */
- function update()
- {
- $count = $this->input->post("totalrow");
- $data=array();
- for($i=1; $i<=$count; $i++)
- {
- $data = array(
- 'id_transparansikeuangan' => $_POST['id_transparansikeuangan'][$i],
- 'namakab' => $_POST['namakab'][$i],
- 'k2' => $_POST['k2'][$i],
- 'k3' => $_POST['k3'][$i],
- 'k4' => $_POST['k4'][$i],
- 'k5' => $_POST['k5'][$i]
- );
- $cari=array('id_transparansikeuangan'=>$_POST['id_transparansikeuangan'][$i]);
- $this->db->update ('tbl_transparansikeuangan',$data, $cari);
- //$this->db->update('mytable', $data, array('id' => $id));
- }
- //$this->db->update_batch('tbl_transparansikeuangan',$data, 'id_transparansikeuangan');
- }
- ------------------------------------ End Controller ----------------------------------
- Dan saya mempunyai view seperti ini
- ------------------------------------ Start View --------------------------------
- <form action="<?php echo $form_action; ?>" method="post">
- <?php echo form_hidden('totalrow', isset($totalrow) ? $totalrow : ''); ?>
- <?php $no = 1; ?>
- <?php
- $i=1;
- $checked = 'checked="checked"';
- foreach ($tampil->result() as $row): ?>
- <tr>
- <?php echo form_hidden('id_transparansikeuangan['.$i.']', isset($row->id_transparansikeuangan) ? $row->id_transparansikeuangan : ''); ?>
- <td><?php echo $no++; ?></td>
- <td><input type="text" name="namakab[<?php echo $i ?>]" value="<?php echo set_value('namakab', isset($row->namakab) ? $row->namakab : ''); ?>" /></td>
- <td><input type="text" name="k2[<?php echo $i ?>]" value="<?php echo set_value('k2', isset($row->k2) ? $row->k2 : ''); ?>" /></td>
- <td><input type="checkbox" name="k3[<?php echo $i ?>]" value="1" <?php if(isset($row->k3) && $row->k3 == '1') echo $checked; ?> /></td>
- <td><input type="checkbox" name="k4[<?php echo $i ?>]" value="1" <?php if(isset($row->k4) && $row->k4 == '1') echo $checked; ?> /></td>
- <td><input type="checkbox" name="k5[<?php echo $i ?>]" value="1" <?php if(isset($row->k5) && $row->k5 == '1') echo $checked; ?> /></td>
- </tr>
- <?php
- $i++;
- endforeach;
- ?>
- -------------------------------------- End View ------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement