Laracasts Web Development Forum

I have a create page that includes the data from 4 other crud in the same page and im looking for the easiest way to store them. On store do i need to seperate the f...

Snapey replied 11 hours ago

Eloquent

2

47

jenya

13

Eloquent

Print nested hasMany relation

Hello! I use Laravel 5.8.35 with php 7.3.5. I have three models: //Card model <?php namespace App; use Illuminate\Database\Eloquent\SoftDeletes; use Illu...

usmnbh76 replied 15 hours ago

Eloquent

13

441

packy

12

Eloquent

relationship groupBy in initial query

I am trying to groupBy a relationship in the initial query from my controller but not having such luck. For now I have a workout, but seems clunky:...

Snapey replied 21 hours ago

Eloquent

12

86

yassineqoraiche

20

Eloquent

Eloquent get data using last relation value

Hello everybody, I have two models, user, and books the last one has a status column that can obtain different val...

yassineqoraiche replied 1 day ago

Eloquent

20

295

Constantinff

3

Eloquent

BelongsToMany using Pivot class and multiple db connections

I have two models: Article belonngsToMany Images and the relations looks like that return $this->belongsToMany(Image::...

bobbybouwmann replied 1 day ago

Eloquent

3

42

javediq_143

4

Eloquent

Multiple Polymorphic Relations in same Model

Hello All, Continuing with my Ecommerce site where users can order food online, I'm stuck at another stage. Below are the tables in my app: // users...

javediq_143 replied 1 day ago

Eloquent

4

74

engrlaravel

8

Eloquent

select all records where due_date = tomorrow

I want to select all records who is expiring tomorrow. I have due_date (Y-m-d H:i:s) format, $tasks = Task::where('deleted_at', null) ->where('...

jeffreyvanrossum replied 1 day ago

Eloquent

8

110

geek123

1

Eloquent

filter and sort model by computed attribute in a related model

I have these models: Product (id, sn, shop_id) Shop (id, name, latitude, longitude) How to get list of products sorted by distance where:...

repat replied 2 days ago

Eloquent

1

78

hunterhawley

1

Eloquent

Variable Class Names or Secondary Table?

Hey y'all! I have a table, 'basketball_game_events', and it is full of, you guessed it, all the things that happened during basketball games (assists, rebounds, etc....

mehaneef replied 2 days ago

Eloquent

1

44

scottsuhy

3

Eloquent

Beginner: Having trouble understanding how to extract the data out of a result from a query.

I am new to Laravel/Eloquent and I'm having trouble understanding how to extract the data out of a result from a query. I'm calling the following query in the contro...

scottsuhy replied 3 days ago

Eloquent

3

65

bngaard

1

Eloquent

Beginner: What is the best way to get data from multiple tables without duplication

Hi, I am fairly (few days old) in the world of Laravel, so I need some guidance as I do not quite understand the how to use the model and Controllers quite yet....

Sti3bas replied 3 days ago

Eloquent

1

36

SdeWijs

0

Eloquent

ISO8601 date serialization in Laravel 7

I noticed that Laravel does not cast all timestamp columns to the ISO8601 format out-of-the-box. If I return a model (in response to an Ajax request), which is converted to...

SdeWijs posted 3 days ago

Eloquent

0

28

waclaw66

2

Eloquent

Order by multiple columns from different tables

Hello, could you please help me to build the following query? Let's assume relationships: Group has many Members and Member has one User. Member has attribute...

waclaw66 replied 3 days ago

Eloquent

2

56

Thavarshan

1

Eloquent

Count items per day in week

Does anyone know how to group data by week like for instance, all posts created during the period of the last 7 days starting from Sunday?...

Thavarshan replied 3 days ago

Eloquent

1

32

testy

4

Eloquent

Eloquent how to group data by an row

I have the following table: id type title -- ------ ----- 1 1 title-1 2 2 title-2 3 2 title-3 4 2 title-4 5 1...

tigerjun replied 4 days ago

Eloquent

4

3392

DoeJohn

1

Eloquent

Laravel Many-to-Many (on the same users table/Model): Query scopes to include related for the specified user

Users can block each other. One user can block many (other) users, and one user can be blocked by many (other) users. In User...

DoeJohn replied 4 days ago

Eloquent

1

54

mstdmstd

1

Eloquent

Why Rollback raise Cannot drop index error?

Hello, in my laravel 5.7 app I need to add table and reference in other table to created table. I made 2 migration files and migrate command runs ok but running roll...

shez1983 replied 5 days ago

Eloquent

1

36

FutureWeb

8

Eloquent

Update multiple records using Eloquent

Hi LarPeeps, How can I update multiple rows with a single query like: $update = mysql_query("update item_table set colour = 'black' where item_type_...

chuck_wood replied 5 days ago

Eloquent

8

22887

kingmaker_bgp

5

Eloquent

Eloquent whereHas Relationship with constraint on particular related Entity

Hello Web Artisans and Laravel Enthusiasts, I had a very interesting and challenging question whi...

kingmaker_bgp replied 5 days ago

Eloquent

5

101

Mikegk

4

Eloquent

Update Eloquent Data

Hi Guys, within an model (UserStatus), I have the following method: private static function getUserStatusById($id_user,$select='*'){ return Us...

Mikegk replied 5 days ago

Eloquent

4

58

isadma

6

Eloquent

Laravel collection

I have this kind of collection. { { id: 125, name: "John Doe", cars: [ { model: 5, type: 2, address: { address: "St...

isadma replied 5 days ago

Eloquent

6

75

isadma

3

Eloquent

filter collection

{ { id: 125, type_id: 123, apartments: [ { id: 132, user_id: 32, floor: 28, }, { id: 133, user_id: 32, floor: 29, } ],...

Sti3bas replied 5 days ago

Eloquent

3

105

jerauf

2

Eloquent

Delete all but the first 50 rows in a query

I want to keep only the first 50 rows that are returned by a query. I tried using skip(50) but that didn't work. Any ideas?...

jerauf replied 5 days ago

Eloquent

2

57

mulai

6

Eloquent

User Activity Log

Greetings, I have two database tables users and activity_log with dummy records as below: Table users id...

mulai replied 5 days ago

Eloquent

6

112

nolros

2

Eloquent

Nest model $with is making 3 queries

Workspace database Schema::create('workspaces', function (Blueprint $table) { $table->bigIncrements('id'); $table->unsi...

nolros replied 5 days ago

Eloquent

2

57

Endy

1

Eloquent

Eloquent changes in laravel framework 7

I get question about the function in vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php: in elder version, the function returns $da...

jlrdw replied 5 days ago

Eloquent

1

47