/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

31 votes133 views3 answers
Carbon laravel use
PHP Laravel
0 vote131 views2 answers
Download file on client from server url php
PHP
2 votes136 views2 answers
Validator number laravel
PHP Laravel
0 vote124 views1 answer
Laravel allow null records relationship
PHP
0 vote119 views2 answers
'ldfdfdf
PHP
6 votes138 views6 answers
Search query in laravel
PHP Laravel
8 votes251 views6 answers
Codeigniter 4 get last query
PHP CodeIgniter
0 vote113 views1 answer
Drupal 8 user_load
PHP
0 vote79 views1 answer
Laravel collection reject
PHP
1 vote145 views1 answer
How to use plugin shortcode in wordpress template
PHP