Laravel DB Builder uses string variable as integer ID

Question

One of my controllers takes an id field as $id and I use it on a query. When I check the query string it passes the id as string value like this:

select `id`, `name` from `table` where `id` = '1'

If I pass the intval($id) to the query it still works as expected.

select `id`, `name` from `table` where `id` = 1

My question: Which one is the optimized query and best practice? Thanks.

Serhii Topolnytskyi · Accepted Answer · 2018-12-03 11:17:37Z

2

First of all: (int) is faster than intval().
Link: wiki.phpbb.com/Best_Practices:PHP.

About quote numbers or not: In practice, unless you're running a Google-sized operation, such conversion overhead is going to be microscopically small.
Link: stackoverflow.com/questions/6781976

answered Dec 3, 2018 at 11:17

Serhii Topolnytskyi

8307 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Laravel DB Builder uses string variable as integer ID

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related