| 
<?php/**
 * Config.
 *
 * @author     Marco Cesarato <[email protected]>
 * @license    http://opensource.org/licenses/gpl-3.0.html GNU Public License
 *
 * @see       https://github.com/marcocesarato/Database-Web-API
 */
 require_once __API_ROOT__ . '/docs.php';
 
 define('__API_NAME__', 'Database Web API'); // API Name
 
 $users_table = 'users'; // Table where users are stored
 
 // REMOVE COMMENT FOR ENABLE TOKEN AUTHENTICATION
 /*define("__API_AUTH__",  serialize(array( // Set null for disable authentication
 'sqlite' => false, // Enabled save token on SQLite file
 'sqlite_database' => 'api_token', // SQLite filename (only with sqlite = true)
 'api_database' => 'dataset', // Authentication database
 'api_table' => 'api_authentications', // API token table name
 'users' => array(
 'database' => 'dataset', // Database where users are stored
 'table' => $users_table, // Table where users are stored
 'columns' => array(
 'id' => 'user_id', // Id column name
 'username' => 'user_name', // Username column name
 'password' => 'password', // Password column name
 'admin' => array('is_admin' => 1) // Admin bypass condition. With this condition true API bypass all black/whitelists and permissions. Set NULL for disable
 ),
 'search' => array('user_id', 'email', 'username'), // Search user by these fields
 'check' => array('active' => 1) // Some validation checks. In this case if the column 'active' with value '1'. Set NULL for disable
 ),
 )));*/
 
 // Datasets (list of database to connect)
 define('__API_DATASETS__', serialize([
 'dataset' => [
 'name' => 'database_name',
 'username' => 'root', // root is default
 'password' => 'root', // root is default
 'server' => 'localhost',  // localhost default
 'port' => 3306, // 3306 is default
 'ttl' => 1, // Cache time to live. Disable cache (1 second only)
 'type' => 'mysql', // mysql is default
 'table_docs' => $docs['dataset'],
 'table_list' => [], // Tables's whitelist (Allow only the tables in this list, if empty allow all)
 'table_blacklist' => [/*blacklist users table*/
 $users_table,
 ], // Tables's blacklist
 'column_list' => [], // Columns's whitelist (Allow only the columns in this list, if empty allow all)
 'column_blacklist' => [], // Columns's blacklist
 ],
 ]));
 
 |