Single file PHP script that adds a REST API to a MySQL/MariaDB, PostgreSQL, SQL Server or SQLite database. Howto: Upload "api.php" to your webserver, configure it to connect to your database, have an instant full-featured REST API. This is the TreeQL reference implementation in PHP. This is a single file application! Upload "api.php" somewhere and enjoy! For local development you may run PHP's built-in web server. All configuration options are also available as environment variables. Write the config option with capitals, a "PHP_CRUD_API_" prefix and underscores for word breaks. The environment variables take precedence over the PHP configuration.

Features

  • Requires PHP 7.0 or higher with PDO drivers enabled for one of these database systems
  • Requires MySQL 5.6 / MariaDB 10.0 or higher for spatial features in MySQL
  • Requires PostgreSQL 9.1 or higher with PostGIS 2.0 or higher for spatial features
  • Requires SQL Server 2012 or higher (2017 for Linux support)
  • Requires SQLite 3.16 or higher (spatial features NOT supported)
  • This is the TreeQL reference implementation in PHP

Project Samples

PHP-CRUD-API Screenshot 1

Project Activity

See All Activity >