Configure & use a database
FMVC provides an abstracted connection to SQL Databases. This abstraction is called:
Core/Data/SqlDataBase. This abstraction enables automatic configuration from a pool of previously defined connections. Those connections can be specified in
Configure a database connection
Internally, FMVC used PDO to provide a generic approach to connecting to all kinds of databases. To generate the corresponding connection string, the framework loads the components from the configuration specified by the string passed to it's constructor:
Depending on the type of the database (especially SQLite3) the format of the connection string differs. Here are the two supported formats:
- Normal SQL-databases:
Connect with your peers... aaahm sorry, I mean database
Now that we have the credentials, we are ready to connect to our database. Luckily, our database class does that for us.
A connection is cool, yeah, but what a database really does for us is providing access to persistent data.
Core/Data/SqlDataBase also has some for that in it's pocket:
exec(string $query): int provides a point to execute ddl statements like insert, update or delete statements. This method will only pass on the status returned from the query.
This query would return 1 as 1 dataset was affected.
query(string $query): array is the interface point for all your DataQueryLanguage stuff. Does not matter if you want one or - maybe you already guessed it - a bazillion datasets. Just pass your query to this baby and it will fulfill your wildest data dreams ...or return an empty array, if you fucked it up.
In this case print_r would output all datasets found in the users table.
We hope you got some insight into how FMVC works with databases. Have fun!