protarr

Using Laravel 8 with jetstream.

I need to update and insert some records into the database when releasing a new application version.

I could just create a migration to update the data without changing the structure, but I am not sure if this is the best practice on a Laravel environment.

Ummm, maybe I wasn't very clear.

Let's suppose I have a string in route format, like

$r = '/test/{FirstTest}/step/{StepNo}';

And a have an array with it's parameters, like

$p = ['mytest', 10];

Does exist some build in method or function to replace each parameter {} in string $r with its respective values in $p, resulting in a string, like

$url = '/test/mytest/step/10';

I mean, I not necessarily have this route defined, and I don't need to define it. I just need the resulting URL.

Well, if a function to do this not exists, I will just do a preg_replace. Thanks.

E.g., I have some route (a string): '/test/{FirstTest}/step/{StepNo}'

And I have an array with its respective parameters: ['mytest', 10]

No I need the resulting URL from this, like:

'/test/mytest/step/10'

Laravel has some builtin method to do this or I need to write my own? I am assuming this already exists, but I could not find it on docs.

Thanks.

Using Laravel 8 (with Jetstream).

I am updating the current authenticated user password like below. It works, but the user is automatically logout.

    auth()->user()->password = Hash::make(request('new_password'));
    auth()->user()->save();

I know the security implications of letting him logged in but... it's possible?

Thanks.

How to query the Email model with specific fields AND the name of the user (in another parent table), using one call to Model::where() like this:

$emails = Email::where('user_id', 1)->get(['id','user_id','email']); <- HOW TO ADD THE USER NAME TO THIS LIST?

I know I can retrieve the user name of individual records (using "belongsTo", mentioned below) like $emails[0]->user->name, but I am suposing that exists some way to do this without a loop.

Parent table:

user
    id
    name

Child table:

email
    id
    user_id
    email

On my Email model I have:

    public function user()
    {
        return $this->belongsTo('App\Models\User',  'user_id', 'id');
    }

Hi. I am using Laravel 8 with Jetstream (god, why) for the first time.

When session is lost and I authenticate again, I return to the route I were before the session was lost. What I want is to avoid this behaviour. After session lost and log in again, I need to be sent to a specific route (like '/', or HOME, for instance).

@michaloravec

I implemented your solution and it worked flawlessly. I will left here how I made it in case someone in the future needs it:

First I discovered that Laravel already have an event called Illuminate\Auth\Events\Login. This event only happens when the user successfully authenticates.

So I create an event listener like this:

$ php artisan make:listener UserLoggedInListener --event='Illuminate\Auth\Events\Login'

Then I registered the event and my listener on EventServiceProvider.php like this:

    protected $listen = [
        Login::class => [
            UserLoggedInListener::class,
        ]
    ];

And inside my listener UserLoggedInListener.php I put:

public function handle(Login $event)
{
    session(['my_variable' => 'my_value']);
}

Now I can access this variable anywhere the session is available: session()->get('my_variable').

Thank you very much.

Thank you. I forgot to mention I am using the new laravel jetstream for authentication. Description updated.

The session example isn't important. I just need to run something ONCE, just after the user logs in.

Laravel 8, using Jetstream

I need to store a variable into the session after the user logs in. The point is: How to do this once?

Currently I am setting this variable value when the user hits the home page, but when the user return to home page the variable is set again, overriding previous value. I can't put this in config because it's a calculated value.

I don't want to check if this variable exist in session every time the user hits the home page (the first route).

I want to avoid accessing the tables directly using the DB class.

Let's supose I have these 2 related tables.

user
  id
  name
  age
  
email
  id
  user_id
  email

I created a hasMany emails method on User model, so I can get the emails like: User::find(1)->emails. That's ok and it's working.

But what I really need in this example is to get some users and his respective emails in a plain collection or array, and I need the users that haven't emails too.

I could do User::where('age', 30)->get(), iterate over it and get the User::emails, but this approach isn't nice.

How to achieve this result, using Eloquent models, in a single list, like:

select 
  u.name,
  u.id as user_id,
  e.id as email_id,
  e.email
from user u
left join email e on u.id = e.user_id and u.age = 30

name   user_id    email_id    email
Jack   1          1           [email protected]
Jack   1          2           [email protected]
Anne   2          3           [email protected]
John   3          null        null
Karen  4          null        null

So, in this example, I need all users with age 30, even if they haven't any emails. And I need the result in a plain list as this query would return me.

Thank you.

I am using Laravel 8.

Suppose we have 3 tables. table_a, table_b and table_c.

A simple 3 levels of tables. Table A has many B and table B has many C.

table_a
  id
  name
  
table_b
  id
  table_a_id
  name
  
table_c
  id
  table_b_id
  name

I configured in TableA model a method tableB pointing to TableB model using hasMany. It works. I can retrieve the table_b records just using TableA::find(1)->tableB .

I configured in TableB model a method tableC pointing to TableC model using hasMany. It works. I can retrieve the table_c records just using TableB::find(1)->tableC .

Can I retrieve in one step all table_c records related to a table_a record ?

e.g.

Something like TableA::find(1)->... (i need the related records in table_c)

Thank you.