PHP Classes

ApiQL.net PHP SQL API Builder: Serve an API to query certain SQL database tables

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 78 All time: 10,151 This week: 129Up
Version License PHP version Categories
apiqlnet 1.0GNU General Publi...5PHP 5, Databases, Web services
Collaborate with this project 

Author

Mihajlo Siljanoski

apiql.net - github.com

Description

This package can be used to serve an API to query certain SQL database tables.

It can handle HTTP requests to access a REST API that can perform SQL queries on a server side database.

The package can be customized using a SQL database that define what the API can do like

- The SQL SELECT, INSERT, UPDATE, DELETE queries on the allowed tables
- The API base URL
- The limit number of records to return per query
- The table columns that the API will not allow to access its values
- What debug information is generated to help developers understand how the API is working

Picture of Mihajlo Siljanoski
  Performance   Level  
Name: Mihajlo Siljanoski <contact>
Classes: 5 packages by
Country: Macedonia Macedonia
Age: 40
All time rank: 13991 in Macedonia Macedonia
Week rank: 195 Up1 in Macedonia Macedonia Equal

Level 4 StarStarStarStar

 Innovation award
Innovation award
Nominee: 1x

Example

<?php
error_reporting(E_ALL);
ini_set('display_errors',1);

require_once './config/config.php';
require_once './src/Apiql.php';
$ApiQL = new Apiql($config);

$ApiQL->config->debug = true;
$ApiQL->config->token = 123456;

$ApiQL->handleRequest();

Details

ApiQL - Automated Rest API for MySql databases

Full documentation for this project


  Files folder image Files (103)  
File Role Description
Files folder imageconfig (1 file)
Files folder imagedocumentation (2 files)
Files folder imagesrc (9 files, 1 directory)
Accessible without login Plain text file .htaccess Data Auxiliary data
Accessible without login Plain text file composer.json Data Auxiliary data
Accessible without login Plain text file index.php Example Example script
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files (103)  /  config  
File Role Description
  Accessible without login Plain text file config.php Conf. Configuration script

  Files folder image Files (103)  /  documentation  
File Role Description
  Accessible without login Plain text file index.php Aux. Auxiliary script
  Accessible without login Plain text file parser.php Example Example script

  Files folder image Files (103)  /  src  
File Role Description
Files folder imagedrivers (1 file, 12 directories)
  Plain text file Apiql.php Class Class source
  Plain text file DB.php Class Class source
  Plain text file DB_cache.php Class Class source
  Plain text file DB_driver.php Class Class source
  Plain text file DB_forge.php Class Class source
  Plain text file DB_query_builder.php Class Class source
  Plain text file DB_result.php Class Class source
  Plain text file DB_utility.php Class Class source
  Accessible without login HTML file index.html Doc. Documentation

  Files folder image Files (103)  /  src  /  drivers  
File Role Description
Files folder imagecubrid (5 files)
Files folder imageibase (5 files)
Files folder imagemssql (5 files)
Files folder imagemysql (5 files)
Files folder imagemysqli (5 files)
Files folder imageoci8 (5 files)
Files folder imageodbc (5 files)
Files folder imagepdo (5 files, 1 directory)
Files folder imagepostgre (5 files)
Files folder imagesqlite (5 files)
Files folder imagesqlite3 (5 files)
Files folder imagesqlsrv (5 files)
  Accessible without login HTML file index.html Doc. Documentation

  Files folder image Files (103)  /  src  /  drivers  /  cubrid  
File Role Description
  Plain text file cubrid_driver.php Class Class source
  Plain text file cubrid_forge.php Class Class source
  Plain text file cubrid_result.php Class Class source
  Plain text file cubrid_utility.php Class Class source
  Accessible without login HTML file index.html Doc. Documentation

  Files folder image Files (103)  /  src  /  drivers  /  ibase  
File Role Description
  Plain text file ibase_driver.php Class Class source
  Plain text file ibase_forge.php Class Class source
  Plain text file ibase_result.php Class Class source
  Plain text file ibase_utility.php Class Class source
  Accessible without login HTML file index.html Doc. Documentation

  Files folder image Files (103)  /  src  /  drivers  /  mssql  
File Role Description
  Accessible without login HTML file index.html Doc. Documentation
  Plain text file mssql_driver.php Class Class source
  Plain text file mssql_forge.php Class Class source
  Plain text file mssql_result.php Class Class source
  Plain text file mssql_utility.php Class Class source

  Files folder image Files (103)  /  src  /  drivers  /  mysql  
File Role Description
  Accessible without login HTML file index.html Doc. Documentation
  Plain text file mysql_driver.php Class Class source
  Plain text file mysql_forge.php Class Class source
  Plain text file mysql_result.php Class Class source
  Plain text file mysql_utility.php Class Class source

  Files folder image Files (103)  /  src  /  drivers  /  mysqli  
