Skip to content

The CMS
Docs
- Guide
- Reference
- Cookbook
- Quicktips
- Screencasts
- Glossary
Resources
- Plugins
- Themes
- Newsletter
- Buzz
- License Hub
Community
Partners

Try
Buy

View all results ›

Formatting text
- KirbyText
- Markdown
Templates
- Field methods
- Helpers
Panel
- Blueprints
- Fields
- Sections
- Blocks
- Icons
- Styling
- Samples
Objects
- $kirby
- $site
- $page
- $pages
- $file
- $files
- $user
- $users
- $block
- $blocks
- $layout
- $layouts
- $language
- $languages
- $pagination
- $request
- $session
- All classes
- Aliases
Router
- Patterns
- Response types
System
- Config options
- Urls
- Roots
- Requirements
- Validators
Plugins
API
- Authentication
- Languages
- Pages
- Roles
- Site
- System
- Translations
- Users
Tools
- A
- Cookie
- Data
- Dir
- Escape
- F
- Header
- Html
- I18n
- Mime
- QrCode
- Query
- Str
- Tpl
- Url
- V
- Xml

new Query()

Constructor
$query->aggregate()

Builds an aggregation query.
$query->all()

Returns all matching rows from a table
$query->andWhere()

Shortcut to attach a where clause with an AND operator.
$query->avg()

Builds an average query
$query->bindings()

Attaches additional bindings to the query.
$query->build()

Builds the different types of SQL queries This uses the SQL class to build stuff.
$query->column()

Returns only values from a single column
$query->count()

Builds a count query
$query->debug()

Enables query debugging.
$query->delete()

Fires a delete query
$query->distinct()

Enables distinct select clauses.
$query->fail()

Enables failing queries.
$query->fetch()

Sets the object class, which should be fetched; set this to 'array' to get a simple array instead of an object; pass a function that receives the $data and the $key to generate arbitrary data structures
$query->find()

Find a single row by its primary key
$query->findBy()

Find a single row by column and value
$query->first()

Selects only one row from a table
$query->group()

Attaches a group by clause
$query->having()

Attaches an additional having clause
$query->innerJoin()

Shortcut for creating an inner join clause
$query->insert()

Fires an insert query
$query->iterator()

Sets the iterator class, which should be used for multiple results Set this to array to get a simple array instead of an iterator object
$query->join()

Adds a new join clause to the query
$query->leftJoin()

Shortcut for creating a left join clause
$query->limit()

Sets the limit for select clauses
$query->max()

Builds a max query
$query->min()

Builds a min query
$query->offset()

Sets the offset for select clauses
$query->one()

Selects only one row from a table
$query->orWhere()

Shortcut to attach a where clause with an OR operator.
$query->order()

Attaches an order clause
$query->page()

Automatically adds pagination to a query
$query->primaryKeyName()

Sets the name of the primary key column
$query->rightJoin()

Shortcut for creating a right join clause
$query->row()

Selects only one row from a table
$query->select()

Sets the columns, which should be selected from the table By default all columns will be selected
$query->sum()

Builds a sum query
$query->table()

Sets the name of the table, which should be queried
$query->update()

Fires an update query
$query->values()

Sets the values which should be used for the update or insert clause
$query->where()

Attaches an additional where clause

$query->all()

Returns all matching rows from a table

kirby/src/Database/Query.php#L707

$query->all()

Parent class

Kirby\Database\Query

Did you find an error? Help us improve our docs and edit this page on GitHub. Make sure to check out our styleguide →

Report an issue on this page

Kirby

The CMS that adapts to any project. Made for developers, designers, creators and clients.

The CMS
Docs
- Guide
- Reference
- Cookbook
- Quicktips
- Screencasts
- Glossary
- Archive
Resources
- Plugins
- Themes
- Newsletter
- Buzz
- License Hub
Community
Kirby
- Security
- Privacy
- License
- Presskit
- Team
- Contact
With support of