/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

19 votes179 views6 answers
Laravel query builder join
PHP
1 vote207 views1 answer
Check which database connect laravel
PHP Laravel
0 vote195 views3 answers
Array fill key use in php project
PHP
0 vote195 views1 answer
Vscode php debugger change value
PHP
0 vote208 views3 answers
Brew downgrade php 8 to 7.4
PHP
8 votes271 views4 answers
Log php
PHP
1 vote188 views1 answer
For each multiple php
PHP
0 vote152 views1 answer
Php header accept post request from same domain
PHP
0 vote212 views1 answer
Add like and equal in same query in laravel
PHP Laravel
46 votes190 views6 answers
Clear laravel cache
PHP