And how do you translate it on view?

Hi to all
I use this code to attaching a relationship to a model with additional data to be insert into the intermediate table
$user->roles()-attach($roleId,[‘expires’ => $expires]);
Everything is ok.
My question is how to get the additional data in
$user->roles;
Thanks

Anybody

read the doc, it’s not laravel problem

$user->load(‘roles’) or $user->with(‘roles’)
it’s all written in doc

Its ok but cant get the additional data

update your composer

what do you mean by additional data

I am planning to building SaaS application
Where all the customers are store in a single database and each client need a separate Database. While using same code.

Can anyone suggest better way to start??

Separate db

Yes

Is any packages available for the same?

This makes updateing/migrating more complex/painful.
I personally used the same db approach, you have to be very careful though to include the tennant id into every query.

In hindsight im glad I took this approach because we made frequent and big changes to the schema. With a multi-db approach this would have been more work for us regularly.

Another thing is we have our own dashbord where we can keep track of the whole system easily with the singledb approach

How make a point system on order place if user place a order i have toh 5 point in his account i am not getting the logic how could i do

formulate you question better

I want a point base system if user place order of any thing i have to credit 5 point in here account

make a new field in the user-table “points”

I meant different table

when asuccesful order is placed do user->points +5

you can do it directly in the SuccesfulOrderPlacedController or you can make an event/listener

Was it resolved?

Haa ho gya and thanks to @skys

👍🏻OK

Hi guys, I have a status database column, (1=>’opened’, 2=>’closed’, 3=>’canceled’) How can I implement it? Const, array, class, third party package? I would like to have a expressive codebase, so use some like $status = opened instead $status = 1

Const

And how do you translate it on view?

Hello guys,
I have two timestamp start-time, end time like this in my db coloumn votedate (09:45- 2:30),

now I need to compare this with (11:30-8:30)start-time ,endtime respectively

I am doing this to check if my stored db time is overlapped with my current input time or not

I tried to compare it with strtotime()but nothing works.
Please help

You could convert to carbon and use compare https://carbon.nesbot.com/docs/#api-comparison

you can use mutator to acheive that

I think I’ll use a combination of mutator, accessor and const. Thank you

Not at all

In the relationship inside the model you can specify what additional attributes from the pivot table you will use

Buenas a todos quiero compartir este articulo enfocado en los que nos preguntamos 👀 en que lenguajes y tecnologías desarrollaron Slack o visual studio code, la respuesta es *ELECTRON*, https://www.electronjs.org/ 👈🏼 🔥 es un framework de javascript 👨‍💻 Mas Info
https://brainhub.eu/blog/electron-framework-example-apps/

Quizás te preguntas lo mismo pero como y con que se creo photoshop 🤩
La respuesta es *C* como lenguaje de programación y *QT* como Ide de desarollo de sistemas de alto rendimiento 👉🏼 https://www.qt.io/download

Saludos *Jorge Gutierrez*
https://www.instagram.com/jorgutiz/

*Academia*
https://www.instagram.com/bioonixacademy/

Please provide me some interview questions on Laravel that are being asked most frequently

For freshers

Thanks
But cant find any code or solution

Search “withPivot”

#Q How can I get the all login sessions related to a user?

You can maintain a separate session table to store the user logins. So, whenever they login, you can store their IDs in a row along with other details like user agent (browser), location, IP address, operating system and things like that.

Use pivot, find hoe to use in Laravel documentation

Use multitenant

hello guys? i have an issue im trying to change color of a row depending on the value from the database..

@php
$ursb_flag = pending;
$rowclass = ‘yellow’;

if ($ursb_flag !== approved)
{
$ursb_flag = $post->ursb_verify_flag;
if ($rowclass == ‘red’) $rowclass = ‘white’;
else $rowclass = ‘grey’;
}
@endphp
<tr class=”{{ $rowclass }}”>
<td>{{ $post->ursb_verify_flag }}</td>
</tr>

the error is in pending.

pending is my default value… i have 3 values coming from the db.. pending is yellow.. then approved is green

READ AGAIN

read only the word pending until you get the error.

see in my code i am setting default to pending