note 99659 deleted from pdo.construct by cmb
| From: | cmb@php.net | Date: | Wed, 02 Sep 2015 19:28:10 +0000 |
| Subject: | note 99659 deleted from pdo.construct by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-203579@lists.php.net to get a copy of this message | ||
Note Submitter: Mitsuaki Ishimoto
----
You have to use the following option "MYSQL_ATTR_READ_DEFAULT_FILE" to prevent someone
from attacking your system by SQL Injection.
<?php
$dsn = 'mysql:host=' . DB_HOST . ';dbname=' . DB_NAME;
$dbh = new PDO(
$dsn,
DB_USER,
DB_PASS,
array(
PDO::MYSQL_ATTR_READ_DEFAULT_FILE => '/etc/my.cnf'
)
);
$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
?>