How to display records using database in php using codeigniter framework ?

This tutorial is intended to introduce you to the CodeIgniter framework and the basic principles of MVC architecture. It will show you how a basic CodeIgniter application is constructed in step-by-step fashion.

Static pages

Note: This tutorial assumes you’ve downloaded CodeIgniter and installed the framework in your development environment.

The first thing you’re going to do is set up a controller to handle static pages. A controller is simply a class that helps delegate work. It is the glue of your web application.

For example, when a call is made to:

http://example.com/home/view/

We might imagine that there is a controller named “home”. The method being called on home would be “latest”. The home method’s job could be to grab 10 post items, and render them on the page. Very often in MVC, you’ll see URL patterns that match:

http://example.com/[controller-class]/[controller-method]/[arguments]

As URL schemes become more complex, this may change. But for now, this is all we will need to know.

I have a setup name as erp you can rename as per your project

Create a file at application/controllers/Home.php with the following code.

<?php

// First we created controller to call

class Home extends CI_Controller {

//Here we can call model and helper class

public function __construct()
{
parent::__construct();
$this->load->model('emp_model');
$this->load->helper('url_helper');
}

//default function

public function index() {

$page = 'home'; //page name we create /views/pages/home.php

$data['title'] = 'List of Employee'; //data to pass value

//here we make condition to get a value

if ( ! file_exists(APPPATH.'views/pages/'.$page.'.php'))
{
// Whoops, we don't have a page for that!
show_404();
}

//here we are getting a value from database

$data['employee'] = $this->emp_model->get_emp();

//we created header and footer.php

$this->load->view('templates/header', $data);
$this->load->view('pages/'.$page, $data);
$this->load->view('templates/footer');

}

public function view($page = 'home')
{

if ( ! file_exists(APPPATH.'views/pages/'.$page.'.php'))
{
// Whoops, we don't have a page for that!
show_404();
}

$data['title'] = ucfirst($page); // Capitalize the first letter

$this->load->view('templates/header', $data);
$this->load->view('pages/'.$page, $data);
$this->load->view('templates/footer', $data);

}
public function detail($page = 'detail')
{
echo "test";

if ( ! file_exists(APPPATH.'views/pages/'.$page.'.php'))
{
// Whoops, we don't have a page for that!
show_404();
}

}
}

view

we need to create a view file in application/view/pages/home.php

<div style="margin-left: 43%;">

<h1><?php echo $title; ?></h1>

<table style="border:1px solid #000;text-align:center;">
<thead>
<th style="border:1px solid #000">Name : </th>
<th style="border:1px solid #000">Email : </th>
<th style="border:1px solid #000">Address : </th>

</thead>
<tbody>



<?php foreach ($employee as $emp_item): ?>

<tr >
<td style="border:1px solid #000" ><?=ucfirst($emp_item['name']);?></td> <br/>
<td style="border:1px solid #000"><?=$emp_item['email'];?></td> <br/>
<td style="border:1px solid #000"><?=$emp_item['address'];?></td>

</tr>

<?php endforeach; ?>

</tbody>
</table>

</div>

Create a Database table

CREATE TABLE IF NOT EXISTS `employee` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(128) NOT NULL,
`email` text NOT NULL,
`address` varchar(128) NOT NULL,
`slug` varchar(128) NOT NULL,
PRIMARY KEY (`id`),
KEY `slug` (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

db config go to the application/config/database.php add your hostname, username, password and database name

$db['default'] = array(
'dsn' => '',
'hostname' => 'localhost',
'username' => '',
'password' => '',
'database' => '',
'dbdriver' => 'mysqli',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => (ENVIRONMENT !== 'production'),
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);

model : now need to create a model file go to application/models/emp_model.php

<?php

// here class name first character capital

class Emp_model extends CI_Model {

//load database

public function __construct()
{
$this->load->database();
}

// this function for get a database value

public function get_emp($slug = FALSE)
{
if ($slug === FALSE)
{
//here our query to retrieve database

$query = $this->db->get('employee');
return $query->result_array();
}

$query = $this->db->get_where('employee', array('slug' => $slug));
return $query->row_array();
}

}

header.php

now need to create a views file go to application/views/templates/header.php

<html>
<head>
<title>CodeIgniter Static Pages Tutorial</title>
</head>
<body>

footer.php

now need to create a view file go to application/views/templates/footer.php