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
<?php
Class Read_data_Model extends CI_Model{
public function readdata(){
$query=$this->db->select('fullName,mobileNumber,emailId,gender,address,termsCondition,postingDate')
->get('tblusers');
return $query->result();
}
}
2.Create a controller(Read_data.php) inside application/controller
<?php
Class Read_data extends CI_Controller{
public function index(){
//load model
$this->load->model('Read_data_Model');
//load model function
$results=$this->Read_data_Model->readdata();
//loading view with passing result array
$this->load->view('read_data',['result'=>$results]);
}
}
Click Here : https://phpgurukul.com/how-to-fetch-data-in-codeigniter/
3. Create a view (read_data.php) inside application/view
<table class="table table-responsive">
<thead>
<tr>
<th>#</th>
<th>Name</th>
<th>Email id</th>
<th> Mobile Number</th>
<th> Gender</th>
<th> Address</th>
<th> Terms and Conditions</th>
<th>Posting date</th>
</tr>
</thead>
<tbody>
<?php
if(count($result)) {
$cnt=1;
foreach ($result as $row){
?>
<tr>
<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>
</tr>
<?php
$cnt++;
} // end foreach
} else { ?>
<tr>
<td colspan="7">No Record found</td>
</tr>
<?php
}
?>
</tbody>
</table>
View—————————————
How to run this script
- Download the zip file .
- Extract the zip and copy registrationci folder
- Paste in root directory(For xampp htdocs and for wamp www)
- Open your browser put http://localhost/phpmyadmin
- Create a database cidb
- Import sql file tblusers.sql
- Run your script http://localhost/registrationci
PHP Gurukul
Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.
Website : https://phpgurukul.com
While WordPress is a Content Management System that is used for creating lighter websites, CodeIgniter is core PHP framework preferred for developing extensive web applications.
It is an open source framework and is mainly preferred for designing small and medium scale websites and applications.
Suited for Java-script driven applications, it is also useful for designing PHP based apps as well.
Also, it can easily be configured and managed in order to meet specific web development requirements.
Accordingly you can check the problem with the code and rectify it easily
WordPress is an open source free content management system that provides the facility of creating and designing attractive websites for businesses and blogging.
PHP CodeIgniter developers can hassle freely migrate specific website from one server to another on the web.
Over the years, we have seen that it has become essential to choose the PHP framework when it comes to building custom solutions for the business.
There are a number of PHP frameworks available in the market, and two of the prominent ones from them are Laravel and CodeIgniter.
