/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 vote219 views1 answer
Laravel eloquent get only field name
PHP
0 vote136 views1 answer
Php convert us date to european
PHP
4 votes156 views2 answers
Php authentication
PHP
2 votes185 views7 answers
How to convert date to string in php
PHP
0 vote197 views1 answer
Command working in terminal but working from code php
PHP
3 votes134 views6 answers
Remove square brackets from string php
PHP
1 vote143 views2 answers
Php validate date format
PHP
1 vote135 views2 answers
Add laravel sail build as alias
PHP
1 vote125 views1 answer
Php sign with private key
PHP
6 votes129 views3 answers
Current time in laravel migration
PHP