Database guide
The Database module provides your Cherrycake application with a standardized interface to connect to database servers like MySQL and MariaDB.
Database providers
To connect to database servers you must configure a database provider. Just like with the Cache module, you can configure multiple providers to connect to multiple databases at the same time.
Cherrycake is currently only compatible with MySQL and MariaDB servers.
Database providers are configured in the Database configuration file
Database.config.php.For example, if you want to connect to a MySQL database server, your Cache configuration file would look like this:1
<?php
2
​
3
namespace Cherrycake;
4
​
5
$DatabaseConfig = [
6
"providers" => [
7
"main" => [
8
"providerClassName" => "DatabaseProviderMysql",
9
"config" => [
10
"host" => "localhost",
11
"user" => "user",
12
"password" => "password",
13
"database" => "cherrycake",
14
"charset" => "utf8mb4",
15
"cacheProviderName" => "engine"
16
]
17
]
18
]
19
];
Copied!
Note we called our database providermain
Modules that depend on Database
Just like Cache, some other modules use Database for many purposes, for example: The Session module uses a database connection to store information about sessions.
That's why in the Cherrycake Skeleton boilerplate you'll find the/installdirectory containing some SQL scripts to create the tables some this modules need.
Last modified 2yr ago
Copy link