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 first select, add it outside join function.DB::table('users')->join('contacts', function($join){ $date = date('Y-m-d'); $join->on('users.id', '=', 'contacts.user_id');})->where('contacts.effective_date',...

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 first select, add it outside join function. DB::table('users') ->join('contacts', function($join) { $date = date('Y-m-d'); $join->on('users.id', '=', 'contacts.user_id'); }) ->where('contacts.effective_date',...

Read More

Advance Laravel Keep Route Best Way

<?phpuse Illuminate\Support\Facades\Route;/*|--------------------------------------------------------------------------| Web Routes|--------------------------------------------------------------------------|| Here is where you can register web routes for your application. These| routes are loaded by the RouteServiceProvider within a group which|...

Read More

Advance Laravel Keep Route Best Way

<?phpuse Illuminate\Support\Facades\Route;/*|--------------------------------------------------------------------------| Web Routes|--------------------------------------------------------------------------|| Here is where you can register web routes for your application. These| routes are loaded by the RouteServiceProvider within a group which|...

Read More

Get data array in array laravel

Array(    [0] => Array        (            [id] => 8            [restaurant_id] => 5            [category_id] => 1            [deleted_at] =>             [created_at]...

Read More

Get data array in array laravel

Array(    [0] => Array        (            [id] => 8            [restaurant_id] => 5            [category_id] => 1            [deleted_at] =>            ...

Read More

Push array or inArray check id

In Controller ::  $service_names = array();                if(!empty($services_total)){                    foreach ($services_total as $value) {                        $service_names[] .= $value['name']; ...

Read More

Push array or inArray check id

In Controller ::  $service_names = array();                if(!empty($services_total)){                    foreach ($services_total as $value) {                        $service_names[] .= $value['name']; ...

Read More

Regex pattern validation in laravel

Regex pattern validation in laravel'name' => ['required', 'regex:^[A-ZÀÂÇÉÈÊËÎÏÔÛÙÜŸÑÆŒa-zàâçéèêëîïôûùüÿñæœ0-9_.,()]+$^']'name' => ['required', 'regex:/^[A-ZÀÂÇÉÈÊËÎÏÔÛÙÜŸÑÆŒa-zàâçéèêëîïôûùüÿñæœ0-9_.,() ]+$/']address:{                minlength:2,                maxlength:500, ...

Read More

Regex pattern validation in laravel

Regex pattern validation in laravel 'name' => ['required', 'regex:^[A-ZÀÂÇÉÈÊËÎÏÔÛÙÜŸÑÆŒa-zàâçéèêëîïôûùüÿñæœ0-9_.,()]+$^'] 'name' => ['required', 'regex:/^[A-ZÀÂÇÉÈÊËÎÏÔÛÙÜŸÑÆŒa-zàâçéèêëîïôûùüÿñæœ0-9_.,() ]+$/'] address:{                minlength:2,           ...

Read More

Validation Rule in jquery and laravel

Laravel:$validatedData = $request->validate    ([    'name'=> ['required', 'regex:^[A-ZÀÂÇÉÈÊËÎÏÔÛÙÜŸÑÆŒa-zàâçéèêëîïôûùüÿñæœ0-9_.,()]+$^'],    ]);Jquery<script>    // Basic Example with form    var form = $("#example-form");    form.validate({       ...

Read More

Validation Rule in jquery and laravel

Laravel: $validatedData = $request->validate     ([     'name'=> ['required', 'regex:^[A-ZÀÂÇÉÈÊËÎÏÔÛÙÜŸÑÆŒa-zàâçéèêëîïôûùüÿñæœ0-9_.,()]+$^'],     ]); Jquery <script>     // Basic Example with form     var form = $("#example-form");     form.validate({  ...

Read More