DaniWeb Forum Index > Web Development > PHP

php adodb library connect remote mysql

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Feb 2005

Posts: 1,181

Reputation: hollystyles will become famous soon enough

Solved Threads: 67

hollystyles hollystyles is offline

Offline

Veteran Poster

php adodb library connect remote mysql

Apr 17th, 2006

Hi,

I have to connect sometimes to MSSQL and sometimes to MySql depending on the customer. I am experimenting with the php adodb library that claims to make database connection possible to either vendor using the same syntax.

First the background at home I have:

Rig1:
windows XP professional
PHP 5.0.4, IIS 5.1, MSSQL Server 2000 developer edition

Rig2:
Windows XP home
PHP 5.1.1, Apache 2.2.0, MySql 5.0.18-nt

So far if I connect and execute a query on Rig1 using two php files like this it works.

cls_gen_db.conf.php

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php 
$_ADO_INC_PATH = 'C:/Inetpub/phpado';
 
	  $dbdriver = 'mssql';
          $server = 'localhost';
          $user = 'myusername';
          $password = 'mypassword';
          $database = 'mydatabase';
 
include($_ADO_INC_PATH.'/adodb/adodb.inc.php');
?>
<?php 
$_ADO_INC_PATH = 'C:/Inetpub/phpado';

	  $dbdriver = 'mssql';
          $server = 'localhost';
          $user = 'myusername';
          $password = 'mypassword';
          $database = 'mydatabase';
          
include($_ADO_INC_PATH.'/adodb/adodb.inc.php');
?>

class_generator.php

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<html>
<body>
<?php
 
	include('cls_gen_db.conf.php');
 
	$Thedb = ADONewConnection($dbdriver);
	$Thedb->debug = true;
	$Thedb->Connect($server, $user, $password, $database);
 
	$Thedata = $Thedb->Execute('exec sp_tables');
	if ($Thedata == false) die("failed");
	print '<table>';
		while (!$Thedata->EOF) {
			print '<tr>';
			for ($i=0, $max=$Thedata->FieldCount(); $i < $max; $i++){
				print '<td>';
				print $Thedata->fields[$i];
			       print '</td>';
			       }
		print '</tr>';
 		$Thedata->MoveNext();
		}
	print '<table>';		
?>
</body>
</html>
<html>
<body>
<?php

	include('cls_gen_db.conf.php');

	$Thedb = ADONewConnection($dbdriver);
	$Thedb->debug = true;
	$Thedb->Connect($server, $user, $password, $database);

	$Thedata = $Thedb->Execute('exec sp_tables');
	if ($Thedata == false) die("failed");
	print '<table>';
		while (!$Thedata->EOF) {
			print '<tr>';
			for ($i=0, $max=$Thedata->FieldCount(); $i < $max; $i++){
				print '<td>';
				print $Thedata->fields[$i];
			       print '</td>';
			       }
		print '</tr>';
 		$Thedata->MoveNext();
		}
	print '<table>';		
?>
</body>
</html>

In theory to run a similar query on the MySql on Rig2 (it has same database name and user name setup) all I have to change is these two lines:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
	  $dbdriver = 'mysql';
          $server = 'Rig2';
	  $dbdriver = 'mysql';
          $server = 'Rig2';

And this line in the other file:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
	$Thedata = $Thedb->Execute('show tables');
	$Thedata = $Thedb->Execute('show tables');

But I get a blank page, no PHP errors ? if I copy the PHP files over to Rig2 and browse them via Apache web server locally it all works, but If PHP on Rig1 tries to query mysql on Rig2, I get nothing, not even an error. If I view source i see <html><body> but nothing else.

I am lost to know what the problem is (The SP2 firewall on Rig2 is configured to allow incoming TCP/IP on port 3306 from any other host on my home LAN)

What gives?

==========================================
Yadda yadda yadda...
Web junky, fevered monkey