Codeigniter Tutorials

Home » Codeigniter »

Fetch data from database?

Fetch Data :-

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Auth_model extends CI_Model {

function __construct()
{
//call model constructor
parent::__construct();
}

function fetchtable()
{
$query = $this->db->get('baby');
return $query->result();
}
}
?>

employee_info.php :-

<table border="1">
<thead>
<th>ID</th>
<th>NAME</th>
<th>MEANING</th>
<th>GENDER</th>
<th>RELIGION</th>
<th>ACTION</th>
</thead>
<tbody>
<?php
foreach($this->Auth_model->fetchtable() as $row)
{
//name has to be same as in the database.
echo "<tr>
<td>$row->id</td>
<td>$row->name</td>
<td>$row->meaning</td>
<td>$row->gender</td>
<td>$row->religion</td>
</tr>";
}
?>
</tbody>
</table>

Employeeshow.php Fetch Data :-

public function show_employee()
{

//call the model function to get the department data
$userresult = $this->Auth_model->user_getemployee();
$data['userlist'] = $userresult;
//load the department_view
$this->load->view('employeedetails',$data);
}

Auth_model.php :-

public function user_getemployee()
{
$this->db->select('*');
$this->db->from('employee_details');
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->result();
} else {
return false;
}

********** OR ***************

/* $sql = 'select var_dept_name, var_emp_name from tbl_dept, tbl_emp where tbl_dept.int_hod = tbl_emp.int_id';*/

$sql = 'select * from employee';
$query = $this->db->query($sql);
$result = $query->result();
return $result;

}

Employeeshow_view.php :-

<div class="panel-body">

<?php

for ($i = 0; $i < count($userlist); ++$i)
{
?>
<div class="col-md-3">
<a href="<?php echo base_url()?>Emp_Info/get_employee_id/<?php echo $userlist[$i]->employee_id;?>"> <img src="<?php echo base_url()?>assets/images/<?php echo $userlist[$i]->profile_pics; ?>"
class="user-image img-responsive"/> <center><b><h4><?php echo $userlist[$i]->first_name; ?></b></h4></center>
</a></div>

<?php

}
?>

</div> ************* OR ******************

<?php
foreach($userlist as $row){
?> <tr>
<td><?php echo $row->user_id;?></td>
<td><?php echo $row->password;?></td>
<td><?php echo $row->email;?></td>
<td><?php echo $row->mobile;?></td>
</tr>

<?php } ?>

Curd.php :-

<?php
class Crud extends CI_Controller
{
public function __construct()
{
//call CodeIgniter's default Constructor
parent::__construct();
//load database libray manually
$this->load->database();
//load Model
$this->load->model('Crud_model');
}
//Display
public function displaydata()
{
$result['data']=$this->Auth_model->display_records();
$this->load->view('display_records',$result);
}
}
?>

:-

<?php
class Auth_model extends CI_Model
{
//View
function display_records()
{
$query=$this->db->query("select * from crud");
return $query->result();
}
}

display_records.php :-

<html>
<head>
<title>Display records</title>
</head>
<body>
<table width="600" border="1" cellspacing="5" cellpadding="5">
<tr style="background:#CCC">
<th>Sr No</th>
<th>First_name</th>
<th>Last_name</th>
<th>Email Id</th>
<th>Delete</th>
<th>Update</th>
</tr>
<?php
$i=1;
foreach($data as $row)
{
echo "<tr>";
echo "<td>".$i."</td>";
echo "<td>".$row->first_name."</td>";
echo "<td>".$row->last_name."</td>";
echo "<td>".$row->email."</td>";
echo "</tr>";
$i++;
}
?>
</table>

Fetch data from database :-

Controller.php

public function fetchdata()
{
//load the database
$this->load->database();
//load the model
$this->load->model('Auth_model');
//load the method of model
$data['mydata'] = $this->Auth_model->selectdata();
//return the data in view
$this->load->view('showdata_view',$data);
}

Auth_model :-

Auth_model.php

public function selectdata()
{
//data is retrive from this query
$qry = $this->db->get('country_table');
return $qry;
}

View :-

showdata_view.php

<html>
<head>
</head>
<body>
<table>
<tbody>
<tr>
<td>country id</td>
<td>Country name</td>
</tr>

<?php foreach ($mydata->result() as $row)
{
?>
<tr>
<td><?php echo $row->country_id;?></td>
<td><?php echo $row->country_name;?></td>
</tr>
<?php }?>
</tbody>
</table>
</body>
</html>

Codeigniter display data from database :-

controller.php

<?php
class Controller extends CI_Controller
{
public function __construct()
{
parent::__construct();
$this->load->database();
$this->load->helper('url');
$this->load->model('Auth_Model');
}

public function savedata()
{
$this->load->view('registration');
if($this->input->post('save'))
{
$n=$this->input->post('name');
$e=$this->input->post('email');
$m=$this->input->post('mobile');
$this->Hello_Model->saverecords($n,$e,$m);
redirect("Hello/dispdata");
}
}

public function dispdata()
{
$result['data']=$this->Auth_Model->displayrecords();
$this->load->view('display_records',$result);
}
}
?>

Auth_model :-

<?php
class Auth_Model extends CI_Model
{
function saverecords($name,$email,$mobile)
{
$query="insert into users values('','$name','$email','$mobile')";
$this->db->query($query);
}

function displayrecords()
{
$query=$this->db->query("select * from users");
return $query->result();
}
}

view :-

<!DOCTYPE html>
<html>
<head>
<title>Display Records</title>
</head>

<body>
<table width="600" border="1" cellspacing="5" cellpadding="5">
<tr style="background:#CCC">
<th>Name</th>
<th>Email</th>
<th>Mobile</th>
</tr>
<?php
foreach($data as $row)
{
echo "<tr>";
echo "<td>".$row->name."</td>";
echo "<td>".$row->email."</td>";
echo "<td>".$row->mobile."</td>";
echo "</tr>";
}
?>
</table>

</body>
</html>

Itechtuto

Codeigniter Tutorials

Fetch data from database?

Fetch Data :-

employee_info.php :-

Employeeshow.php Fetch Data :-

Auth_model.php :-

Employeeshow_view.php :-

Curd.php :-

:-

display_records.php :-

Fetch data from database :-

Controller.php

Auth_model :-

Auth_model.php

View :-

showdata_view.php

Codeigniter display data from database :-

controller.php

Auth_model :-

view :-

Connect Us Socially:

Quick Links