Database

We are using Phinx for managing database.

There are 2 phinx config files in app/Config/. phinx.php is for the client host so do not change it.

now open phinx-local.php and right credentials for your mysql server.

You need to have pdo_mysql installed

For running phinx commands in your terminal you need it like so:

vendor/bin/phinx <COMMAND> -c app/Config/phinx-local.php

for more information about Phinx read its documentation on Phinx

Migrations

You need to create a migration file for each table you want to create or alter.

You can create new migrations like so:

 vendor/bin/phinx create -c app/Config/phinx-local.php CreateNewExampleTable

Migration files are located in app/Database/migrations

Seeds

You can create new migrations like so:

 vendor/bin/phinx seed:create -c app/Config/phinx-local.php MyExampleSeeder

Migration files are located in app/Database/seeds

Keep it in mind you should check if data already exists then insert it.

Read more on Phinx documentations.

DB Facades

You can use DB class to run query much easier.

Read more about this on Database.

Keep it mind that db prefix from WordPress configs are automatically added to table names

First import DB as so:

use Realtyna\MvcCore\Facades\DB;

then you can query Database:

DB::table('options')->where('id', 2)->get();

DB::table('users')->select(
        [
            'usermeta.meta_key',
            'usermeta.meta_value',
            'users.ID',
            'users.user_email'
        ]
    )->join(
        'usermeta',
        'users.ID',
        '=',
        'usermeta.user_id'
    )->get();


DB::table('posts')->first();

You can even run raw SQL Queries:

DB::select(DB::raw("SELECT * FROM wp_posts"))