class.DbQueryCore.md

Class DbQueryCore

SQL query builder

• Class name: DbQueryCore
• Source: classes/db/DbQuery.php line 33

Contents

Properties

• $query

Methods

• __toString
• build
• from
• groupBy
• having
• innerJoin
• join
• leftJoin
• leftOuterJoin
• limit
• naturalJoin
• orderBy
• select
• where

Properties

$query

protected array $query = array('select' => array(), 'from' => '', 'join' => array(), 'where' => array(), 'group' => array(), 'having' => array(), 'order' => array(), 'limit' => array('offset' => 0, 'limit' => 0))

• Visibility: protected
• Source: classes/db/DbQuery.php line 38.

Methods

__toString

mixed DbQueryCore::__toString()

• Visibility: public
• Source: classes/db/DbQuery.php line 250

build

string DbQueryCore::build()

Generate and get the query

• Visibility: public
• Source: classes/db/DbQuery.php line 218

from

\DbQuery DbQueryCore::from(string $table, $alias)

Set table for FROM clause

• Visibility: public
• Source: classes/db/DbQuery.php line 68

Arguments

• $table string - Table name
• $alias mixed

groupBy

\DbQuery DbQueryCore::groupBy(string $fields)

Add a GROUP BY restriction

• Visibility: public
• Source: classes/db/DbQuery.php line 186

Arguments

• $fields string - List of fields to sort. E.g. $this->group('myField, b.mySecondField DESC')

having

\DbQuery DbQueryCore::having(string $restriction)

Add a restriction in HAVING clause (each restriction will be separated by AND statement)

• Visibility: public
• Source: classes/db/DbQuery.php line 158

Arguments

• $restriction string

innerJoin

mixed DbQueryCore::innerJoin(string $table, string $alias, string $on)

Add INNER JOIN clause E.g. $this->innerJoin('product p ON .

..')

• Visibility: public
• Source: classes/db/DbQuery.php line 110

Arguments

• $table string - Table name (without prefix)
• $alias string - Table alias
• $on string - ON clause

join

\DbQuery DbQueryCore::join(string $join)

Add JOIN clause E.g. $this->join('RIGHT JOIN '.DB_PREFIX.'product p ON .

..');

• Visibility: public
• Source: classes/db/DbQuery.php line 82

Arguments

• $join string - Complete string

leftJoin

mixed DbQueryCore::leftJoin(string $table, string $alias, string $on)

Add LEFT JOIN clause

• Visibility: public
• Source: classes/db/DbQuery.php line 97

Arguments

• $table string - Table name (without prefix)
• $alias string - Table alias
• $on string - ON clause

leftOuterJoin

mixed DbQueryCore::leftOuterJoin(string $table, string $alias, string $on)

Add LEFT OUTER JOIN clause

• Visibility: public
• Source: classes/db/DbQuery.php line 122

Arguments

• $table string - Table name (without prefix)
• $alias string - Table alias
• $on string - ON clause

limit

\DbQuery DbQueryCore::limit($limit, $offset)

Limit results in query

• Visibility: public
• Source: classes/db/DbQuery.php line 200

Arguments

• $limit mixed
• $offset mixed

naturalJoin

mixed DbQueryCore::naturalJoin(string $table, string $alias)

Add NATURAL JOIN clause

• Visibility: public
• Source: classes/db/DbQuery.php line 133

Arguments

• $table string - Table name (without prefix)
• $alias string - Table alias

orderBy

\DbQuery DbQueryCore::orderBy(string $fields)

Add an ORDER B restriction

• Visibility: public
• Source: classes/db/DbQuery.php line 172

Arguments

• $fields string - List of fields to sort. E.g. $this->order('myField, b.mySecondField DESC')

select

\DbQuery DbQueryCore::select(string $fields)

Add fields in query selection

• Visibility: public
• Source: classes/db/DbQuery.php line 55

Arguments

• $fields string - List of fields to concat to other fields

where

\DbQuery DbQueryCore::where(string $restriction)

Add a restriction in WHERE clause (each restriction will be separated by AND statement)

• Visibility: public
• Source: classes/db/DbQuery.php line 144

Arguments

• $restriction string