PHP Inet\SugarCRM\Database Query Examples

Example #1

File: QueryTest.php Project: inetprocess/libsugarcrm

 public function testExecute()
 {
     $sql = 'SELECT * FROM users where id = :id';
     $query = new Query(static::getPdo(), $sql, array(':id' => '1'));
     $res = $query->execute();
     $row = $res->fetch();
     $this->assertEquals('1', $row['id']);
 }

Example #2

File: AbstractTablesDiff.php Project: inetprocess/libsugarcrm

 /**
  * Get the sql query string for a query.
  */
 public function getSqlQuery(Query $query)
 {
     return $query->getRawSql();
 }