Connect to database in sugarCRM

[eecanoc]

hi..

I have a doubt regarding i could connect to database in sugarCRM, i am looking an example how i can connect to sugarCRM database throught php ..

i couldn't found anything...about it...

Thanks for your help..

[AlexAv]

Hello,

Take a look at the example :

 include_once('include/database/DBManagerFactory.php');
$db = DBManagerFactory::getInstance();
$db->query('SELECT ... FROM ... WHERE ...'); 
  

[andopes]

Hello,

Take a look at the example :

 include_once('include/database/DBManagerFactory.php');
$db = DBManagerFactory::getInstance();
$db->query('SELECT ... FROM ... WHERE ...'); 
  

A better approach would be:

 global $db;
 
$db->query($query, true); 
  

or

 $GLOBALS['db']->query($query, true); 
  

Cheers

[AlexAv]

A better approach would be:

 global $db;

$db->query($query, true); 
  

or

 $GLOBALS['db']->query($query, true); 
  

Cheers

Yes, it is better solution.