PHP JavaScript: 02/05/18

This block of code of will explains about how to delete data from table using CodeIgniter.
Which involves mainly three steps.

View
Controller
Model

View
demodata.php
<html>
<head>
<style>
.container {
width: 500px;
height: 100px;
padding: 200px;
}
table, th, td {
border: 1px solid black;
width:500px;
}
</style>
</head>
<body class="container">
<table>
<tr>
<th>ID</th>
<th>Name</th>
<th>Number</th>
<th>Update</th>
</tr>

<?php
foreach ($k->result() as $row) {
echo '<tr>';
echo '<td>' . $row->id . '</td>';
echo '<td>' . $row->name . '</td>';
echo '<td>' . $row->number . '</td>';
echo "<td><a href='updatedemodata?id=$row->id'>Update</a>
<a href='deletedemodata?id=$row->id'> / Delete</a></td>";
}
?>

</table>
</body>
</html>

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

class Welcome extends CI_Controller {
public function deletedemodata(){
if(isset($_GET['id'])) {
if (($_GET['id'] !== '')) {
$id = $_GET['id'];
$this->levels->deletedemodata($id);
} else {
echo 'error while deleting';
}
}
}
}
?>

Model
level.php
<?php
class Levels extends CI_Model
{
public function deletedemodata($id)
{
$this->load->database();
$this->db->where('id', $id);
$this->db->delete('demo');
echo 'Data Deleted successfully';
$this->load->helper('url');
redirect('/welcome/demodata');
}
}
?>

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>