PHP Classes

File: config.php

Recommend this page to a friend!
  Classes of Marco Cesarato   PHP API Database   config.php   Download  
File: config.php
Role: Auxiliary script
Content type: text/plain
Description: Auxiliary script
Class: PHP API Database
Provide access to database records via REST API
Author: By
Last change: Reformatted code (php-cs-fixer)

Added code standard,
Added hooks git for code standard,
Fixed parse where on null elements
Date: 5 years ago
Size: 2,466 bytes
 

Contents

Class file image Download
<?php
/**
 * Config.
 *
 * @author Marco Cesarato <cesarato.developer@gmail.com>
 * @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
   
],
]));