LOAD DATA LOCAL INFILE forbidden in… PHP

by

Check docs http://php.net/manual/en/ref.pdo-mysql.php.

Basically you need:

PDO::MYSQL_ATTR_LOCAL_INFILE => true

Set at instantiation.

Example:

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

More Related Contents:

  1. PHP DateTime supported formats
  2. Can I call a PHP function in a JavaScript click handler?
  3. How to create a chat program using php and mysqli for chatting [closed]
  4. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  5. Just using mysql real escape string [closed]
  6. Many-to-many relationships examples
  7. Can I store images in MySQL [duplicate]
  8. MySQL – This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery
  9. Storing files in database Vs file system
  10. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  11. MySQL Join two tables with comma separated values
  12. How can I Use Prepared Statements in CodeIgniter
  13. iPhone emoticons insert into MySQL but become blank value
  14. How to connect to MySQL database in PHP using mysqli extension?
  15. When *not* to use prepared statements?
  16. Laravel 5.4 field doesn’t have a default value
  17. org.json.JSONException: Value
  18. PHP Check for NULL
  19. How to store .pdf files into MySQL as BLOBs using PHP?
  20. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  21. PDO MySQL: Insert multiple rows in one query
  22. Outputting all PHP errors to database not error_log
  23. Laravel nested relationships
  24. getting the value of an extra pivot table column laravel
  25. php sample script for pagination [closed]
  26. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  27. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  28. Update query PHP MySQL [duplicate]
  29. Do I have to use mysql_real_escape_string if I bind parameters?
  30. How to sort MYSQL fulltext search results by relevancy

Leave a Comment