Parse Error : Invalid Numeric Literal in Laravel

Question

I have get following error in my Laravel Application.

Turns out that the error points to the following lines:

/* August */    
$augledcrdt=Companyledger::WhereIn('frm_ledger',$ledgerlist)->whereYear('transaction_date',$curyear)->whereMonth('transaction_date',08)->where('company_id',$companyids)->sum('credit_amt');
$augleddebt=Companyledger::WhereIn('frm_ledger',$ledgerlist)->whereYear('transaction_date',$curyear)->whereMonth('transaction_date',08)->where('company_id',$companyids)->sum('debit_amt');

/* September */     
$sepledcrdt=Companyledger::WhereIn('frm_ledger',$ledgerlist)->whereYear('transaction_date',$curyear)->whereMonth('transaction_date',09)->where('company_id',$companyids)->sum('credit_amt');
$sepleddebt=Companyledger::WhereIn('frm_ledger',$ledgerlist)->whereYear('transaction_date',$curyear)->whereMonth('transaction_date',09)->where('company_id',$companyids)->sum('debit_amt');

put '08' instead of only 08

Exprator
– Exprator

2017-07-19 10:47:50 +00:00
Commented Jul 19, 2017 at 10:47 — Exprator
– Exprator, Commented Jul 19, 2017 at 10:47

Community · Accepted Answer · 2017-07-24 20:26:54Z

2

I think you are using PHP 7.0. You can use the following piece of code to do so:

$augledcrdt=Companyledger::WhereIn('frm_ledger',$ledgerlist)->whereYear('transaction_date',$curyear)->whereMonth('transaction_date','08')->where('company_id',$companyids)->sum('credit_amt');
$augleddebt=Companyledger::WhereIn('frm_ledger',$ledgerlist)->whereYear('transaction_date',$curyear)->whereMonth('transaction_date','08')->where('company_id',$companyids)->sum('debit_amt');

edited Jul 24, 2017 at 20:26

CommunityBot

11 silver badge

answered Jul 19, 2017 at 10:54

Karthik

5,77718 gold badges50 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alexey Mezenin · Accepted Answer · 2017-07-19 10:52:07Z

1

You should change 08 to 8 if you're using PHP7:

->whereMonth('transaction_date', 8)

http://php.net/manual/en/migration70.incompatible.php#migration70.incompatible.integers

answered Jul 19, 2017 at 10:52

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

Collectives™ on Stack Overflow

Parse Error : Invalid Numeric Literal in Laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related