Create a database named "codeigniter" and a table named "hello". We use phpMyAdmin for easy.
Open your phpmyadmin.
Enter database name "codeigniter" in create new database field.
Click Create button. Your database will be created.
Create new table by entering name of new table at create new table field.
Enter number of fields.
Click Go button.
Enter name of field, type, and length
Choose auto increment and check primary key for primary key field.
Click Save button.
Now, we insert data. Click Insert tab.
Enter data.
Click Go for saving.