Re: [Php-java-bridge-users] Need Help for Linux: Connecting Php and MySQL using Php-Java Bridge

[<php...@li...>]

1. Download mysql-connector-java.jar

2. Copy mysql-connector-java.jar to your java.ext.dirs (usually "/usr/java/default/lib/ext")

# (or start a simple Java VM using /usr/share/java as java.ext.dirs)
java -Djava.ext.dirs=/usr/share/java -jar ~/JavaBridge.jar SERVLET:8080 3 "" &

3. Use the driver as usual:

---------- mysqlTest.php ----------------
<?php require_once("http://localhost:8080/JavaBridge/java/Java.inc");

# load driver from java.ext.dirs using Class.forName(...)
new java("com.mysql.jdbc.Driver");

$conn = java("java.sql.DriverManager")->getConnection("jdbc:mysql://localhost/test", "root", "");
$st = $conn->createStatement ();
$st->executeUpdate ("drop table hugo");
$st->executeUpdate ("create table hugo (i int primary key, v varchar(255))");
$st->executeUpdate ("insert into hugo (i, v) values (1, 'first')");
$st->executeUpdate ("insert into hugo (i, v) values (2, 'second')");
$st->execute("select * from hugo");
$rs = $st->getResultSet ();
while ((string)$rs->next ()) {
  echo $rs->getInt("i"); echo ", ";
  echo $rs->getString("v"); echo "\n";
}
$rs->close();
$st->close();
$conn->close ();
?>
---------------------------------------------------------

# test
php -d allow_url_include=On mysqlTest.php
=> 
1, first
2, second