Nesting objects in classes

Anon

I have a mysql class that I use to work with our database. I want to use two different databases inside of a class. For example:

include("mysql.inc.php");

class test {
	var $db = new MySQL("d1");
	var $db = new MySQL("d2");

	function test() {
		$sql = "select * from fieldname where username='rboone'";

		$g = $this->db->select($sql);

		echo $g[0]["id"];
	}
}


$t = new test;

I get this error:
Warning: Illegal string index in /data/online/test/rboone/riscid.php on line 14.

If I take one of the database it works. Is there any way to nest objects and classes this way.

The php we are using is 3.0.13...

Also in php 4 nesting doesn't work at all.

Anon

The reason it doesn't work in 4 is because your code is very wrong. you cannot declare non-scalar values in the class definition. Move the variable initialization routines to the constructor of test instead. Also, why in the world are you defining $db twice anyway? If i were you, I would also reevaluate your reasoning for needing a MySQL object as a property of test.

Anon

Part of that was a type-o. The code should be:

var $db = new MySQL("d1");
var $db2 = new MySQL("d2");

So should I call mysql_connect every time in the class I need to query the database? I am new to OOP and am tring to find the best way to implement it in my programming.

Anon

Well, it depends on the load you expect. I have a fairly busy web site, 18,350 hits yesterday, and have tried to minimize database object creations. I was fortunatly given free access to the server my site runs on ( a duel p3 667 ) but this is a very busy server with ~15 FTP connections always going at around 50K/sec. and a second (very busy) web site running on it and I never see performance lag.

I have a couple functions that summarize data which I use static variables for, but usually I get away with just creating a new db object whenever I need one. Doing it this way, I still only create 2 or 6 db objects per hit, depending on the page...generally it is 2.

Remember that mysql is one of the fastest connecting databases out there, so unless your database server is not on the same computer as your httpd and there is a small pipe between them, you should be ok.