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)

Monday, February 5, 2018

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>










3 comments:

  1. Led lighting SydneyGlance complicated in order to much added in pleasant from you!

    ReplyDelete
  2. June Florist Pte Ltd is recognized as a pioneer in Singapore’s floristry industry. We are specialists in large scale floral arrangements for special events without focus on wedding and banquet decorations, hand bouquet delivery decorations for conferences as well as exhibitions.

    Florist Singapore
    Flower Delivery Singapore

    ReplyDelete
  3. June Florist is best florist singapore, June Florist Pte ltd is Same Day Flower Delivery Shop Singapore. our products hand bouquets, Flower box, Congratulation Flowers, Condolence Flowers and Table Flower Arrangement

    Florist Singapore
    Flower Delivery Singapore

    ReplyDelete

More Posts

FOLLOW