查询器使用

插入数据

  1. $values = [
  2.     'name'        => 'name',
  3.     'sex'         => 1,
  4.     'description' => 'this my desc',
  5.     'age'         => 99,
  6. ];
  7. $result = Query::table(User::class)->insert($values)->getResult();

删除数据

  1. $result = Query::table(User::class)->where('id', 1)->delete()->getResult();

更新数据

  1. $result = Query::table(User::class)->where('id', 1)->update(['name' => 'name666'])->getResult();

查询数据

  1. $result = Query::table(User::class)->where('id', 1)->limit(1)->get()->getResult();

聚合操作

  1. $count    = Query::table(User::class)->count('id', 'userCount')->getResult();
  2. $countNum = $count['userCount'];
  4. $ageNum    = Query::table(User::class)->sum('age', 'ageNum')->getResult();
  5. $ageNum = $ageNum['ageNum'];
  7. $maxAge = Query::table(User::class)->max('age', 'maxAge')->getResult();
  8. $maxAge = $maxAge['maxAge'];
  10. $minAge    = Query::table(User::class)->min('age', 'minAge')->getResult();
  11. $minAge = $minAge['minAge'];
  13. $avgAge = Query::table(User::class)->avg('age', 'avgAge')->getResult();
  14. $avgAge = $avgAge['avgAge'];

切换数据库实例

  1. $data   = [
  2.     'name'        => 'name',
  3.     'sex'         => 1,
  4.     'description' => 'this my desc instance',
  5.     'age'         => mt_rand(1, 100),
  6. ];
  7. $userid = Query::table(User::class)->selectInstance('other')->insert($data)->getResult();
  8. $user2 = Query::table(User::class)->selectInstance('other')->where('id', $userid)->limit(1)->get()->getResult();

切换数据库

  1. $data   = [
  2.     'name'        => 'name',
  3.     'sex'         => 1,
  4.     'description' => 'this my desc table',
  5.     'age'         => mt_rand(1, 100),
  6. ];
  7. $userid = Query::table(User::class)->selectDb('test2')->insert($data)->getResult();
  8. $user2 = Query::table(User::class)->selectDb('test2')->where('id', $userid)->limit(1)->get()->getResult();