Database
A simple database class
-
new Database()
-
$database->affected()
-
$database->connect()
-
$database->connection()
-
$database->createTable()
-
$database->dropTable()
-
$database->escape()
-
$database->execute()
-
$database->fail()
-
Database::instance()
-
Database::instances()
-
$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()
Examples
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]
]);