Today, We want to share with you how to fetch data from database in codeigniter.In this post we will show you insert and display data from database in codeigniter, hear for select query in codeigniter we will give you demo and example for implement.In this post, we will learn about codeigniter count rows in view & controller with an example.
Retrieve data from database using CodeIgniter framework
In this example we will learn all about how to fetch a record or data from MySQL database using CodeIgniter framework PHP.
Sql Table
CREATE TABLE students ( `id` int(11) NOT NULL, `profile_nm` varchar(30) NOT NULL, `sir_nm` varchar(30) NOT NULL, `email` varchar(30) NOT NULL, PRIMARY KEY (id) );
Models
Student.php (Path: application\models\Student_model.php)
load->database(); $this->load->model('Student_model'); } public function displaydata() { $result['data']=$this->Student_model->display_records(); $this->load->view('display_records',$result); } } ?>
Get codeIgniter Data
get all data from db in codeigniter using student_fetch.php
db->query("select * from students"); return $query->result(); } }
Display records
here simple you can display data with codeigniter view file like as a display_records.php (Path: application\views\insert.php)
Display records - www.pakainfo.com
Sr No | First_name | Last_name | Email Id | Delete | Update | ".$i." | "; echo "".$student->profile_nm." | "; echo "".$student->sir_nm." | "; echo "".$student->email." | "; echo ""; $i++; } ?>
---|
and last step Now run the example on your browser like chrome with the below URL:
http://your-domainname/codeIgniter/index.php/Student/displaydata
After here you can simply retrive the students data the table look like this.
Id | Profile name | Sir name | Email Id |
---|---|---|---|
1 | Virat | Kohali | [email protected] |
2 | Bhavika | Pethani | [email protected] |
3 | Sejal | Ramani | [email protected] |
I hope you get an idea about how to fetch data from database in codeigniter.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.