/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 vote195 views1 answer
[InvalidArgumentException] Could not find package laravel/laravel with version 7.0 in a version installable using your PHP version, PHP extensions and Composer version.
PHP
2 votes160 views1 answer
Laravel get only relationship
PHP
0 vote242 views1 answer
Lazy loading vs eager loading laravel
PHP
0 vote196 views1 answer
Artisa create event
PHP
1 vote208 views1 answer
How to send data from PHP to Python
PHP
3 votes171 views1 answer
Laravel policy create
PHP
0 vote237 views1 answer
Get 1 data from get laravel
PHP
0 vote166 views1 answer
Failed to authenticate on SMTP server with username
PHP
0 vote214 views1 answer
Laravel collection reverse
PHP
0 vote187 views1 answer
How to show image from php
PHP