SQL Extension

API: http://jphp-docs.readthedocs.org/en/latest/api_en/php/sql/

To use sql extension, you should add jphp-sql-ext maven dependency (in build.gradle) and add JDBC driver dependency for your database product (SQLite, MySQL, PostgreSQL, etc).

• For example (SQLite):

dependencies {
    // ...
    
    compile 'org.develnext:jphp-sql-ext:<version>'
    compile 'org.xerial:sqlite-jdbc:3.8.7'
}

• For MySQL: compile 'mysql:mysql-connector-java:5.1.35'
• For PostgreSQL: compile 'org.postgresql:postgresql:9.4-1201-jdbc41'

To use other sql databases, you can search JDBC driver for <database name> maven in Google, for example.

Getting started

Before using you should install an sql driver:

use php\sql\SqlDriverManager;

SqlDriverManager::install('sqlite'); // or mysql or postres or JDBC Driver java class name

Get an sql connection of your database:

use php\sql\SqlDriverManager;

SqlDriverManager::install('sqlite');

$conn = SqlDriverManager::getConnection('sqlite:example.db');