caoson/simple_query

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

Requires

• ext-pdo: *
• ludal/mysql-querybuilder: ^0.5.2
• vlucas/phpdotenv: ^5.5

Requires (Dev)

• symfony/var-dumper: ^6.2

MIT

• caovanson2121231267312

README

composer require caoson/simple_query

• Sử dụng Query builder

$user = DB::table('users')
        ->select('*')
        ->where('first_name',"like", "'%c%'")
        ->get();
dd($user);

$user = DB::table('users')
        ->select('id','name')
        ->get();
dd($user);

• Sử dụng Model

• Truy vấn bảng users

    $users = User::limit(3)->orderBy("id","desc")->where("first_name","like", "'%h%'")->get();
    dd($users);

• Thêm 1 bản ghi:

$user = User::create([
    "email" => "[e-mail]",
    "password" => "12345678",
    "first_name" => "hhhhhhhhhhhhhh",
    "last_name" => "abcabcabcbac",
    "full_name" => "12313123",
    "phone" => "1231231313",
    "address" => "123",
    "user_name" => "123",
    "role" => "user",
]);

• Cập nhật 1 bản ghi:

$data = [
    "email" => "[e-mail]",
    "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);

• xóa 1 bản ghi:

$user = User::where("id", "=", "21")->delete();