PHP code example of luffyzhao / luffy-db

1. Go to this page and download the library: Download luffyzhao/luffy-db library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

luffyzhao / luffy-db example snippets


     use luffyzhao\db\Db;

    /**
     * 测试读写分离和分布式
     */
    $database = [
        // 数据库类型
        'type' => 'mysql',
        // 服务器地址
        'hostname' => '127.0.0.1,127.0.0.1',
        // 数据库名
        'database' => 'test,test1',
        // 用户名
        'username' => 'root',
        // 密码
        'password' => '123456',
        // 端口
        'hostport' => '3306',
        // 分布式
        'deploy' => 1,
        // 读写分享
        'rw_separate' => true,
        // 调试
        'debug' => function ($messgaes) {
            echo "[" . date('Y-m-d H:i:s') . "]" . $messgaes . "\n";
        },
    ];
    $db = new Db($database);
    //插入数据
    $res = $db->table('test_db')->data('name', '战非')->data('phone', '15215214578')->insert();

    // 没有数据
    $res = $db->table('test_db')->where('phone', '=', '15215214578')->findAll();
    // 有数据 (事务开始之后拿主库里的数据)
    $db->startTrans();
    $res = $db->table('test_db')->findAll();
    $db->commit();