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 Database()

Creates a new Database instance
$database->affected()

Returns the number of affected rows for the last query
$database->connect()

Connects to a database
$database->connection()

Returns the currently active connection
$database->createTable()

Creates a new table
$database->dropTable()

Drops a table
$database->escape()

Escapes a value to be used for a safe query NOTE: Prepared statements using bound parameters are more secure and solid
$database->execute()

Executes a sql query, which is expected to not return a set of results
$database->fail()

Sets the exception mode
Database::instance()

Returns one of the started instances
Database::instances()

Returns all started instances
$database->lastError()

Returns the last db error
$database->lastId()

Returns the last id if available
$database->lastQuery()

Returns the last query
$database->lastResult()

Returns the last set of results
$database->name()

Returns the name of the database
$database->prefix()

Returns the used table name prefix
$database->query()

Executes a sql query, which is expected to return a set of results
$database->sql()

Returns the correct Sql generator instance for the type of database
$database->table()

Sets the current table, which should be queried. Returns a Query object, which can be used to build a full query for that table
$database->trace()

Adds a value to the db trace and also returns the entire trace if nothing is specified
$database->type()

Returns the used database type
$database->validateColumn()

Checks if a column exists in a specified table
$database->validateTable()

Checks if a table exists in the current database

Database::instances()

Returns all started instances

kirby/src/Database/Database.php#L135

Database::instances(): array

Return type

array

Parent class

Kirby\Database\Database

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