php-java-bridge-users Mailing List for PHP/Java Bridge

Hi,

why don't you simply require a functional PHP environment? The bridge can be configured to use the system PHP installation instead of the local PHP binary within WEB-INF/cgi/.


> [PHP_MySQL]
> extension=php_mysql.dll
> 
> And then copy-paste the php_mysql.dll from the dll's

I don't think this will work. The php mysql.so (php_mysql.dll) have been compiled against a specific PHP version and a specific mysql version:

[jostb@carlos ~]$ locate mysql.so
/usr/lib/php/modules/mysql.so
/usr/lib/php/modules/pdo_mysql.so
[jostb@carlos ~]$ ldd /usr/lib/php/modules/mysql.so
/usr/lib/php/modules/mysql.so:
	linux-gate.so.1 =>  (0x00110000)
	libmysqlclient.so.15 => /usr/lib/mysql/libmysqlclient.so.15 (0x0011d000)

The php_mysql driver depends on the version # of the mysql client library (version 15) in this case. A different client library might cause a crash.

I don't think it makes sense to ship a complete mysql installation with each PHP application. However, there are several open-source pure Java-based relational databases which can be easily packaged with your PHP/Java web application.


Regards,
Jost Boekemeier



      

Kevin,

>> One of the uses I currently have for Php-Java Bridge is to allow PHP to 
connect to mySQL.
>> What I want to know is if it is an equivalent way of doing this in Red 
Hat Linux.

There is a PDO (PHP Data Object) available for accessing mySql from PHP. 
The easiest way I've found is to  install a LAMP (Linux Apache MySql PHP) 
version and it is pretty much done.  I tend to use Ubuntu.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation

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




      

One of the uses I currently have for Php-Java Bridge is to allow PHP to connect to mySQL. Doing this in Windows is simple, all I have to do is add the following in the php.ini file:

[PHP_MySQL]
extension=php_mysql.dll

And then copy-paste the php_mysql.dll from the dll's that come with the php installer into (apache-tomcat installation directory)/webapps/JavaBridge/Web.INF/cgi. 

What I want to know is if it is an equivalent way of doing this in Red Hat Linux. For instance, instead of say php_mysql.dll, is there a php_mysql.so file out there somewhere?

Thank you in advance for your assistance
-Kevin