caoson/simple_query

维护者

详细信息

github.com/caovanson2121231267312/simple_query_builder_php

源代码

问题

安装: 2

依赖: 0

建议者: 0

安全: 0

星标: 0

关注者: 1

分支: 0

开放问题: 0

v1.0.1 2022-12-28 09:52 UTC

Requires

Requires (Dev)

MIT dcf0a051b7bb91d16b0648783f53921d278b3931

  • caovanson2121231267312 <son1669063793.woop@gmail.com>

This package is auto-updated.

Last update: 2024-09-28 14:18:09 UTC

README

composer require caoson/simple_query

  • 使用查询构建器
$user = DB::table('users')
        ->select('*')
        ->where('first_name',"like", "'%c%'")
        ->get();
dd($user);
$user = DB::table('users')
        ->select('id','name')
        ->get();
dd($user);

  • 使用模型

  • 查询 users 表

    $users = User::limit(3)->orderBy("id","desc")->where("first_name","like", "'%h%'")->get();
    dd($users);
  • 添加一条记录
$user = User::create([
    "email" => "abc@gmail.com",
    "password" => "12345678",
    "first_name" => "hhhhhhhhhhhhhh",
    "last_name" => "abcabcabcbac",
    "full_name" => "12313123",
    "phone" => "1231231313",
    "address" => "123",
    "user_name" => "123",
    "role" => "user",
]);
  • 更新一条记录
$data = [
    "email" => "abc@gmail.com",
    "password" => "12345678",
    "first_name" => "hhhhhhhhhhhhhh",
    "last_name" => "abcabcabcbac",
    "full_name" => "12313123",
    "phone" => "1231231313",
    "address" => "123",
    "user_name" => "123",
    "role" => "user",
];

$user = User::where("id", "=", "2")->update($data);
  • 删除一条记录
$user = User::where("id", "=", "21")->delete();