bakaphp / phalcon-api

library/Providers/DatabaseProvider.php

<?php

End of line character is invalid; expected "\n" but found "\r\n"

declare(strict_types=1);


namespace Gewaer\Providers;


use function Gewaer\Core\envValue;

use Phalcon\Db\Adapter\Pdo\Mysql;

use Phalcon\Di\ServiceProviderInterface;

use Phalcon\DiInterface;


class DatabaseProvider implements ServiceProviderInterface

{

    /**

     * @param DiInterface $container

     */

    public function register(DiInterface $container)

    {

        $container->setShared(

            'db',

            function () {

                $options = [

                    'host' => envValue('DATA_API_MYSQL_HOST', 'localhost'),

                    'username' => envValue('DATA_API_MYSQL_USER', 'nanobox'),

                    'password' => envValue('DATA_API_MYSQL_PASS', ''),

                    'dbname' => envValue('DATA_API_MYSQL_NAME', 'gonano'),

                    'charset' => 'utf8',

                ];


                $connection = new Mysql($options);

                // Set everything to UTF8

                $connection->execute('SET NAMES utf8mb4', []);


                return $connection;

            }

        );

    }

}