jove/medoo

轻量级的PHP数据库框架，用于加速开发

维护者

详细信息

github.com/LordDeveloper/Medoo

主页

源代码

问题

资助包维护！
Open Collective
paypal.me/AngelaonLai

安装: 48

依赖项: 0

建议者: 0

安全性: 0

星标: 1

关注者: 0

分叉: 1,152

类型:框架

v2.1.6 2022-05-10 02:47 UTC

Requires

  • php: >=7.3
  • ext-pdo: *

Requires (Dev)

Suggests

  • ext-pdo_dblib: For MSSQL or Sybase database on Linux/UNIX platform
  • ext-pdo_mysql: For MySQL or MariaDB database
  • ext-pdo_oci: For Oracle database
  • ext-pdo_pqsql: For PostgreSQL database
  • ext-pdo_sqlite: For SQLite database
  • ext-pdo_sqlsrv: For MSSQL database on both Window/Liunx platform

MIT 86ac2b376303f6c3c8e915be9051599b67a8a09e

  • Angel Lai <angel.woop@medoo.in>

databasesqlmysqlsqlitepostgresqllightweightmssqloraclephp frameworkmariadbdatabase library

This package is not auto-updated.

Last update: 2024-09-28 08:39:54 UTC

README

PHP 8.0+ 和已安装的 PDO 扩展。

入门

通过 composer 安装

将 Medoo 添加到 composer.json 配置文件中。

$ composer require jove/medoo:dev-master

并更新 composer

$ composer update

// Require Composer's autoloader.
require __DIR__ .'/vendor/autoload.php';

use Amp\Loop;
use function Medoo\connect;
use Medoo\Drivers\MySQL;

// Running the event loop
Loop::run(function () {
    // Connect the database.
    $database = connect(MySQL::class, [
        'host' => 'localhost',
        'database' => 'name',
        'username' => 'your_username',
        'password' => 'your_password'
    ]);
    
    // Enjoy
    yield $database->insert('account', [
        'user_name' => 'foo',
        'email' => 'foo@bar.com'
    ]);
    
    $data = yield $database->select('account', [
        'user_name',
        'email'
    ], [
        'user_id' => 50
    ]);
    
    echo json_encode($data);

    // [{
    //    "user_name" : "foo",
    //    "email" : "foo@bar.com",
    // }]
});