New Discussion
pings12 pings12
1
Eloquent

Method after data is loaded after model is initialized.

Say i'm fetching a user on my User.php $user = User::find(1) I want to call a method automatically after the $user...
pings12 replied
Solved
Eloquent
1
24
TacitReturn TacitReturn
5
Eloquent

Return one value from similar fields

Hi everyone, I'm new to the discussion form, in advance my apologies if this question has been asked already. I've been searching around for a bit and haven't found any sol...
TacitReturn replied
Solved
Eloquent
5
54
Rretzko Rretzko
4
Eloquent

Call to undefined method stdClass::video()

Hi - I need some better eyes on this. I have code working on one view, but when failing on a second view. The Controller looks correct to me and I get the right results o...
Rretzko replied
Solved
Eloquent
4
55
raulmercadox raulmercadox
3
Eloquent

Query with filter on child tables

I have these tables: orders ---------- id (PK) stage_id (FK) stages --------- id (PK) phase I'd like to query the orders which associated s...
piljac1 replied
Solved
Eloquent
3
646
donkfather donkfather
13
Eloquent

Insert multiple records in one query

Hello again, :) I have a list of objects ( same object ) and I would like to insert them in the database at once. I have tried with createMany but this method I thin...
dsahani replied
Solved
Eloquent
13
20786
jomasjoao jomasjoao
2
Eloquent

Laravel-echo frontEnd script not working

I am using Laravel-echo and pusher to receive notifications in real time, my pusher is receiving messages, however my JavaScript code in FrontEnd is not receiving notificat...
jomasjoao replied
Eloquent
2
47
GodziLaravel GodziLaravel
2
Eloquent

How to concatenate two two values from the same eloquent result ?

Hello here the result of my request : $searchableColumn = SearchableColumn::where('id','=',$id) ->with('searchableTable')...
GodziLaravel replied
Solved
Eloquent
2
52
Davva Davva
2
Eloquent

Eager loading not working with particular UUID

I’ve been stuck on the weirdest problem for half a day now. I am using UUID(4) as primary keys on my models. I’ve stumbled on a UUID that seemingly breaks eager loading...
dudyali replied
Eloquent
2
321
mskhoshnazar mskhoshnazar
4
Eloquent

Belongs to many through

I wonder why this is not a part of laravel. Let's say we have projects and categories that belongToMany each other. That's eas...
rodrigo.pedra replied
Solved
Eloquent
4
106
fidanym fidanym
2
Eloquent

Include events with “touching” start/end times in query

I am running a Laravel 6 app using MongoDB through Jenssegers MongoDB plugin. So far I have not had to write a raw mongo query and I hope I won't have to for this one too,...
fidanym replied
Eloquent
2
84
rsarvarov rsarvarov
4
Eloquent

Get "dirty" attributes of model (even if no changes)

I know about getDirty() method, that gives me properties that been changed (before save()). But what if I want to know properties that haven't cha...
rodrigo.pedra replied
Solved
Eloquent
4
61
Utchin Utchin
7
Eloquent

Query with where + where or + where in not working

I am having some trouble getting this to respond correctly: $teams = Team::where('options->stage', 'Subscribed')->get()->pluck('id')->toArray();...
tykus replied
Solved
Eloquent
7
74
lilo lilo
9
Eloquent

How to access pdf file

Hi, I store in my database some pdf files. But when I want to display them in my blade I cannot see them. And when I look at the inspector, in the src=' ' it says &q...
martinbean replied
Eloquent
9
98
t0berius t0berius
6
Eloquent

eloquent insert model with three relations

