DBMAnagerFactory::getInstance in Custom file

[rakeshray]

Hi

I added a new php file at <root>/<file-name>
simply
$instance=DBMAnagerFactory::getInstance();
is not enough to creation of instance.
errors of missing classe and functions were coming , finally i included following files
require_once('config.php');
require_once('include/SugarLogger/LoggerManager.php');
require_once('include/SugarObjects/SugarConfig.php');
require_once('include/utils/sugar_file_utils.php');
$GLOBALS['log'] = LoggerManager::getLogger('SugarCRM');
require_once('include/database/DBManager.php');
require_once('include/database/MysqliManager.php');
require_once('include/database/MysqliHelper.php');
require_once('include/database/DBManagerFactory.php'); //MysqliManager.php
require_once('include/database/DBManager.php');

$instance=DBMAnagerFactory::getInstance();
$query1="select * from accounts";
//$res=$instance->query($query);
$res=$instance->fetchByAssoc($instance->query($query1));
print_r($res['id']);

But still an warning is coming and no data base communication is happening.
warning is Warning:
array_map() [function.array-map]: The first argument, 'to_html', should be either NULL or a valid callback in
i am using sugar CE 6.0.0
Give me any idea please
Thanks

[christianknoll]

Why not use $GLOBALS['db']?

christian.

Hi

I added a new php file at <root>/<file-name>
simply
$instance=DBMAnagerFactory::getInstance();
is not enough to creation of instance.
errors of missing classe and functions were coming , finally i included following files
require_once('config.php');
require_once('include/SugarLogger/LoggerManager.php');
require_once('include/SugarObjects/SugarConfig.php');
require_once('include/utils/sugar_file_utils.php');
$GLOBALS['log'] = LoggerManager::getLogger('SugarCRM');
require_once('include/database/DBManager.php');
require_once('include/database/MysqliManager.php');
require_once('include/database/MysqliHelper.php');
require_once('include/database/DBManagerFactory.php'); //MysqliManager.php
require_once('include/database/DBManager.php');

$instance=DBMAnagerFactory::getInstance();
$query1="select * from accounts";
//$res=$instance->query($query);
$res=$instance->fetchByAssoc($instance->query($query1));
print_r($res['id']);

But still an warning is coming and no data base communication is happening.
warning is Warning:
array_map() [function.array-map]: The first argument, 'to_html', should be either NULL or a valid callback in
i am using sugar CE 6.0.0
Give me any idea please
Thanks

[rakeshray]

Why not use $GLOBALS['db']?

christian.

I am using code like this
global $db;

$query1="select * from accounts";

res1=$db->query($query1);
$res=$db->fetchByAssoc($res1);

Then following error is coming
Call to a member function query() on a non-object

Actually i am putting a new file at <root> and in that file i am putting this code

When i putt
$query1="select * from accounts";
//$res=$instance->query($query);
$res1=$GLOBALS['db']->query($query1);
$res=$GLOBALS['db']->fetchByAssoc($res1);

same error is coming
thank

[jmertic]

Trying including entryPoint.php, it should bring in all the required files.

[rakeshray]

Trying including entryPoint.php, it should bring in all the required files.

Its working fine
pretty comment ...
Thanks !!!!