/PHP/\PDO::ATTR_EMULATE_PREPARES => true Security issue

\PDO::ATTR_EMULATE_PREPARES => true Security issue

\PDO::ATTR_EMULATE_PREPARES =>true Security issue

 The option

'options'   => [
                \PDO::ATTR_EMULATE_PREPARES => true
            ]
will resolve the issue, However, beside the security issues it generates, it also effect all select queries that you perform on the DB in the way that it force/convert every returned type from the DB to be string instead of the real type (integer/ float)

How does it effect you?

if you have a validation layer above the result of the query, you can't perform something like (

if (is_int($model->id))
) which will return 0 always, because it's string not an integer anymore.

Source: laracasts.com

Similar codes

21 votes266 views2 answers
Php get second last element of array
PHP
10 votes305 views2 answers
Array to string conversion in laravel controller
PHP Laravel
12 votes304 views3 answers
How to remove composer package in laravel
PHP
3 votes385 views1 answer
Codeigniter check affected rows
PHP CodeIgniter
1 vote263 views1 answer
Php recursive function to build array
PHP
3 votes285 views2 answers
Laravel 7 view @php
PHP Laravel
0 vote273 views1 answer
Exists:categories,id except a value laravel
PHP Laravel
3 votes250 views2 answers
Seconds to minutes php
PHP
1 vote253 views1 answer
Php extract time from datetime
PHP
1 vote225 views1 answer
Add 2 hours to current time in cakephp
PHP