Inserting a new order into the database involves a few relations: public function seller(){ return $this->belongsTo('App\User', 'seller_...
rodrigo.pedra replied
Solved
Eloquent
6
106
rreyes1979 rreyes1979
3
Eloquent

LockWaitTimeoutException for transaction retry

Hi. Is there anything like a "LockWaitTimeoutException" that can be caught to retry transactions? As it is right now, I am using the following code to identify lo...
SimonAngatia replied
Eloquent
3
673
robdevel robdevel
3
Eloquent

Laravel8 - Eloquent query builder: how add a raw query?

Hi to all, I cannot write a Query Builder with a raw query inside. I need to use the Query Builder 'cause I'm paginating and sorting the results via scoped query. Is...
a4ashraf replied
Solved
Eloquent
3
73
armancs armancs
4
Eloquent

Non-static method Illuminate\Database\Eloquent\Model::update() should not be called statically

Got this error when trying to update eloquent data. Controller : public function update(Request $request, $id) { Invoices::updat...
Sinnbeck replied
Solved
Eloquent
4
6735
NiloLeon NiloLeon
4
Eloquent

Laravel Eloquent limit and distinct

Hi, I extract this datas with eloquent $refunds = Refunds::whereNull('num_pre') ->where('status_ref', '>', 4) ->orderBy('claims_id', 'ASC')...
rodrigo.pedra replied
Eloquent
4
137
durairaj durairaj
11
Eloquent

How to get data from multiple table interrelated with each other

user- table id name email status 1 durai [email protected] active orders -table id user_id order_no total 10 1 #74749 250 order_items - table id o...
durairaj replied
Solved
Eloquent
11
247
coder72 coder72
5
Eloquent

How to make users column empty from SQL Statement ?

Like yesterday, This is my users table and i want to make coursable_id and coursable_type empty ? id | name | email | coursable_id | coureable...
rodrigo.pedra replied
Solved
Eloquent
5
98
t0berius t0berius
4
Eloquent

laravel insert relations based on two models

Using the following model Product: public function favouriteUsers() { return $this->belongsToMany('App\User', 'favourite_products'); }...
MichalOravec replied
Solved
Eloquent
4
80
Mqandeel Mqandeel
2
Eloquent

get first 10 tags

$blog= Blog::where('slug',$fslug)->with('tags)->firstOrFail(); this will return the spacific blog with all related tags how to return just...
Mqandeel replied
Solved
Eloquent
2
65
devondahon devondahon
2
Eloquent

How to use multiple oWhereRaw clause with an array of search terms ?

How to have multiple orWhereRaw clause, one for each element of my array: $array = ['foo', 'bar', 'hello', 'world']; re...
devondahon replied
Solved
Eloquent
2
78
coder72 coder72
4
Eloquent

How to delete users from SQL Statement

My users database look like this I want to cleany database data so i am cleaning from localhost. id | name | email | coursable_id | coureable_...
coder72 replied
Solved
Eloquent
4
82
devondahon devondahon
5
Eloquent

orWhere with array of search values and wildcard

I have an array of search values set like this: $string = 'foo bar hello world'; $array = explode(' ', $string); $array = array_map(fn ($value) => '%' . $...
devondahon replied
Solved
Eloquent
5
130
InToSSH InToSSH
6
Eloquent

Teams-Members-Users - help with DB structure

Hello, I am building an app for teams and their members and I am ripping my hair out trying to figure out the structure to be best and simplest to use with Eloquent. Also I...
jlrdw replied
Eloquent
6
145
webfuelcode webfuelcode
0
Eloquent

Using cviebrock sluggable with validator

I am using cviebrock/eloquent-sluggable slug package for my project and want to use it with validating data. Tell me how to use it... Where and how to u...
webfuelcode posted
Eloquent
0
37
Hala Hala
8
Eloquent

query on created_at with carbon

I have this query Community::where('created_at', Carbon::now()->subDays(3)->toDateString()) and in db i have this raw "...
Snapey replied
Solved
Eloquent
8
126
Hala Hala
2
Eloquent

get 50% percent of gender

i have user table with gender i need to pick up 20 users half of them female i did that private function getUser() { $female_users...
Snapey replied
Eloquent
2
87
mkshingrakhiya mkshingrakhiya
4
Eloquent

Query performance degraded after converting raw queries to Eloquent ones, How do I speed it up?

I had loads of raw SQL queries on a single page, 110 to be exact. It took nearly 1.2s to get data from all of them. Now, I managed to combine them all and got all the neede...
Johnson_73 replied
Eloquent
4
134
Foks Foks
11
Eloquent

Multiple Paginations on one page

Hi! I'm currently looking for a way to have multiple paginations on a single page, with they are interfering with each other. How can I do that? Best Regards, Foks...
Foks replied
Solved
Eloquent
11
208
msslgomez msslgomez
6
Eloquent

WhereHas returns unexpected item

I'm trying to get all products for a store where the inventory is greater than 0, but it's returning a product that has -1 inventory for some reason. $produc...
bugsysha replied
Eloquent
6
162
Gavmrz Gavmrz
1
Eloquent

WhereHas relationship latest()

I have a model Job with relationship lastAction. public function lastAction() { return $this->hasOne(\App\Task::cl...
a4ashraf replied
Eloquent
1
79
bljdavidson bljdavidson
7
Eloquent

Updating Column to allow nullable but can't because of type enum

Hi all, I am trying to update a field on my table to allow it to be nullable. public function up() { Schema::table('videos',...
bljdavidson replied
Solved
Eloquent
7
115
phpguru phpguru
2
Eloquent

[PDOException] SQLSTATE[HY000] [2002] No such file or directory

I've been using Docker for Windows with Laravel 5.3 + Spark for nearly a year. Now all of a sudden, something has changed in my environment and I cannot figure out what. Wh...
Hoomaan_Hormozdi replied
Eloquent
2
3018
Create a New Discussion Button

Want us to email you occasionally with Laracasts news?