jnbruno/forrest

validator and database middleware for PHP

forrest

validator and database middleware for PHP, _(*1)

Get Started

Install via composer

Add forrest to composer.json configuration file., _(*2)

$ composer require jnbruno/forrest

And update the composer, _(*3)

$ composer update

// Initialize with composer autoload
require 'vendor/autoload.php';


// Initialize
$forrest = new forrest([
    'database_type' => 'mysql',
    'database_name' => 'name',
    'server' => 'localhost',
    'username' => 'your_username',
    'password' => 'your_password',
    'charset' => 'utf8'
]);

SELECT

//select($table,$join,$where)
$test->select('test',[
            'number as this_is_number',
            'text',
            'email'
            ],
            [
            "LIMIT" => 5,
            "ORDER" => "number ASC"
]);

INSERT

//table($tablename)
$result = $test ->table('test')
//add rules condition
                ->rules([
                            'number'     => "required|numeric",
                            'text'       => "required|min_len,6",
                            'email'      => "required|valid_email"
                        ])

//validate then insert if valid
                ->insert([
                            'number'     => "1",
                            'text'       => "Forrest Test Text",
                            'email'      => "me@jnbruno.com"
                        ]);

UPDATE

$result = $test ->table('test')
                ->rules([
                            'number'            => "required|numeric",
                            'text'              => ["required|min_len,6", "trim"],
                            'email'             => "required|valid_email"
                        ])

            //  ->update($items, $where)
                ->update([
                                'number'       => "1",
                                'text'         => "                 Forrest Test Update                 ",
                                'email'        => "me@jnbruno.com"
                        ], ['test_id' => 1]);

License

Forrest is under the MIT license., _(*4)

DEPENDENCIES

• Medoo : http://medoo.in
• Gump : https://github.com/Wixel/GUMP