MichalOravec

It's from error 500.

So make a custom http error pages

https://laravel.com/docs/8.x/errors#custom-http-error-pages

And then use localization from Laravel to translate that message

https://laravel.com/docs/8.x/localization

You have there same route more time

Route::get('books/{id}', [BooksController::class, 'destroy'])->name('books.destroy');

Problem is get here, it should be delete

https://laravel.com/docs/8.x/routing#available-router-methods

Route::delete('books/{id}', [BooksController::class, 'destroy'])->name('books.destroy');

By the way you can use resource controllers.

Docs: https://laravel.com/docs/8.x/controllers#resource-controllers

And look on this table, it shows you how it should look like

https://laravel.com/docs/8.x/controllers#actions-handled-by-resource-controller

It should be

$table->json('value');

And then use casting in your model

Just an example

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
    /**
     * The attributes that should be cast.
     *
     * @var array
     */
    protected $casts = [
        'value' => 'array',
    ];
}

https://laravel.com/docs/8.x/eloquent-mutators#array-and-json-casting

And what is this ['key' => 'value'] a string?! It's an array.

What are you trying to get?

Data from visitors_information?

And post whole controller method.

Because the error is not from that query.

You have there same route more time

Route::get('books/{id}', [BooksController::class, 'destroy'])->name('books.destroy');

Problem is get here, it should be delete

https://laravel.com/docs/8.x/routing#available-router-methods

Route::delete('books/{id}', [BooksController::class, 'destroy'])->name('books.destroy');

By the way you can use resource controllers.

Docs: https://laravel.com/docs/8.x/controllers#resource-controllers

And look on this table, it shows you how it should look like

https://laravel.com/docs/8.x/controllers#actions-handled-by-resource-controller

@kea_rajab So simple.

http://letmegooglethat.com/?q=how+to+set+virtual+host+in+xampp

Set virtual host for your project in xampp.

Just profile because yu don't have user.profile route.

<a href="{{ route('profile') }}" class="dropdown-item notify-item">

https://phptherightway.com/

https://twitter.com/samuelstancl/status/1272822437181378561

https://github.com/alexeymezenin/laravel-best-practices

Yes you can, for example

<?php

namespace App\Observers;

use App\Models\Tour ;

class TourObserver
{
    public function deleting(Tour $tour)
    {
        $tour->images->each->delete();
    }
}

Where images is relationship to TourImage model. And it calls an observer for TourImage

I also checked the source code and I think it's not possible.

Create an account for an user during a registration.

@sinnbeck Yeah exactly. It's a first hit on google.

@paddy76 Do you know google? Try to use it sometimes.

Add this to your own command.

protected $hidden = true;

@foreach($survey->questions->where('category', 'Class') as $question)
    <section class="question class">
        <div class="flex justify-center text-2hxl text-gray-700 font-medium pb-6">
            <span class="text-center w-3/5">{{ $question->some_property }}</span>
        </div>
    </section>
@endforeach

But better if you filter data in the controller.

In the ideal world. Just one table for all categories.

Schema::create('categories', function (Blueprint $table) {
    $table->id();
    $table->foreignId('parent_id')->nullable()->constrained('categories')->onDelete('cascade');
    $table->string('name');
    $table->string('slug')->unique();
    $table->text('description')->nullable();
    $table->tinyInteger('status')->default(0);
});

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Category extends Model
{
    public function children()
    {
        return $this->hasMany(Category::class, 'parent_id');
    }

    public function parent()
    {
        return $this->belongsTo(Category::class, 'parent_id');
    }
}

$categories = Category::with('children')->get();

I recommend to you read this whole section

https://laravel.com/docs/8.x/eloquent-relationships

In the ideal world. Just one table for all categories.

Schema::create('categories', function (Blueprint $table) {
    $table->id();
    $table->foreignId('parent_id')->nullable()->constrained('categories')->onDelete('cascade');
    $table->string('name');
    $table->string('slug')->unique();
    $table->text('description')->nullable();
    $table->tinyInteger('status')->default(0);
});

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Category extends Model
{
    public function children()
    {
        return $this->hasMany(Category::class, 'parent_id');
    }

    public function parent()
    {
        return $this->belongsTo(Category::class, 'parent_id');
    }
}

$categories = Category::with('children')->get();

Because you filter your data in the database and I don't think that you get a lot of categories after filtering with where.

You don't need to use chunk at all in this case.

$categories = Category::where('category_name', 'like', $term = "%{$request->search}%")
    ->orWhere('description', 'like', $term)
    ->orWhere('keywords', 'like', $term)
    ->orWhere('content', 'like', $term)
    ->orWhere('path', 'like', $term)
    ->active()
    ->get(['id', 'category_name']);

$response = $categories->toArray();

@mo7sin No or...

With that you don't call the observer of child model.

use Illuminate\Http\Request;

public function store(Request $request) 
{
    $image_tmp = $request->file('image');
}

https://laravel.com/docs/8.x/requests#files

Yes you can, for example

<?php

namespace App\Observers;

use App\Models\Tour ;

class TourObserver
{
    public function deleting(Tour $tour)
    {
        $tour->images->each->delete();
    }
}

Where images is relationship to TourImage model. And it calls an observer for TourImage

Create an account for an user during a registration.

I think it should be

