I want to ask for your help. I'm studying laravel, i am using laravel 10, and I need to retrieve related data, the application and data that I'm working on are related to students in a school. I want to…
how to type this sql in laravel eloquent 10 $data = array:2 [ 0 => "3" 1 => "5" 2 => "1" ] relations public function followActionFollowStudent() { return $this->hasMany(FollowActionFollowStudent::class, 'follow_student_id', id'); } i need sql as this below select…
I have a column called Class ID and I am trying to sort this column. It seems to ignore the numbers. I assume because they are strings. Currently, it looks like this: NewSyn - 1 OBSSt NewSyn - 1 OBSSt…
I have a table called sales with the following columns. transaction_id transaction_refund_id price id transaction_id transaction_refund_id price 1 tr_001 0 5 2 tr_002 tr_001 5 3 tr_003 tr_003 5 I want to query the sales table and join the records…
i was try to get environment variabel, to get APP_URL from .env, but always return null, but when use random string it show, so this because .env value can't retrieve class Attachment extends Model { public function getUrlAttribute() { return…
Let's say I have a MySQL table called points with 4 columns (id, user_id, point, date). And, let's consider these dummy rows for better understanding. id user_id point date 1 1 2 2000-01-01 2 1 3 2000-01-01 3 2 5…
I have two tables tasks and task_hours, And I'm using one to many relationship in task model.(task can have many hours logs). And displaying task data at frontend in table (datatable) using with relationships to task_hours (as per query below).…
I'm trying to save the data from the form. However, there is no record when I check the database side. I'm using Laravel 10 and mySQL v5.7. **Controller **store() public function store(Request $request) { $personnelRegistry = null; $personnerlRegistryId = (int)$request->input('personnelRegistryId',…
I have three models: Vehicle, LiveData, and Place. In my Vehicle model, I currently have a relationship between Vehicle and LiveData that gets the latest LiveData for a vehicle: public function latestPosition(): HasOne { return $this->hasOne(LiveData::class)->latestOfMany(); } Now in my…
I wonder if is there any method in Laravel that check if column_id is not null and contains a valid id, then bring the relation if It is ? so for example: instead of doing this: if ($order->billing_address_id && $billingAddress…