Nakov

The error says it all

$data = User::where('email',$request->get('email'))->first();

This results in null. Use firstOrFail it will throw an exception as the user with the given email could not be found.

@mrkarma4ya 403 means forbidden access, so that will happen if you have a resource authorization and the user is not allowed to hit the route. It could also happen if you have a Custom request where you add a validation, so the authorize method returns false within, make it return true or add an authorization there as you need it.

@mrkarma4ya

Make sure you have APP_KEY in your .env file.

Comment out all the other routes above the one that does not work and make sure there is no conflict between two routes.

If you are making an AJAX request you can debug it why it is not posting, check the network tab as well.

@neeraj1005 some links that might be helpful, just make sure you know you are using apache or nginx:

• https://www.digitalocean.com/community/questions/php-files-are-downloading-instead-of-executing-on-nginx
• https://stackoverflow.com/questions/18422140/apache-is-downloading-php-files-instead-of-displaying-them

@bigweld86

Then make it optional, because you don't have control of the source code. I bet it tries to call the accessor without a parameter

public function getPhoneAttribute(?string $phone)

// or

public function getPhoneAttribute(string $phone = null) 

@rider

for a checkbox to exist in the request at least one needs to be selected.

Then you are missing the error blade directive that I have shared above. That prints the error on the view.

@bigweld86

Then make it optional, because you don't have control of the source code. I bet it tries to call the accessor without a parameter

public function getPhoneAttribute(?string $phone)

// or

public function getPhoneAttribute(string $phone = null) 

@bigweld86

or just remove the type check on the accessor

public function getPhoneAttribute($phone) 

Resource controller is just like any other controller which just gives you the 7 default actions, but you can modify them add new whatever you want

https://laravel.com/docs/master/controllers#restful-supplementing-resource-controllers

@hetalpatel

Why I see you are trying to add 3' for a category_id.. Remove the ' from the value.

Something like this?

public function destroy(Request $request, $id)
{
    $department = OrgDepartment::find($id);
    $department->is_active = 2;
    $department->save();

    Session::flash('success', 'Department deleted successfully.');
    return redirect()->route('organization.departments.index');
}

Something like this?

public function destroy(Request $request, $id)
{
    $department = OrgDepartment::find($id);
    $department->is_active = 2;
    $department->save();

    Session::flash('success', 'Department deleted successfully.');
    return redirect()->route('organization.departments.index');
}

https://laracasts.com/discuss/channels/laravel/forcing-a-unique-rule-to-ignore-a-given-id?page=1

@hetalpatel

Why I see you are trying to add 3' for a category_id.. Remove the ' from the value.

@rider

If you just don't use the Form collective package you will be much better of, for example:

<div class="form-check form-check-inline">
    <input type="checkbox" name="client_category[]" id="inlineCheckbox1" value="1" />    
    <label class="form-check-label" for="inlineCheckbox1">Shipper</label>
</div>

<div class="form-check form-check-inline">
    <input type="checkbox" name="client_category[]" id="inlineCheckbox2" value="2" />    
    <label class="form-check-label" for="inlineCheckbox2">Carrier</label>
</div>

<div class="form-check form-check-inline">
    <input type="checkbox" name="client_category[]" id="inlineCheckbox3" value="3" />    
    <label class="form-check-label" for="inlineCheckbox3">Broker</label>
</div>

<div class="form-check form-check-inline">
    <input type="checkbox" name="client_category[]" id="inlineCheckbox4" value="4" />    
    <label class="form-check-label" for="inlineCheckbox4">Others</label>
</div>

@error('client_category') 
    <p> {{ $message }} </p>
@enderror 

@jukka

I use DigitalOcean with backups on, and I use Laravel Forge. There are good series here on Laracasts for using both.

@deshiloh I don't see anything dirty in this approach :) I'll do the same :)

@bony how will you authorize a person to perform an action to a resource while not knowing the permission name? How will you know the action that the user wants to perform? And by you here I mean the programmer.

@deshiloh I believe you are doing it right, but have you checked it the merge works properly?

What if you try before the create on the model to dump dd($request->except(['_token']));?

Or try replacing merge with add.

@siewlon6093

An example of what? Of your exact software that you are building ?

You need to define relationships as you want them, I gave you a link to the documentation, and there over 1500 videos on Laracasts for you to learn Laravel.

@siewlon6093

An example of what? Of your exact software that you are building ?

You need to define relationships as you want them, I gave you a link to the documentation, and there over 1500 videos on Laracasts for you to learn Laravel.

@slowhand

So in your adminNewlesson.blade.php view are trying to use $products which you are not passing to the view. You should do the same as you did for the lessons.blade.php view:

public function adminNewlesson()
{
    $products = Product::all();
    return view('admin.adminNewlesson', compact('products'));
}

@slowhand if it helped please hit the "Best Answer" button on my reply above :)

@siewlon6093

You have no reference between a Customer and a User, so you need to define your relationship, and then update a column that you want.

Please watch some videos here on Laravel if you are new and learn the process, or follow the documentation as well.

Here is the documentation for the relationships: https://laravel.com/docs/master/eloquent-relationships

@slowhand

So in your adminNewlesson.blade.php view are trying to use $products which you are not passing to the view. You should do the same as you did for the lessons.blade.php view:

public function adminNewlesson()
{
    $products = Product::all();
    return view('admin.adminNewlesson', compact('products'));
}

@siewlon6093 the solution is to add this:

$table->boolean('last_login_at')->nullable();

to your customers table migration.

@siewlon6093

