# Database

A simple database class

****

- Full class name: `Kirby\Database\Database`
- Alias: `Database`
- Source: <https://github.com/getkirby/kirby/tree/5.5.3/src/Database/Database.php#L26>

****

### Database

- [$database->__call()](https://getkirby.com/docs/reference/objects/database/database/__call.md)
- [new Database()](https://getkirby.com/docs/reference/objects/database/database/__construct.md)
- [$database->affected()](https://getkirby.com/docs/reference/objects/database/database/affected.md)
- [$database->connect()](https://getkirby.com/docs/reference/objects/database/database/connect.md)
- [$database->connection()](https://getkirby.com/docs/reference/objects/database/database/connection.md)
- [$database->createTable()](https://getkirby.com/docs/reference/objects/database/database/create-table.md)
- [$database->dropTable()](https://getkirby.com/docs/reference/objects/database/database/drop-table.md)
- [$database->escape()](https://getkirby.com/docs/reference/objects/database/database/escape.md)
- [$database->execute()](https://getkirby.com/docs/reference/objects/database/database/execute.md)
- [$database->fail()](https://getkirby.com/docs/reference/objects/database/database/fail.md)
- [Database::instance()](https://getkirby.com/docs/reference/objects/database/database/instance.md)
- [Database::instances()](https://getkirby.com/docs/reference/objects/database/database/instances.md)
- [$database->lastError()](https://getkirby.com/docs/reference/objects/database/database/last-error.md)
- [$database->lastId()](https://getkirby.com/docs/reference/objects/database/database/last-id.md)
- [$database->lastQuery()](https://getkirby.com/docs/reference/objects/database/database/last-query.md)
- [$database->lastResult()](https://getkirby.com/docs/reference/objects/database/database/last-result.md)
- [$database->name()](https://getkirby.com/docs/reference/objects/database/database/name.md)
- [$database->prefix()](https://getkirby.com/docs/reference/objects/database/database/prefix.md)
- [$database->query()](https://getkirby.com/docs/reference/objects/database/database/query.md)
- [$database->sql()](https://getkirby.com/docs/reference/objects/database/database/sql.md)
- [$database->table()](https://getkirby.com/docs/reference/objects/database/database/table.md)
- [$database->trace()](https://getkirby.com/docs/reference/objects/database/database/trace.md)
- [$database->type()](https://getkirby.com/docs/reference/objects/database/database/type.md)
- [$database->validateColumn()](https://getkirby.com/docs/reference/objects/database/database/validate-column.md)
- [$database->validateTable()](https://getkirby.com/docs/reference/objects/database/database/validate-table.md)

## Examples

### Create a table

```php
$database->createTable('product', [
    'id'          => ['type' => 'id'],
    'code'        => ['type' => 'varchar', 'size' => 50],
    'description' => ['type' => 'varchar'],
    'quantity'    => ['type' => 'int', 'unsigned' => false],
    'price'       => ['type' => 'decimal', 'precision' => 12, 'decimal_places' => 4]
]);
```