How to Enable LOAD DATA LOCAL INFILE in PHP for MySQL Data Import?

Loading Data from Local Files into MySQL with PHP's LOAD DATA LOCAL INFILE

When attempting to use LOAD DATA INFILE to populate a MySQL table from a local file via a PHP application, users may encounter an error forbidding the use of the LOCAL option. This issue stems from PHP's compilation and use of mysqlnd, as discussed in an unresolved PHP bug report.

To resolve this problem, users should configure their PHP application to explicitly permit the use of LOAD DATA LOCAL INFILE. This can be achieved by setting the PDO::MYSQL_ATTR_LOCAL_INFILE attribute to true during PDO object instantiation.

Example:

<code class="php">$conn = new \PDO("mysql:host=$server;dbname=$database;", "$user", "$password", array(
    PDO::MYSQL_ATTR_LOCAL_INFILE => true,
));</code>

By setting this attribute, PHP applications can gain access to the LOAD DATA LOCAL INFILE functionality, allowing them to import data from local files into MySQL tables.

The above is the detailed content of How to Enable LOAD DATA LOCAL INFILE in PHP for MySQL Data Import?. For more information, please follow other related articles on the PHP Chinese website!