File Role Description
  Accessible without login HTML file index.html Doc. Documentation
  Plain text file mysqli_driver.php Class Class source
  Plain text file mysqli_forge.php Class Class source
  Plain text file mysqli_result.php Class Class source
  Plain text file mysqli_utility.php Class Class source

  Files folder image Files (103)  /  src  /  drivers  /  oci8  
File Role Description
  Accessible without login HTML file index.html Doc. Documentation
  Plain text file oci8_driver.php Class Class source
  Plain text file oci8_forge.php Class Class source
  Plain text file oci8_result.php Class Class source
  Plain text file oci8_utility.php Class Class source

  Files folder image Files (103)  /  src  /  drivers  /  odbc  
File Role Description
  Accessible without login HTML file index.html Doc. Documentation
  Plain text file odbc_driver.php Class Class source
  Plain text file odbc_forge.php Class Class source
  Plain text file odbc_result.php Class Class source
  Plain text file odbc_utility.php Class Class source

  Files folder image Files (103)  /  src  /  drivers  /  pdo  
File Role Description
Files folder imagesubdrivers (25 files)
  Accessible without login HTML file index.html Doc. Documentation
  Plain text file pdo_driver.php Class Class source
  Plain text file pdo_forge.php Class Class source
  Plain text file pdo_result.php Class Class source
  Plain text file pdo_utility.php Class Class source

  Files folder image Files (103)  /  src  /  drivers  /  pdo  /  subdrivers  
File Role Description
  Accessible without login HTML file index.html Doc. Documentation
  Plain text file pdo_4d_driver.php Class Class source
  Plain text file pdo_4d_forge.php Class Class source
  Plain text file pdo_cubrid_driver.php Class Class source
  Plain text file pdo_cubrid_forge.php Class Class source
  Plain text file pdo_dblib_driver.php Class Class source
  Plain text file pdo_dblib_forge.php Class Class source
  Plain text file pdo_firebird_driver.php Class Class source
  Plain text file pdo_firebird_forge.php Class Class source
  Plain text file pdo_ibm_driver.php Class Class source
  Plain text file pdo_ibm_forge.php Class Class source
  Plain text file pdo_informix_driver.php Class Class source
  Plain text file pdo_informix_forge.php Class Class source
  Plain text file pdo_mysql_driver.php Class Class source
  Plain text file pdo_mysql_forge.php Class Class source
  Plain text file pdo_oci_driver.php Class Class source
  Plain text file pdo_oci_forge.php Class Class source
  Plain text file pdo_odbc_driver.php Class Class source
  Plain text file pdo_odbc_forge.php Class Class source
  Plain text file pdo_pgsql_driver.php Class Class source
  Plain text file pdo_pgsql_forge.php Class Class source
  Plain text file pdo_sqlite_driver.php Class Class source
  Plain text file pdo_sqlite_forge.php Class Class source
  Plain text file pdo_sqlsrv_driver.php Class Class source
  Plain text file pdo_sqlsrv_forge.php Class Class source

  Files folder image Files (103)  /  src  /  drivers  /  postgre  
File Role Description
  Accessible without login HTML file index.html Doc. Documentation
  Plain text file postgre_driver.php Class Class source
  Plain text file postgre_forge.php Class Class source
  Plain text file postgre_result.php Class Class source
  Plain text file postgre_utility.php Class Class source

  Files folder image Files (103)  /  src  /  drivers  /  sqlite  
File Role Description
  Accessible without login HTML file index.html Doc. Documentation
  Plain text file sqlite_driver.php Class Class source
  Plain text file sqlite_forge.php Class Class source
  Plain text file sqlite_result.php Class Class source
  Plain text file sqlite_utility.php Class Class source

  Files folder image Files (103)  /  src  /  drivers  /  sqlite3  
File Role Description
  Accessible without login HTML file index.html Doc. Documentation
  Plain text file sqlite3_driver.php Class Class source
  Plain text file sqlite3_forge.php Class Class source
  Plain text file sqlite3_result.php Class Class source
  Plain text file sqlite3_utility.php Class Class source

  Files folder image Files (103)  /  src  /  drivers  /  sqlsrv  
File Role Description
  Accessible without login HTML file index.html Doc. Documentation
  Plain text file sqlsrv_driver.php Class Class source
  Plain text file sqlsrv_forge.php Class Class source
  Plain text file sqlsrv_result.php Class Class source
  Plain text file sqlsrv_utility.php Class Class source

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadapiqlnet-2020-12-18.zip 232KB
Downloadapiqlnet-2020-12-18.tar.gz 111KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:78
This week:0
All time:10,151
This week:129Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.