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',...
02 September, 2020
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|...
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|...
Get data array in array laravel
Array( [0] => Array ( [id] => 8 [restaurant_id] => 5 [category_id] => 1 [deleted_at] => [created_at]...
Get data array in array laravel
Array( [0] => Array ( [id] => 8 [restaurant_id] => 5 [category_id] => 1 [deleted_at] => ...
Push array or inArray check id
In Controller :: $service_names = array(); if(!empty($services_total)){ foreach ($services_total as $value) { $service_names[] .= $value['name']; ...
Push array or inArray check id
In Controller ::
$service_names = array(); if(!empty($services_total)){ foreach ($services_total as $value) { $service_names[] .= $value['name']; ...
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, ...
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, ...
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({ ...
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({
...
24 August, 2020
start xampp in ubuntu
To start XAMPP run the following and the command will return a list of running services: sudo /opt/lampp/lampp start To stop XAMPP run the command below and it will return a list of the stopped services. sudo /opt/lampp/lampp stop You...
start xampp in ubuntu
To start XAMPP run the following and the command will return a list of running services:
sudo /opt/lampp/lampp start
To stop XAMPP run the command below and it will return a list of the stopped services.
sudo /opt/lampp/lampp stop
You...
Running XAMPP on Ubuntu using Terminal
To start XAMPP run the following and the command will return a list of running services: sudo /opt/lampp/lampp start To stop XAMPP run the command below and it will return a list of the stopped services. sudo /opt/lampp/lampp stop You...
Running XAMPP on Ubuntu using Terminal
To start XAMPP run the following and the command will return a list of running services:
sudo /opt/lampp/lampp start
To stop XAMPP run the command below and it will return a list of the stopped services.
sudo /opt/lampp/lampp stop
You...