Skip to content

NimTechnology

Trình bày các công nghệ CLOUD một cách dễ hiểu.

  • Kubernetes & Container
    • Docker
    • Kubernetes
      • Ingress
    • Helm Chart
    • Isito-EnvoyFilter
    • Apache Kafka
      • Kafka
      • Kafka Connect
      • Lenses
    • Vault
    • Longhorn – Storage
    • VictoriaMetrics
  • CI/CD
    • ArgoCD
    • ArgoWorkflows
    • Spinnaker
    • Jenkins
  • Coding
    • Terraform
      • GCP – Google Cloud
      • AWS – Amazon Web Service
    • Golang
    • Laravel
    • Jquery & JavaScript
    • Git
    • Selenium
  • Log & Monitor
    • Prometheus
    • Grafana
    • ELK
      • Kibana
      • Logstash
  • BareMetal
  • Toggle search form

Các Lệnh query với Model của Laravel eloquent

Posted on June 11, 2021April 27, 2022 By nim No Comments on Các Lệnh query với Model của Laravel eloquent

Khi tìm 1 điều kiện không giống

Contents

  • WHERE NOT IN
  • Query database lớn hơn.
  • WHERE Like
  • WHERE REGEXP

WHERE NOT IN

Laravel Eloquent “WHERE NOT IN”

Query bình thường
SELECT book_name,dt_of_pub,pub_lang,no_page,book_price  
FROM book_mast        
WHERE book_price NOT IN (100,200);
Query với model

Query Builder:

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();
Eloquent:

SomeModel::select(..)->whereNotIn('book_price', [100,200])->get();

Query database lớn hơn.

$filters = Filter::all();        
$numberOfTheSameFilters = $filters->where('user_id', $user->id)    //(int)
                                            ->where('website_id', $websiteID)   //(int)
                                            ->where('col1', $filter["col1"])   //(string)
                                            ->where('col2', $filter["col2"])   //(string)
                                            ->where('col3', $filter["col3"])   //(string)
                                            ->where('col4', '<=', $filter["col4"])   //(int)
                                            ->where('col5', '>=', $filter["col5"])   //(int)
                                            ->where('col6', '<=', $filter["col6"])   //(int)
                                            ->where('col7', '>=', $filter["col7"])   //(int)
                                            ->where('col8', '<=', $filter["col8"])   //(int)
                                            ->where('col9', '>=', $filter["col9"])   //(int)
                                            ->count();

WHERE Like

https://www.positronx.io/laravel-eloquent-where-like-query-example-tutorial/

<?php
namespace App\Http\Controllers;
use App\Http\Controllers\Controller;
use App\Country;
class CountryController extends Controller
{
    public function index()
    {
        $term = 'France';
        $filterData = Country::table('countries')->where('name','LIKE','%'.$term.'%')
                      ->get();
        print_r($filterData);
    }
}

WHERE REGEXP

Cảm ơn bạn Tích đã chia sẻ kiến thức

SELECT owners FROM workloads WHERE owners REGEXP ',uc\.dang|^uc\.dang$|^uc\.dang,'

^: là bắt đầu
$: là kết thúc

mình có 1 user tên là uc.dang như nếu query like ‘%uc.dang%’ thì ăn nhầm user tên là phuc.dang

Laravel

Post navigation

Previous Post: Hướng dẫn sử dụng ingress nginx và control ingress bằng annotations trên k8s
Next Post: Hướng dẫn delete branch git bằng command

More Related Articles

Ví dụ về laravel http client response code Laravel
Hướng dẫn thêm column(cột) và change type column cho table bằng command trong Laravel Laravel
[Laravel] Các dòng code hữu ích trong laravel Laravel
[PHP] Hướng dẫn kiểm tra array rỗng hay null không? Laravel
[Laravel – Js] Laravel call/show JS flexibly Jquery & JavaScript
[Model/Laravel] hasMany Quan Hệ 1 Nhiều trong model Laravel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Tham Gia Group DevOps nhé!
Để Nim có nhiều động lực ra nhiều bài viết.
Để nhận được những thông báo mới nhất.

Recent Posts

  • Protected: My Assignment  June 24, 2022
  • [Spinnaker] Spinnaker writes too many logs – Reduce spinnaker log level June 22, 2022
  • [Jenkins] Jobs will be created automatically by Jenkins Job Builder June 20, 2022
  • [Postgresql] Install postgresql client and trying a few command postgresql. June 20, 2022
  • [Mount/Nextcloud] How do you mount a hard disk that was used windows into Linux. June 19, 2022

Archives

  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021

Categories

  • BareMetal
  • CI/CD
    • ArgoCD
    • ArgoWorkflows
    • Jenkins
    • Spinnaker
  • Coding
    • Git
    • Golang
    • Jquery & JavaScript
    • Laravel
    • Selenium
    • Terraform
      • AWS – Amazon Web Service
      • GCP – Google Cloud
  • Kubernetes & Container
    • Apache Kafka
      • Kafka
      • Kafka Connect
      • Lenses
    • Docker
    • Helm Chart
    • Isito-EnvoyFilter
    • Kubernetes
      • Ingress
    • Longhorn – Storage
    • Vault
    • VictoriaMetrics
  • Log & Monitor
    • ELK
      • Kibana
      • Logstash
    • Grafana
    • Prometheus
  • Uncategorized
  • Admin

Copyright © 2022 NimTechnology.