brrocks28
11/18/2016 - 10:17 AM

db query db_select conditions

db query db_select conditions





CONDITIONS
/**********************************************************************/
->condition($field, $value = NULL,$operator = NULL)
$field The field to check or the result of a logic operation (or, and, xor)
$value The value to test against.
$operator Default: ‘=’ or ‘IN’.
Supported: =, <, >, >=, <=, IN,NOT IN, LIKE, BETWEEN, ISNULL, IS NOT NULL
return The called query object.


/**********************************************************************/


->where($snippet, $args = array())
$snippet Where clause (with placeholders)
$args Assoc array of placeholders and placeholder values.


/**********************************************************************/


->db_or()->condition()->condition() return 
Condition of OR-ed conditions.


/**********************************************************************/


->db_and()->condition()->condition()
return Condition of AND-ed conditions.


/**********************************************************************/


->isNull($field)
->isNotNull($field)
$field The field to check.
return The called query object.


/**********************************************************************/


->exists(SelectQueryInterface $select);
->notExists(SelectQueryInterface $select);
$select The query to check.
return The called query object.
/**********************************************************************/