[SOLVED] ADODB Database + Class = Death

[shamilton]

I'm creating a grid with AJAX - PHP - MSSQL. 

It was going really fast until...I did this:

 

class grid {
function loadDB()
{
	/* Connect (Connect W/OUT DSN) [MSSQL] */
	/* Database */
	$SQL_query = "SELECT * FROM CRMActivity";
	$RecordSet = $DBConnection->Execute($SQL_query);
	for($i = 1; $RecordSet->EOF != 1 && $i < 10; $i++) {
		echo "<tr>";
		echo "<tr>".$RecordSet->Fields["CustNum"]->Value."</tr>";
		echo "</tr>";
		$RecordSet->MoveNext();
	} // End For
}

 

Here is how I connect to the database:

 

/* Connect (Connect W/OUT DSN) [MSSQL] */
$DBConnection = new COM ("ADODB.Connection") or die("Cannot start ADO");
$DBConnectionString = "PROVIDER=SQLOLEDB;SERVER=$dbHost;UID=$dbUser;PWD=$dbPass;DATABASE=$dbName";
$DBConnection->open($DBConnectionString);

 

So how do I get this to work?

 

I get the following errors:

 

Notice: Undefined variable: DBConnection in...

Fatal error: Call to a member function Execute() on a non-object in...

 

So I guess the realy question would be...

 

How do you call a class from a function in another class and not have it break.  ???

[steelmanronald06]

Where do you have $DBConnection set at? if it is outside of the class/function then you need to do this:

 

function loadDB()

{

        global $DBConnection;

        .....put the rest of the function code here

 

 

[shamilton]

That did the trick! 

Danke

[steelmanronald06]

Yeah, I work with AdoDB a lot, so I know some of the ins and outs of it.  Your welcome