You will get that error because there is no such column in the customers table. You have it in your users table.

@siewlon6093 just in case it is case-sensitive, try this instead:

$user->last_login_at =1;

you have it with a capital L.

@untymage

Well it won't do that for you. You will have to remove the

$table->timestamps();

And create your own.

If you click through in your IDE, and the underlying code is this:

public function timestamps($precision = 0)
{
    $this->timestamp('created_at', $precision)->nullable();

    $this->timestamp('updated_at', $precision)->nullable();
}

So there is no way to change those with a constant on a model. But create them yourself.

@untymage

Have you done this

So first i have to remove the $table->timestamps(); in the migration, Then create the $table->timestamp('last_update') in the migration

Before you ran the migration? Check your database and make sure that your fields got the new names.

Hey @mammadataei

Take a look at this great post : https://divinglaravel.com/authentication-and-laravel-airlock

The last part gives you the answer as well :) but please read it fully, it will clear things up for you.

The same conversation was going on here , https://laracasts.com/discuss/channels/laravel/dynamic-data but @mehmetanbaki finds it hard to understand

@pllaguno

The thing is that the cookie allows only 4kb of data, and in your case you are exceeding it, which makes the session not being able to contain the data and display it back to the view.

As the errors from the validation are stored in a session variable called errors and returned to the view. So using file gives it a bigger storage.

@pllaguno

The thing is that the cookie allows only 4kb of data, and in your case you are exceeding it, which makes the session not being able to contain the data and display it back to the view.

As the errors from the validation are stored in a session variable called errors and returned to the view. So using file gives it a bigger storage.

@pllaguno

If you are on a 6.* version of laravel prior to 6.11 the SESSION_DRIVER by default is set to cookie.

Add this to your .env file it will work:

SESSION_DRIVER=file

@msslgomez

I still don't get it why it will be an infinite loop, when it should just check for the number of replies or comments that you have, but that will be it.

You should also apply the check only if the comment or reply is written by the current user, and not for every single item, which will reduce the number of times the difference is checked.

@msslgomez

The other check can be done server side, before you return the comments/replies to the front-end, and add an additional flag to the comment itself i the current user is authorized to edit..

But there is no way an infinite loop can be triggered on the front-end as well. So I will do it as we've already discussed as well. Unless there is something that I am missing, this is the way to go.

@msslgomez

I don't get it how will you create an infinite loop. You will have to check for each item, when it was created. So I don't have an idea on your view or how do you display the items/comments.

@msslgomez

Why an infinite loop? Just call the method when the component has been created as I've shown you above and that's it.

@msslgomez please watch some Vue tutorials or read the documentation my friend, as these are basics..

created: function () {
    // add it here
},

mounted: function () {
    // or add it here
},

Or computed property: https://vuejs.org/v2/guide/computed.html#ad

@mehmetanbaki

You cannot create columns in a database dynamically with an Excel import.

@msslgomez

I just gave you an example, keep in mind that that code uses moment() library which you need to look on Google on how to include it in your project, and use it with Vue, here is how: https://stackoverflow.com/questions/34308004/moment-js-with-vuejs

Then you will add it as a computed property, or when the Vue component is created.

@msslgomez

Something like this:

let minutes = moment().diff(moment(this.comment.created_at), 'minutes');

if(minutes > 30) {
   this.dialogFormVisible = false;
}

@msslgomez

why not checking the comment created_at date, if it is more then 30 minutes, then disable the button.

You can use MomentJS library to check that.

@mehmetanbaki

No I think that you don't understand me :)

In your CustomerImport, try this:

class CustomerImport implements ToModel, WithHeadingRow
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        dd($row);

        return new Customer([
            'data' => json_encode($row),
        ]);
    }
}

This will tell you what data you have for each row in the Excel file.

Then you will replace each of those with the columns that exist in your DATABASE:

class CustomerImport implements ToModel, WithHeadingRow
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        return new Customer([
            'CustomerName' => $row[INDEX_OR_NAME_OF_THE_COLUMN],
            'Gender' => $row[INDEX_OR_NAME_OF_THE_COLUMN],
            'Address' => $row[INDEX_OR_NAME_OF_THE_COLUMN],
            'City' => $row[INDEX_OR_NAME_OF_THE_COLUMN],
            'PostalCode' => $row[INDEX_OR_NAME_OF_THE_COLUMN],
            'Country' => $row[INDEX_OR_NAME_OF_THE_COLUMN],
        ]);
    }
}

Just replace in the brackets what you see above with the index value for example $row[0] will return CustomerName, or if there is a named key, use the name..

I hope you understand now :)

@mehmetanbaki you can stop refreshing the page, you will get notification by email and here on Laracasts when someone replies to your post.

As I said, you need this:

return new Customer([
            'CustomerName' => $row['customer_name'],
  // add all other fields here
        ]);

This

 return new Customer([
            'data' => json_encode($row),
        ]);

will never work!

@mehmetanbaki

There is no data column in the Customer table, so that's wrong.

What does the $row returns for you, is it an array of items?

You will need to create an instance of the customer, for example:

 return new Customer([
            'CustomerName' => $row['customer_name'],
  // add all other fields here
        ]);

or something like that, or if the headers in the Excel file match the columns in your database, just use what I've shown you in the first reply.

DEBUG what you have in the row, using dd($row);.

"Data casting", not type hinting.

"Data casting", not type hinting.

@konstruktionsplan

The (int) before is used to cast the value coming from $request->get('site') into integer, in case it is a string for example '1' it will become 1.