模型操作

    插入一条数据

    2. $ar = [];
    3. for ($i = 0; $i < 100; $i++) {
    4.     $ar[] = [
    5.         'name'  => 'name' . $i,
    6.         'email' => 'name' . $i . '@aa.com',
    7.         'age'   => rand(10, 70)
    8. }
    9. User::insert($ar, true);

    更新数据

    2. $row = User::whereIn('id', [61, 71, 81])->delete();
    3. echo $row . PHP_EOL;// 影响行数
    4. $one = User::find(66);

    查询

    1. // select * from users left join articles on users.id=articles.user_id where users.id>1
    2. $arr = User::where('users.id', '>', '1')->leftJoin('articles', 'users.id', 'articles.user_id')->findAll()->toArray();
    4. // select * from users left join articles on users.id=articles.user_id and articles.read_count>2 where users.id>1
    5. $arr = User::where('users.id', '>', '1')->leftJoin('articles', function (Join $q) {
    7. })->findAll()->toArray();