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 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 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