How to fetch data in CodeIgniter

In previous tutorial we learned how to insert data into data in CodeIgniter. In this tutorial we will learn how to fetch data from database in CodeIgniter.
1.Create a model(Read_data_Model.php) inside application/mode

Class Read_data_Model extends CI_Model{
public function readdata(){
		        return $query->result();

2.Create a controller(Read_data.php) inside application/controller

Class Read_data extends CI_Controller{
public function index(){
//load model
//load model function
//loading view with passing result array

3. Create a view (read_data.php)  inside application/view

<table class="table table-responsive">
<th>Email id</th>
<th> Mobile Number</th>
<th> Gender</th>
<th> Address</th>
<th> Terms and Conditions</th>
<th>Posting date</th>
if(count($result)) {
foreach ($result as $row){
<td><?php echo htmlentities($cnt);?></td>
<td><?php echo htmlentities($row->fullName)?></td>
<td><?php echo htmlentities($row->emailId)?></td>
<td><?php echo htmlentities($row->mobileNumber)?></td>
<td><?php echo htmlentities($row->gender)?></td>
<td><?php echo htmlentities($row->address)?></td>
<td><?php echo htmlentities($row->address)?></td>
<td><?php echo htmlentities($row->postingDate)?></td>
} // end foreach
} else { ?>
<td colspan="7">No Record found</td>


How to run this script

  1. Download the zip file .
  2. Extract the zip and copy registrationci folder
  3. Paste in root directory(For xampp htdocs and for wamp www)
  4. Open your browser put http://localhost/phpmyadmin
  5. Create a database cidb
  6. Import sql file tblusers.sql
  7. Run your script http://localhost/registrationci

How to fetch data in CodeIgniter (Download Script)
Size: 2.75 MB
Version: V 1

Recommended Tutorials for you


Anuj kumar

This is Anuj Kumar. I’m a professional web developer with 5+ years of experience. I write blogs in my free time. I love to learn new technologies and share with others. I founded PHPGurukul in September 2015. The main aim of this website to provide PHP, Jquery, MySQL, PHP Oops and other web development tutorials. .


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back to top button