Joomla WHERE clause with OR

: Joel Lipman; Joomla; 16 July 2014; Hits: 6457

What?
A quick article on how to use the where clause in a joomla database query.

Why?
In response to a member, I use the old form where I can include the whole SQL statement:

copy raw

$db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true')

$db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true')

Method #1 - chain:

copy raw

$query
    ->where($db->quoteName('condition1') . ' = '. $db->quote('true'),'OR')
    ->where($db->quoteName('condition2') . ' = '. $db->quote('true'))

$query
->where($db->quoteName('condition1') . ' = '. $db->quote('true'),'OR')
->where($db->quoteName('condition2') . ' = '. $db->quote('true'))

Method #2 - array:

copy raw

$conditions = array(
    $db->quoteName('condition1') . ' = true', 
    $db->quoteName('condition2') . ' = true'
);
$query->where($conditions, 'OR')

$conditions = array(
$db->quoteName('condition1') . ' = true',
$db->quoteName('condition2') . ' = true'
);
$query->where($conditions, 'OR')

Category: Joomla :: Article: 569