Home

Sugar CRM DBManagerFactory

Posted on July 27, 2017 by Janaki in Sugar / 0 Comment(s)

Querying The Database:

$sql = "SELECT id FROM accounts WHERE deleted = 0";
$result = $GLOBALS['db']->query($sql);
while($row = $GLOBALS['db']->fetchByAssoc($result) )
{
    //Use $row['id'] to grab the id fields value
    $id = $row['id'];
}

$sql = "SELECT id FROM accounts WHERE deleted = 0";

$result = $GLOBALS['db']->query($sql);

while($row = $GLOBALS['db']->fetchByAssoc($result) )

{

//Use $row['id'] to grab the id fields value

$id = $row['id'];

}

Retrieving a Single Result

$sql = "SELECT name FROM accounts WHERE id = '{$id}'";
$name = $GLOBALS['db']->getOne($sql);

1 2	$sql = "SELECT name FROM accounts WHERE id = '{$id}'"; $name = $GLOBALS['db']->getOne($sql);

Limiting Results To limit the results of a query, you can add a limit to the SQL string or use the […]

Sugar BeanFactory

Posted on July 19, 2017 by Janaki in Sugar / 0 Comment(s)

The BeanFactory class, located in ./data/BeanFactory.php, is used for loading an instance of a SugarBean. This class should be used any time you are creating or retrieving bean objects. It […]

Instal git on cPanel/WHM

Posted on July 5, 2017 by Janaki in More / 0 Comment(s)

DO NOT INSTALL GIT ON WHM SERVER! Because it’s already installed It’s just not in path and you can’t use it. There are two ways of doing this: 1. WHM/root way […]

Custom error page in Laravel

Posted on June 19, 2017 by Janaki in Laravel / 0 Comment(s)

Step 1. Create a view resources\views\exceptions\404.blade.php Step 2. Add the following code in App\Exceptions\Handler.php /** * Render an exception into a response. * * @param \Illuminate\Http\Request $request * @param \Exception […]