How to do an INNER JOIN on multiple columns
You can JOIN with the same table more than once by giving the joined tables an alias, as in the following example:
SELECT
…
Tutorials
12 lessons per page
What is the difference between “INNER JOIN” and “OUTER JOIN”?
Assuming you're joining on columns with no duplicates, which is a very common case: An inner join of A and B gives the re…
September 02, 2020
Read more
Laravel 7: Adding where clause to a join condition
if you want add more condition on a join add more $join->on or $join->orOn.
if you want to add a condition to your firs…
September 02, 2020
Read more
Advance Laravel Keep Route Best Way
<?php
use Illuminate\Support\Facades\Route;
/*
|--------------------------------------------------------------------------
| …
September 02, 2020
Read more
Get data array in array laravel
Array
(
[0] => Array
(
[id] => 8
[restaurant_id] => 5
[category_id] =>…
September 02, 2020
Read more
Push array or inArray check id
In Controller ::
$service_names = array();
if(!empty($services_total)){
foreach ($service…
September 02, 2020
Read more
Regex pattern validation in laravel
Regex pattern validation in laravel
'name' => ['required', 'regex:^[A-ZÀÂÇÉÈÊËÎÏÔÛÙÜŸÑÆŒa-zàâçéèêëîïôû…
September 02, 2020
Read more
Validation Rule in jquery and laravel
Laravel:
$validatedData = $request->validate
([
'name'=> ['required', 'regex:^[A-ZÀÂÇÉÈÊ…
September 02, 2020
Read more
Social Plugin