Crud in codeigniter

Crud in codeigniter

The acronym CRUD means Create, Read, Update, and Delete. Any application that uses persistent data must have CRUD operations. The CRUD is an important thing that developers keep in mind when building entirely usable application models.

A. Fetch:

<?php 

$keys = '';

$this->db->select('*');
$this->db->from('videos');
$this->db->where('id', $record->videoid );
$query = $this->db->get();

if ( $query->num_rows() > 0 )
{
$row = $query->row_array();
$keys = $row['video_key'];
} 

$result = $query->result(); 
if(!empty($result))
{

foreach($result as $record)
{
  $photo = unserialize($record->images);
}

}


?>

B. Insert:

home.php

<head>

<title>Form</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>                     <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.4/jquery.min.js"></script>
</head>

<br/>
<div class="container card">
<form class="cards" method="post" action="submitform" enctype="multipart/form-data">

<h3>Registration Form</h3>
<div class="form-group">
<label>Name:</label>
<input type="text" name="name" class="form-control" />
<span class="err"></span>
</div>

<div class="form-group">
<label>Email:</label>
<input type="email" name="email" class="form-control" />
<span class="err"></span>
</div>

<div class="form-group">
<label>Contact:</label>
<input type="text" name="contact" class="form-control" />
<span class="err"></span>
</div><br/>

<div class="form-group">
<button class="btn btn-primary">Submit</button>
</div>

</form>

</div>
controller.php

function submitform(){
$name = $_POST['name'];
$email = $_POST['email'];
$contact = $_POST['contact'];
echo $name;
}
controller.php ( Default calling controller )

function __construct(){
parent::__construct();
$this->load->model('WelcomeModel');
}

function submitform(){
$data['name'] = $this->input->post('name'); // name is the name of db column
$data['email'] = $this->input->post('email');
$data['contact'] = $this->input->post('contact');
$this->WelcomeModel->insert_data($data);
}
Goto system/config/autoload.php

$autoload['libraries'] = array('database');
// for using db inside model
model.php:

function insert_data($data){
$this->db->insert('student', $data); // ('tablename', $data)
OR
$this->db->query("INSERT INTO student(name, email, contact) VALUES($name, $email, $contact)");
}

C. Update:

controller.php:

function updateform(){
$data['name'] = $this->input->post('name');
$data['email'] = $this->input->post('email');
$data['contact'] = $this->input->post('contact');
$id = $this->input->post('id');
$this->WelcomeModel->update_data($id, $data);
}
model.php:

function update_data($id, $data){
$this->db->where('id', $id);
$this->db->update('student', $data);
}

 

 

 

Tags: , , , , , , , , , , , , , , , , ,

Leave a Reply