9.1 Authentication

Authentication is key to any transactional web application. This framework provides a quick and easy way to have a basic authentication into your application by providing the necessary models, views and controllers readily available.

User Model and database table

As part of this framework, a MySql script is provided to create the basic users table to put in a place an authentication mechanism. This script can be found in application/models/Auth/create_db.sql.

This script can be run from either the Terminal or from a DB manager application such phpMyAdmin.

• Run from the Terminal

cd /application/models/Auth/
mysql -u <username> -p <databasename> > create_db.sql

• ** Run from phpMyAdmin**

- Click on the database name that you created
- Click `Import` from the action menu
- Browse to `application/Models/Auth`
- Select the file `create_db.sql`
- Click on `Go`