CodeIgniter: Preparing Database

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 "codeigniter" and a table named "hello". We use phpMyAdmin for easy.

1. Open your phpmyadmin.
2. Enter database name "codeigniter" in create new database field.
3. Click Create button. Your database will be created.

   

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.
9. Click Save button.

   

10. Now, we insert data. Click Insert tab.
11. Enter data.
12. Click Go for saving.