CodeIgniter Database select Record

by Online Tutorials Library July 14, 2022

CodeIgniter SELECT Database record

To fetch all data from database, one more page in Model folder of CodeIgniter will be created. There will be some changes in controller’s and view’s files also.

Controller file (Baby_form.php) is shown below.

  load->model(“Babymodel”, “a”); }  public function index() { $this->load->view(“baby_form_select”); } function savingdata() { //this array is used to get fetch data from the view page. $data = array( ‘name’     => $this->input->post(‘name’), ‘meaning’  => $this->input->post(‘meaning’), ‘gender’   => $this->input->post(‘gender’), ‘religion’ => $this->input->post(‘religion’) ); //insert data into database table. $this->db->insert(‘baby’,$data);  redirect(“baby_form/index”); } } ?> 

We have added a constructor to load the model page. Highlighted code is added to fetch the inserted record. And our view page is now baby_form_select.php

View file (baby_form_select.php) is shown below.

    <title>Baby Form Add</title>   
<form action="<?php%20echo%20site_url('baby_form/savingdata');%20?>" method="post">
<table>
<tr>
<td>Name:</td>
<td>:</td>
<td><input name="name" type="text"></td>
</tr>
<tr>
<td>Meaning:</td>
<td>:</td>
<td><input name="meaning" type="text"></td>
</tr>
<tr>
<td>Gender:</td>
<td>:</td>
<td><input name="gender" type="text"></td>
</tr>
<tr>
<td>Religion:</td>
<td>:</td>
<td><input name="religion" type="text"></td>
</tr>
<tr> <input name="submit" type="submit" value="Save"> </tr>
</table></form>
<table border="1">
<thead>
<th>ID</th>
<th>NAME</th>
<th>MEANING</th>
<th>GENDER</th>
<th>RELIGION</th>
<th>ACTION</th>
</thead>
<tbody> db->get(‘baby’); return $query->result(); } } ?>  
<p>In <strong>URL</strong>, type <strong>http://localhost/CodeIgniter/index.php/Baby_form</strong></p>
<p> <img decoding="async" alt="Codeigniter Select database record 4" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%200%200'%3E%3C/svg%3E" data-lazy-src="../wp-content/static/codeigniter/images/select-database-record4.png"><noscript><img decoding="async" alt="Codeigniter Select database record 4" src="../wp-content/static/codeigniter/images/select-database-record4.png"></noscript> </p>
<p>Look at the above snapshot, all data has been fetched from the table ‘baby’.</p>
<div class="download"> <a src="../wp-content/static/codeigniter/src/select.zip">download this example</a> </div>
<div class="nexttopicdiv"> <span class="nexttopictext">Next Topic</span><span class="nexttopiclink"><a href="../codeigniter-login-form">Login Form in CodeIgniter </a></span> </div>
<p>  </p>
</tbody></table>

CodeIgniter Database select Record

CodeIgniter SELECT Database record

Aneka in Cloud Computing

TreeMap in Java

You may also like