$table->decimal('price', 15, 2)->default(0.00);

Better to use broadcasting, but it's more complicated.

https://laravel.com/docs/8.x/broadcasting

Cache data in the backend, otherwise, it's as if someone visited your site every 10 seconds. If you have a lot of traffic and slow server it could be a problem.

You can use default model

https://laravel.com/docs/8.x/eloquent-relationships#default-models

Every 10 seconds you check the url visitors/info to get some info.

What do you mean: after two minutes?

If you want to return just id

Then

return $lastid->id;

Use model instead of DB facade, because problem is with a response.

Or you can use

return response()->json([
    'lastid' => $lastid
]);

@ricardo Implementation of first()

/**
 * Execute the query and get the first result.
 *
 * @param  array|string  $columns
 * @return \Illuminate\Database\Eloquent\Model|object|static|null
 */
public function first($columns = ['*'])
{
    return $this->take(1)->get($columns)->first();
}

So it's same what he had before.

What are you trying to get?

Data from visitors_information?

And post whole controller method.

Because the error is not from that query.

@noblemfd Everytime you post unnecessary things. But not today. Try to think more what is important to show and what not...

Or better read a documentation finally.

I've never use PostgreSQL, but you can find it in the documentation.

https://www.postgresql.org/docs/current/functions-formatting.html

Oh ok, it's because you use PostgreSQL, just find equivalent function to MySQL in PostgreSQL.

Probably to_char instead of date_format

In my prevois code change

selectRaw("date_format(created_at, '%Y-%m') as month, count(*) as count")

to

selectRaw("to_char(created_at, 'YYYY-MM') as month, count(*) as count")

$start = now()->startOfYear();

for ($i = 0; $i < 12; $i++) {
    $months[] = $start->copy()->addMonths($i)->format('Y-m');
}

$months = collect($months);

$year = User::selectRaw("date_format(created_at, '%Y-%m') as month, count(*) as count")
     ->whereYear('created_at', now()->year)
     ->groupBy('month')
     ->get()->mapWithKeys(function ($item) {
         return [$item['month'] => $item['count']];
     });

$months->map(function ($month, $key) use ($year) {
    return $year->get($month, 0);
});

// in $months you have a data.

Yes, you have to pass there everything what you want to have it in the xml.

@php
    echo '<?xml version="1.0" encoding="UTF-8"?>';
@endphp

<configurations>
    @foreach ($data as $configuration)
        <configuration>
           <id>{{ $configuration->json['id'] }}</id>

           <name>{{ $configuration->json['name'] }}</name>
        </configuration>
    @endforeach
</configurations>

Yes, you have to pass there everything what you want to have it in the xml.

@php
    echo '<?xml version="1.0" encoding="UTF-8"?>';
@endphp

<configurations>
    @foreach ($data as $configuration)
        <configuration>
           <id>{{ $configuration->json['id'] }}</id>

           <name>{{ $configuration->json['name'] }}</name>
        </configuration>
    @endforeach
</configurations>

In GoalType model

public function ratingLimit()
{
    return $this->belongsTo(App\Models\RatingLimit);
}

Do you know Eager Loading?

https://laravel.com/docs/5.8/eloquent-relationships#eager-loading

$goals = Goal::with('goaltype.ratingLimit')->where('is_approved', 3)->get();

{{ $goal->goaltype->ratingLimit->max_rating }}

Your naming is really bad of everything.

Uou have to also add casts to the model.

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Configuration extends Model
{
    /**
     * The attributes that should be cast.
     *
     * @var array
     */
    protected $casts = [
        'json' => 'array',
    ];
}

Docs: https://laravel.com/docs/8.x/eloquent-mutators#array-and-json-casting

@if (auth()->user()->can('product-update') && auth()->user()->can('user_own', $post))
    //
@endif

https://spatie.be/docs/laravel-permission/v3/basic-usage/blade-directives#permissions

https://laravel.com/docs/7.x/authorization#via-the-user-model

So use your indexes from the json column, or what you have there...

You can't use Has Many Through relationship with Many to Many.

$actor = Actor::find($actorId);

$shows = Show::whereHas('showDetails.actors', function ($query) use ($actor) {
    $query->where('id', $actor->id);
})->paginate(15);

Docs: https://laravel.com/docs/8.x/eloquent-relationships#querying-relationship-existence

If I was you I would change naming

Pivot table has to be singular so instead of actor_show_details it should be actor_show_detail

And relationship in Show model is better to have just detail because it's hasOne

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Show extends Model
{
    public function detail()
    {
        return $this->hasOne('App\Models\ShowDetail');
    }
}

But in my opinion is better to have many to many relationship between Show and Actor models.

@laradoel Under json column you don't have an array, so something like this.

@php
    echo '<?xml version="1.0" encoding="UTF-8"?>';
@endphp

<configurations>
    @foreach ($data as $configuration)
        <configuration>
           <something>{{ $configuration->json['something'] }}</something>

           <another>{{ $configuration->json['another'] }}</another>
        </configuration>
    @endforeach
</configurations>

It's not a newbie problem, you just don't read documentation.

@henrique_f But you have it under

Route::get('view_records', '[email protected]_records');

How @snapey said use observer for that. Or add your logic to the FormRequest. Or make a trait where you just use a create method. That's it.