Answers for "laravel query builder where and"

PHP

laravel orWhere

$camps = $field->camps()->where('status', 0)->where(function ($q) {
    $q->where('sex', Auth::user()->sex)->orWhere('sex', 0);
})->get();

Posted by: Guest on October-20-2020

Source

laravel db::query update

DB::table('user')->where('email', $userEmail)->update(array('member_type' => $plan));

Posted by: Guest on November-19-2020

Source

laravel query builder select

use Illuminate\Support\Facades\DB;

$users = DB::table('users')
            ->select('name', 'email as user_email')
            ->get();

Posted by: Guest on August-14-2021

Source

laravel query builder

$email = DB::table('users')->where('name', 'John')->value('email');

Posted by: Guest on September-11-2021

Source

Laravel query builder toSql

$query = DB::table('table')->whereIn('some_field', [1,2,30]);

$sql = $query->toSql();

$bindings = $query->getBindings();

Posted by: Guest on May-16-2021

Source

Code answers related to "laravel query builder where and"

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java