In this CodeIgniter tutorial , i will show you how to fetch data from database using model ,view, controller approach.
As usually we need need to setup database connection in order to perform actions like select,insert,delete,update..etc on database. open your database.php file and setup the database configuration values, after setting up database connection , As we know, CodeIgniter use MVC pattern. We will use Model for retrieve data from database.
open your application/database.php, set your database credentials.
|
|
$db['default']['hostname'] = "localhost"; // database host
$db['default']['username'] = "root"; // db user name
$db['default']['password'] = ""; // db user password
$db['default']['database'] = "arjunphp_demo"; // database name
|
Then create a controller called Post.php in you application/controller/ directory.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
<?php
class Post extends CI_Controller {
function __Construct(){
parent::__Construct ();
$this->load->database(); // load database
$this->load->model('PostModel'); // load model
}
public function index() {
$this->data['posts'] = $this->PostModel->getPosts(); // calling Post model method getPosts()
$this->load->view('posts_view', $this->data); // load the view file , we are passing $data array to view file
}
}
?>
|
Now create you model file called PostModel.php in our Application/Models/ directory.Which will query the database table and fetch the records.
1
2
3
4
5
6
7
8
9
10
11
12
|
<?php
class PostModel extends CI_Model {
function getPosts(){
$this->db->select("post_id,post_title,post_content");
$this->db->from('post_tbl');
$query = $this->db->get();
return $query->result();
}
}
?>
|
final step, lets create posts_view.php file under folder name application/views. Here we are going to display the posts information.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
<!DOCTYPE html>
<html lang="en">
<head>
</head>
<body>
<h4>Display Records From Database Using Codeigniter</h4>
<table>
<tr>
<td><strong>Post Id</strong></td>
<td><strong>Post Title</strong></td>
</tr>
<?php foreach($posts as $post){?>
<tr>
<td><?php echo $post->post_id;?></td>
<td><?php echo $post->post_title;?></td>
</tr>
<?php }?>
</table>
</body>
</html>
|
Now point your browser to http://localhost/post/ you will get the result.
No comments:
Post a Comment