ziyoren/database

Database components supporting connection pooling.

Maintainers

Details

github.com/ziyoren/database

Source

Issues

Installs: 24

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 1

Forks: 0

Open Issues: 0

1.1.0 2020-12-09 15:57 UTC

Requires

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_oci8: For Oracle version 8 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 9991327df452066c6d38f0af18b911fda1f42fd5

  • Sunline <asun.woop@66580.cn>

This package is auto-updated.

Last update: 2024-04-16 16:58:50 UTC

README

A database component based on meboo, which can run in php-fpm and swoole environment, and support database connection pool in swoole.

Requirement

  • PHP7.1+
  • PDO extension installed.
  • Swoole 4.4+

Get Started

Install

$ composer require ziyoren/database

update

$ composer update

PDO Databases

require 'vendor/autoload.php';

use ziyoren\Database\BaseModel; // swoole(支持数据库连接池)
//use ziyoren\Database\PDO;       // 传统的php-fpm 无连接池

//For database configuration, see ziyoren\Database\DbConfig.php
$db = new BaseModel(); //swoole模式下使用
//$db = new PDO(); //php-fpm模式下使用

$db->insert('account', [
    'user_name' => 'foo',
    'email' => 'foo@bar.com'
]);

$data = $db->select('account', [
    'user_name',
    'email'
], [
    'user_id' => 50
]);

echo json_encode($data);

Redis pools

require 'vendor/autoload.php';

use ziyoren\Database\BaseRedis;

//For Redis configuration, see /config/redis.php
$redis = new BaseRedis();
$redis->set('key', 'value');
$rst = $redis->get('key');

echo $rst; //value

License

ziyoren/database is under the MIT license.

Links