Skip to content

The CMS
Docs
- Guide
- Reference
- Cookbook
- Quicktips
- Screencasts
- Glossary
- Archive
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()
$query->aggregate()

Builds an aggregation query. This is used by all the aggregation methods above
$query->all()

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

Shortcut to attach a where clause with an AND operator. Check out the where() method docs for additional info.
$query->avg()

Builds an average query
$query->bindings()

Attaches additional bindings to the query. Also can be used as getter for all attached bindings by not passing an argument.
$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. If enabled, the query will return an array with all important info about the query instead of actually executing the query and returning results
$query->delete()

Fires a delete query
$query->distinct()

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

Enables failing queries. If enabled queries will no longer fail silently but throw an exception
$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. Check out the where() method docs for additional info.
$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#L734

$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 on GitHub

Kirby

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

🇪🇺 Made in Europe

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