/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

-1 vote286 views2 answers
Laravel latest
PHP
0 vote353 views1 answer
Confirm password in codeigniter
PHP CodeIgniter
13 votes309 views6 answers
Php new line
PHP
1 vote340 views2 answers
How to remove token while logout using laravel 8
PHP Laravel
1 vote299 views1 answer
How to request user input in php
PHP
0 vote299 views1 answer
Laravel collection get
PHP
0 vote310 views2 answers
Obtener datos de usuario registrado en WordPress
PHP
0 vote304 views1 answer
$loop laravel list
PHP Laravel
1 vote320 views1 answer
Publish config laravel
PHP
35 votes298 views4 answers
First letter capital of every word in php
PHP