tisuchi

@minhankyaw

Where you want to apply this?

You can use multiple where clause.

$data['ads'] = PostAd::where('category_id',$category_id)
               ->where('adtitle','LIKE','%'.$search.'%')
               ->get();

Or

$data['ads'] = PostAd::where([
                   ['category_id',$category_id],
                   ['adtitle','LIKE','%'.$search.'%']
               ])
               ->get();

@su3158y

You can add wathever validation rules you want in the Laravel RegisterController. Just update the rule for password with the extra limitations:

https://github.com/laravel/laravel/blob/master/app/Http/Controllers/Auth/RegisterController.php#L49

return Validator::make($data, [
    'name' => ['required', 'string', 'max:255'],
    'email' => ['required', 'string', 'email', 'max:255', 'unique:users'],
    'password' => ['required', 'string', 'min:8', 'confirmed'], // <-- This one
]);

You can use multiple where clause.

$data['ads'] = PostAd::where('category_id',$category_id)
               ->where('adtitle','LIKE','%'.$search.'%')
               ->get();

Or

$data['ads'] = PostAd::where([
                   ['category_id',$category_id],
                   ['adtitle','LIKE','%'.$search.'%']
               ])
               ->get();

@jerauf

The place where you put the domain name. It most probably in the mailgun settings.

@abuhenam

Instead of using Mail::failures() you can use !empty(Mail::failures()) or count(Mail::failures()) > 0.

Mail::failures() Function returns an array of Email addresses which are failed.

Ref: https://laravel.com/api/6.x/Illuminate/Contracts/Mail/Mailer.html#method_failures

OMG. Nono. You are right @bobbybouwmann I read something wrong. I read upload instead of update. Thank you.

@sumitkumarm

I found a related answer. It might be helpful for you.

You can try this-

$data = DB::table('table_name')
->select(
  DB::raw("TRIM(CONCAT(field1,' ',field2,' ',field3)) AS Name")
)->get();

Ref: https://stackoverflow.com/questions/55319163/how-to-perform-trim-and-concat-in-laravel-query-builder

@abuhenam

Instead of using Mail::failures() you can use !empty(Mail::failures()) or count(Mail::failures()) > 0.

Mail::failures() Function returns an array of Email addresses which are failed.

Ref: https://laravel.com/api/6.x/Illuminate/Contracts/Mail/Mailer.html#method_failures

@bobbybouwmann Correct me if I am wrong. Doesn't it (enctype="multipart/form-data") required for file upload control over html form?

@ramazan

You can simply add multiple in your select element.

Like this-

<select multiple>

BTW, you have to make sure, your form has enctype property.

enctype="multipart/form-data"

@sumitkumarm

I found a related answer. It might be helpful for you.

You can try this-

$data = DB::table('table_name')
->select(
  DB::raw("TRIM(CONCAT(field1,' ',field2,' ',field3)) AS Name")
)->get();

Ref: https://stackoverflow.com/questions/55319163/how-to-perform-trim-and-concat-in-laravel-query-builder

@ramazan

What is your error here?

@jerauf

Your url has https:/// in it. Correct that and you should be fine.

Ref: https://stackoverflow.com/questions/55971482/i-have-set-up-my-domain-and-secret-in-my-app-env-but-i-keep-getting-unable-to

@charlesk

Try this-

Visitor::whereYear('created_at', Carbon::now()->year)
->select(DB::raw("MONTH(created_at) month"),DB::raw("count('month') as vistors_count"))
       ->groupby('month')
       ->get();

@charlesk

Try this-

Visitor::whereYear('created_at', Carbon::now()->year)
->select(DB::raw("MONTH(created_at) month"),DB::raw("count('month') as vistors_count"))
       ->groupby('month')
       ->get();

@ahoi

Mainly most of the api endpoints are protected. Since you have a access token, you should easily able to access any protected api. Now the only question is scope. Does the scope allows you to access or not.

@charlesk

So, what you are expecting now? Do you expect the whole month list?

@charlesk

Do you get any error? or you have output?

@monamuhr77

Here is the problem.

When you want to add an extra route to your resource route, add it above the resource route.

Try this-

 Route::get('admin/{id}', '[email protected]')->name('admin.deactivate');
 Route::resource('admin', 'AdminController');

@monamuhr77

Here is the problem.

When you want to add an extra route to your resource route, add it above the resource route.

Try this-

 Route::get('admin/{id}', '[email protected]')->name('admin.deactivate');
 Route::resource('admin', 'AdminController');

@diliphiraparak

I believe your problem is somewhere in $target = $request->target line.

Try this-

$target = $request->target;
$targetJson = json_decode($target);
$fruits = $targetJson['fruits'];

@diliphiraparak

I believe your problem is somewhere in $target = $request->target line.

Try this-

$target = $request->target;
$targetJson = json_decode($target);
$fruits = $targetJson['fruits'];

@monamuhr77

Show your route.

@monamuhr77

First check whether you have the right route or not, that you are trying to access. May be this command will help you-

php artisan route:list

@ssuvin94

How about this? https://medium.com/@adnanxteam/how-to-use-laravel-with-socket-io-e7c7565cc19d

