falkm/hubert-db

Hubert extension for Database connection

Hubert Database Extension

Installation

Hubert is available via Composer:, _(*1)

{
    "require": {
        "falkm/hubert-db": "1.*"
    }
}

Usage

Create an index.php file with the following contents:, _(*2)

<?php

require 'vendor/autoload.php';

$app = new hubert\app();

$config = array(
    "factories" => array(
         "dbAdapter" => array(hubert\extension\db\factory::class, 'get')
        ),
    "config" => array(
        "display_errors" => true,
        "db" => array(
            'driver'   => 'Pdo_Mysql',
            'database' => 'db_test',
            'username' => 'user',
            'password' => 'pass',
        ),
    "routes" => array(
        "home" => array(
                "route" => "/", 
                "target" => function(){
                    $dbAdapter = hubert()->dbAdapter;
                    $result = $dbAdapter->query('SELECT * FROM `db_test` WHERE `id` = ?', [1]);
                    print_r($result->current());

                    print_r(json_encode(\model\test::selectOne(["id" => 1])));

                    print_r(json_encode(\model\test::selectAll()));
                }
            ),
            "install" => array(
                "route" => "/install", 
                "target" => function(){
                    $factory = new \hubert\extension\db\factory();
                    $factory->createTableByModel(\model\test::class);
                }
            )
);

hubert($config);
hubert()->core()->run();

For more see the example in this repository., _(*3)

components

• Zend Database engine zendframework/zend-db

License

The MIT License (MIT). Please see License File for more information., _(*4)