MVC database Edit/update/delete
Controllers/EditDelete
<?php
class EditDelete extends CI_Controller {
public function index() {
$data = array(
"header" => "Result set of Users",
"data" => $this->db->get('users')->result()
);
$this->load->view('EditDeleteView', $data);
}
public function edit($id = "") {
$this->load->library('form_validation');
$data = array(
"header" => "Result set of User Edit",
"data" => $this->db->get_where('users', array('idu' => $id))
);
$this->load->view('EditView', $data);
}
public function update() {
/* $id = $this->input->post('id');
$data = array(
"username" => $this->input->post('username'),
"email" => $this->input->post('email')
);
$this->db->update('users', $data, array('idu' => $id));
*/
$this->load->library('form_validation');
$FormRules = array(
array(
'field' => 'username',
'label' => 'Username',
'rules' => 'required'
));
$this->form_validation->set_rules($FormRules);
if ($this->form_validation->run() == TRUE) {
echo "Success";
} else {
echo validation_errors();
}
}
}
Views/EditDeleteView
<table border="1">
<caption>
<th colspan="5"> <?php echo $header; ?></th>
</caption>
<tr>
<th>No</th>
<th>Username</th>
<th>Password</th>
<th>Email</th>
<th>Operation</th>
</tr>
<?php
$i = 1;
foreach ($data as $res) {
?>
<tr>
<td><?php echo $i++; ?></td>
<td><?php echo $res->username; ?></td>
<td><?php echo $res->password; ?></td>
<td><?php echo $res->email; ?></td>
<td><a href="<?php echo base_url('index.php/editdelete/edit/'.$res->idu); ?>">Edit</a> | Delete</td>
</tr>
<?php
}
?>
</table>
View/EditView
<html><head><script src="http://localhost/js/jquery.min.js" type="text/javascript"></script>
<script>
$(document).ready(function(){
$('form.jsForm').on('submit',function(form){
form.preventDefault();
$.post('editdelete/update',$('form.jsForm').serialize(),function(data){
console.log(data);
$('div.jsError').html(data);
});
});
});
</script>
</head>
<body>
<?php echo form_open('editdelete/update/', array('class' => 'jsForm')); ?>
<div class="jsError"></div>
<table border="0">
<?php
if ($data->num_rows() != 0) {
$row = $data->row();
?>
<tr>
<td>Username</td>
<input type="hidden" name="id" value="<?php echo $row->idu; ?>" >
<td><input type="text" value="<?php echo $row->username; ?>" name="username"></td>
</tr>
<tr>
<td>Password</td>
<td><!-- input type="text" value="<?php echo $row->password; ?>" name="password" --><?php echo $row->password; ?></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" value="<?php echo $row->email; ?>" name="email"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Save"></td>
</tr>
</tr>
<?php } ?>
</table>
<?php echo form_close(); ?>
</body>
</html>
Comments
Post a Comment