@sajjadali97

In the server, it's normally cased sensitive.

So, it will be

use App\Login;

instead of

use app\Login;

@ssuvin94

How about this? https://medium.com/@adnanxteam/how-to-use-laravel-with-socket-io-e7c7565cc19d

@ssuvin94

Have you checked the official documentation? Isn't that easy enough? https://laravel.com/docs/6.x/notifications

@sajjadali97

In the server, it's normally cased sensitive.

So, it will be

use App\Login;

instead of

use app\Login;

@felloz Unfortunately you cannot delete posts in Laracasts.

@irankhosravi

It's a plan id that you are using in where() condition.

@irankhosravi

Try this-

$orders = Order::where('plan_id', $planId)->get();

$orders->count()

@theonlinethomas Please mark as solved if you feel that @sinnbeck provides you the right info.

@nafeeur10

You are planning to send emails to their client on behalf of them from their email address?

@nafeeur10

Check these-

https://appdividend.com/2018/03/05/send-email-in-laravel-tutorial/ https://medium.com/@janaksan_/laravel-5-4-send-email-b78cca4c4569

@ristlin

I believe it has been used for translation.

Check more details here: https://laravel.com/docs/6.x/localization#retrieving-translation-strings

@ristlin

I believe it has been used for translation.

Check more details here: https://laravel.com/docs/6.x/localization#retrieving-translation-strings

@theonlinethomas

Try this-

 $postQuery = Foundation::query()
            ->join('foundation_sector', 'foundation_sector.foundation_id', '=', 'foundations.id')
            ->join('sectors', 'sectors.id', '=', 'foundation_sector.sector_id')
            ->groupBy('foundations.id');

        foreach ($sectors as $sector) {
            $postQuery = $postQuery->havingRaw('SUM(sectors.title = ?)', [$sector]);
        }

@theonlinethomas

Try this-

 $postQuery = Foundation::query()
            ->join('foundation_sector', 'foundation_sector.foundation_id', '=', 'foundations.id')
            ->join('sectors', 'sectors.id', '=', 'foundation_sector.sector_id')
            ->groupBy('foundations.id');

        foreach ($sectors as $sector) {
            $postQuery = $postQuery->havingRaw('SUM(sectors.title = ?)', [$sector]);
        }

@shirshadebnath

If it doesn't work after running the command that @martal suggested, then try after restarting (if you use php artisan serve, then just stop and run again) your PHP Server.

It seems that the env variable is not reflecting.

You don't need to put the id on an array. Just use the id as the second parameter of route() function.

Try -

<form action="{{route('sub-admin.update',1)}}" id="edit-sub-admin" method="POST" enctype="multipart/form-data">
</form>

You don't need to put the id on an array. Just use the id as the second parameter of route() function.

Try -

<form action="{{route('sub-admin.update',1)}}" id="edit-sub-admin" method="POST" enctype="multipart/form-data">
</form>

@jannatkhan

You can directly use where before group by or after.

$destination = Trip::select('destination')
      ->selectRaw('COUNT(*) AS count')
      ->where('client_id', $userClientId)
      ->groupBy('destination')
      ->orderByDesc('count')
      ->limit(5)
      ->get();

@mbo You can easily use cpanel for laravel that bring some other services for you out of the box. https://www.youtube.com/watch?time_continue=38&v=pBTvXKGvrAA&feature=emb_logo

Ofcourse you will get more tutorials how to do that.

@jannatkhan

You can directly use where before group by or after.

$destination = Trip::select('destination')
      ->selectRaw('COUNT(*) AS count')
      ->where('client_id', $userClientId)
      ->groupBy('destination')
      ->orderByDesc('count')
      ->limit(5)
      ->get();

@emianakib

You can just generate the proper datetime format (without minutes) and use DATE_TRUNC() to compare it:

$dateNowToMinute = Carbon::now()->format('Y-m-d H:i');
$recordings = Recording::with('therapy')
    ->where(DB::raw("DATE_TRUNC('minute', executes_at)"), '=', $dateNowToMinute)
    ->get();

@emianakib

You can just generate the proper datetime format (without minutes) and use DATE_TRUNC() to compare it:

$dateNowToMinute = Carbon::now()->format('Y-m-d H:i');
$recordings = Recording::with('therapy')
    ->where(DB::raw("DATE_TRUNC('minute', executes_at)"), '=', $dateNowToMinute)
    ->get();

@mizzaty

Try to add the start_date to the $dates attribute in your Project model

class Project extends Model
{
    protected $dates = ['created_at', 'updated_at', 'expiry_date', 'start_date'];
}

If the attribute is in $dates, the field will be returned as an instance of Carbon and not a simple string, then Maatwebsites Excel will use it to get the right format.

@mizzaty

Try to add the start_date to the $dates attribute in your Project model

class Project extends Model
{
    protected $dates = ['created_at', 'updated_at', 'expiry_date', 'start_date'];
}

If the attribute is in $dates, the field will be returned as an instance of Carbon and not a simple string, then Maatwebsites Excel will use it to get the right format.