Auth_Container_DB

Auth_Container_DB – Authenticate against a database using DB

DB Container

This container makes use of PEAR::DB abstraction layer for database access. That means that you can use all databases that are supported by the DB abstraction layer to store the login data.

The storage-specific argument for the Auth constructor() is an array of options.

Available Options
Option Data Type Default value Description
"dsn" string " A valid and well-formed DSN .
"table" string "auth" The name of the database table, where the authorization data is stored.
"usernamecol" string "username" The name of the column, where the username is stored
"passwordcol" string "password" The name of the column, where the crypted password is stored.
"db_fields" array array() An array of extra fields to retrieve when loading the user details.
"cryptType" string "md5" The encryption type the password is stored in.
"auto_quote" boolean TRUE Whether to enable automatic quoting of database table and field names.
"db_options" array array() An array of options to be passed to the PEAR::DB constructor. See PEAR::DB::setOption() for more information.
"db_where" string " A string to be appended to the WHERE clause of queries against the database. It is appended to the queries used in fetchData(), listUsers(), removeUser() and changePassword(). Available since Auth 1.5.0.