How to update data in a table using CodeIgniter?

This code gives you step by step explanation on how to update data in a table with CodeIgniter framework.
Model
Controller
View

Model
level.php
<?php
class Levels extends CI_Model {
public function selectdemodata_ind($id)
    {
$this->load->database();
$query = $this->db->get_where('demo', array('id =' => $id));
return $query;
    }

public function updatedemodata($data, $id)
    {
$this->load->database();
$this->db->where('id', $id);
$this->db->update('demo', $data);
echo 'Data Updated successfully';
$this->load->helper('url');
        redirect('/welcome/demodata');
    }
}
?>

Controller
welcome.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Welcome extends CI_Controller {

public function updatedemodata(){
$id = $_GET['id'];
$data_one['k'] = $this->levels->selectdemodata_ind($id);
$this->load->view('updatedemodata', $data_one);

$this->load->model('levels');
$name = $this->input->post('name');
$number= $this->input->post('number');
$data = array(
'name' => $name,
'number' => $number
);

if(isset($_POST['update'])) {
if ((name !== '')) {
$id = $_GET['id'];
$this->levels->updatedemodata($data, $id);
            } else {
echo 'Please fill fields';
            }
        }
    }
}
?>

View
updatedemodata.php
<html>
<head>
    <style>
        .container {
width: 200px;
height: 100px;
padding: 200px;

        }
label {
padding: 10px;
        }

        .btn {
float: right;
padding: 5px;
        }
    </style>
</head>

<?php foreach ($k->result() as $row) { ?>
<body class="container">
    <form method='POST'>
        <label>Name</label>
        <input type="text" name="name" 
value="<?php echo $row->name; ?>" ><br><br>
        <label>Number</label>
        <input type="text" name="number" 
value="<?php echo $row->number; ?>" >
        <input type="submit" class="btn" 
name="update" value="update">
    </form>
    </body>
<?php } ?>

</html>










1 comment:

  1. When I originally commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove me from that service? Thanks a lot! data security

    ReplyDelete

Labels

php (35) javascript (31) phpjavascript (30) jquery (23) html (20) mysql (14) database (9) codeigniter (4) json (4) bar chart (2) calendar (2) column chart (2) framework (2) google maps (2) query (2) tables (2) url (2) dropdown (1)

Popular Posts