Before we do anything, we need to create our database. Open up your favorite database editor and create a new database. Next, you should run the following SQL code to create the users
table.
Note
This SQL has only been tested with MySQL. Therefore it is advised that if you are using another database platform, you create the same table schema graphically or write your own SQL code.
CREATE TABLE `users` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `username` VARCHAR( 255 ) NOT NULL , `email` VARCHAR( 255 ) NOT NULL , `password` VARCHAR( 255 ) NOT NULL ) ENGINE = MYISAM;
Once that is done we need to edit our database configuration file. We do this by opening up /system/application/config/database.php
and editing the following lines to correctly reflect our own details:
$db['default']['hostname'] = "localhost"; $db['default']['username'] = ""; $db['default']['password'] = ""; $db['default']['database'] = ""; $db['default']['dbdriver'] = "mysql...