/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

3 votes131 views2 answers
Associate laravel
PHP
1 vote152 views2 answers
Laravel cronjob
PHP
6 votes162 views1 answer
How do decode base64 php
PHP
5 votes256 views3 answers
Get result count codeigniter
PHP CodeIgniter
0 vote148 views1 answer
Trying to access variable outside laravel collection
PHP Laravel
1 vote142 views1 answer
Php sql last 10 rows
PHP
16 votes139 views1 answer
League/omnipay v3.0.0 requires php ^7.1 -> your php version (8.0.11) does not satisfy that requirement
PHP
0 vote157 views1 answer
How to add a additional condition in a join using query builder laravel 5.3?
PHP Laravel
0 vote123 views1 answer
Failed to open stream permission denied in php
PHP
4 votes155 views2 answers
Ubuntu laravel storage permission
PHP Laravel