/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

0 vote297 views1 answer
Auth Logout
PHP
2 votes274 views1 answer
Php var dump die
PHP
0 vote361 views1 answer
Count column eloquent laravel
PHP Laravel
0 vote363 views1 answer
Mixed content laravel form target
PHP Laravel
0 vote295 views1 answer
Magento2 move Exception #0 (Exception): Notice: Undefined offset: 2 in /var/www/nucleus/htdocs/vendor/magento/framework/Encryption/Encryptor.php on line 591
PHP
3 votes307 views2 answers
Php sort array remove keys
PHP
0 vote343 views1 answer
How to read laravel query string with dash
PHP Laravel
0 vote335 views1 answer
Laravel (8) - Routing to controller with optional parameters
PHP Laravel
7 votes326 views4 answers
Str slug laravel
PHP
13 votes321 views6 answers
Laravel delete
PHP Laravel