[อั๋น ทรงวุฒิ]

https://redbeanphp.com/index.php

โค๊ด: [Select]

<?php
    require 'rb.php';
    R::setup( 'mysql:host=localhost;dbname=mydatabase', 'myusername', 'mypassword' );
    $books = R::getAll(
    'SELECT * FROM book WHERE price < ? ',
    [ 50 ] );

    print_r($books);
?>

[อั๋น ทรงวุฒิ]

เจอคู่แข่งแล้วครับ

https://medoo.in/

Less than 100 KB, portable with only one file
Supports all SQL databases, including MySQL, MSSQL, SQLite, MariaDB, PostgreSQL, Sybase, Oracle and more

Works well with every PHP frameworks, like Laravel, Codeigniter, Yii, Slim, and framework which supports singleton extension or composer


การเรียกใช้งาน

composer require catfan/Medoo

โค๊ด: [Select]

    // If you installed via composer, just use this code to requrie autoloader on the top of your projects.
    require 'vendor/autoload.php';
     
    // Using Medoo namespace
    use Medoo\Medoo;
     
    // Initialize
    $database = new Medoo([
        'database_type' => 'mysql',
        'database_name' => 'name',
        'server' => 'localhost',
        'username' => 'your_username',
        'password' => 'your_password'
    ]);
     
    // Enjoy
    $database->insert('account', [
        'user_name' => 'foo',
        'email' => '[email protected]'
    ]);
     
    $data = $database->select('account', [
        'user_name',
        'email'
    ], [
        'user_id' => 50
    ]);
     
    echo json_encode($data);
     
    // [
    //     {
    //         "user_name" : "foo",
    //         "email" : "[email protected]"
    //     }
    // ]