CodeIgniter Step By Step Tutorial: We have set database and create table for CodeIgniter practice. Now, we learn how to show data in CodeIgniter. As we know, CodeIgniter use MVC pattern. We will use Model for retrieve data from database.
First, build a model. Create a file named “books_model.php” within CodeIgniter/CodeIgniter\system\application\models. Enter following code:

<?php
	class Books_model extends Model{
	
	function Books_model(){

	parent::Model();

	}

	function books_getall(){

	$this->load->database();

	$query = $this->db->get('books');

	return $query->result();
	}

}
?>

Continue reading →

CodeIgniter Step By Step Tutorial: After set database configuration,we will learn about showing data from database in CodeIgniter. But, before that, we prepare a database for practice. This post create a database named “ci” and a table named “books”. We use phpMyAdmin for easy.
1. Open your phpmyadmin.
2. Enter database name “ci” in create new database field.
3. Click Create button. Your database will be created.

Database create successfully

4. Create new table by entering name of new table at create new table field.
5. Enter number of fields.
6. Click Go button.

7. Enter name of field, type, and length

8. Choose auto increment and check primary key for primary key field. and Click Save button.

Table create successfully

9. Now, we insert data. Click Insert tab.

10. Enter data.
11. Click Go for saving.

Continue reading →