nip2 | A spreadsheet-like GUI for libvips | Data Visualization library

Check out querying relations in Laravel for "Querying Relationship Existence".

In your case, your User model has many-to-many roles relationship. If you want to select only those users who has certain role, you can query users like this:

just add in User model

I haven't info about user. I have only values from comments. Why?

Because you are doing the query only on the model Comments

How can I get info about user, which add this comments?

Add with user to the query:

You need to write a middleware. In this middleware, check if user is authenticated or check user's role to make valid redirection. Please read this documentation. I hope it will help.

Well you have your users table built and enabled will work fine for your purposes. Next you have a few options, the simplest would be upon registration fire off an email with a link along the lines of www.my.site/activate?token=MD5TOKEN, where the md5 token is a md5 hash of the email they signed up with. Then to activate it when they hit that route take their email hash it and compare, if they're not signed in make them sign in before you do this. After that if it matches activate it.

The alternative would be to create another table titled activation_tokens which stores an email and a randomly generated token that you can regenerate many times as well as a is_used column.

Edit to answer comment:

You will have to override the default controllers and routes.

First remove the auth routes as you are going to create them yourself.

Then define your controllers.

For the login part you can create your own Login Controller and in there make your own login attempt which is what Laravel uses. There you can add your desired attribute validations like this.

Check your $fillable variable in User class. company_id1 and provincial_id1 must be defined in the fillable variable.

In App\Http\Controllers\Auth\RegisterController.php update your create() function and put all your extra fields there.

By the way, you don't need date_of_registration as the created_at field is already managed by Laravel.

Also, instead of your generateSeoUrl you can use Str::slug function from Laravel.

From the Linux man pages : https://linux.die.net/man/3/inet_ntoa

The inet_ntoa() function converts the Internet host address in, given in network byte order, to a string in IPv4 dotted-decimal notation. The string is returned in a statically allocated buffer, which subsequent calls will overwrite.

It seems the two calls the inet_nota() share a buffer, so calling the function twice overwrites whats in the buffer and replaces it with the next call, thus you get the same output