Database
A simple database class
- $database->affected()
- $database->connect()
- $database->connection()
- $database->createTable()
- $database->dropTable()
- $database->escape()
- $database->execute()
- $database->fail()
- $database->lastError()
- $database->lastId()
- $database->lastQuery()
- $database->lastResult()
- $database->name()
- $database->prefix()
- $database->query()
- $database->sql()
- $database->table()
- $database->trace()
- $database->type()
- $database->validateColumn()
- $database->validateTable()
- Database::instance()
- Database::instances()
- new Database()
Example
Create a table
$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]
]);Since 4.2.0
Newly added options are the unsigned option for integers and size option for varchars as well as the float and decimal types.