jgaydos/php-jdbc-bridge

There is no license information available for the latest version (1.0.0) of this package.

PHP to JDBC bridge

1.0.0 2018-12-14 19:09 UTC

Unknown License

README

The PHP-JDBC bridge is a service and library for allowing a PHP application to interface with a database for which only a JDBC driver exists. This is a fork of PJBS.

The java component runs as a service which accepts socket requests from the PHP component allowing the transfer of request and response between PHP and the JDBC database.

Requirements

• Java 21+
• PHP 8.0+
• A JDBC driver

Build (Java Service)

To build the PHP-JDBC bridge jar:

cd java
./build.sh

To build a PHP-JDBC RPM:

cd java
./build.sh
./build-rpm.sh

Usage

Java Service

To run the service:

java -cp 'lib/pjbridge.jar:lib/commons-daemon-1.1.0.jar:lib/<JDBC driver>.jar Server <JDBC driver entry point> <port>

Examples:

cd java
java -cp 'lib/pjbridge.jar:lib/commons-daemon-1.1.0.jar:lib/dharma.jar' Server dharma.jdbc.DharmaDriver 4444

cd java
java -cp 'lib/pjbridge.jar:lib/commons-daemon-1.5.1.jar:lib/mssql-jdbc-13.2.1.jre11.jar' Server com.microsoft.sqlserver.jdbc.SQLServerDriver 4444

where the lib directory contains the php-jdbc jar, the commons-daemon jar and your JDBC driver jar.

PHP

Example:

<?php
require "PJBridge.php";

$dbHost = "server";
$dbName = "";
$dbPort = "1990";
$dbUser = "dharma";
$dbPass = "";

$connStr = "jdbc:dharma:T:${dbHost}:${dbName}:${dbPort}";

$db = new PJBridge();
$result = $db->connect($connStr, $dbUser, $dbPass);
if(!$result){
    die("Failed to connect\n");
}

$cursor = $db->exec('SELECT * FROM "AR Customer File"');

while($row = $db->fetch_array($cursor)){
    print_r($row);
}

$db->free_result($cursor);