Instead of using the default connection, use this connection for sql lookups
Default:
There are 2 ways to use it. First is to set it to an existing database connection:
$db =& NewADOConnection('mysql');
$db->PConnect($host,$user,$pwd,$db);
$lens->connectionLookups =& $db;
Alternatively, define a database connection string (defined in $PHPLENS_DATABASES, in the phplens/config/phplens.config.inc.php file).
$lens->connectionLookups = 'mysql_db2';
PHPLens will create a persistent connection. Basic:Yes Advanced/Enterprise:Yes DynamicEdit:Yes [Version 1.0]
|