|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Doc Bug #77786 set_local_infile_handler and set_local_infile_default methods of MySQLi
Submitted: 2019-03-23 17:38 UTC Modified: 2019-03-24 18:04 UTC
From: museyib dot e at gmail dot com Assigned:
Status: Verified Package: MySQLi related
PHP Version: 7.3.3 OS: Kali kali-rolling (x86-64)
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: museyib dot e at gmail dot com
New email:
PHP Version: OS:


 [2019-03-23 17:38 UTC] museyib dot e at gmail dot com
From manual page:
An error occurs at the methods "set_local_infile_handler" and "set_local_infile_default" of MySQLi class. Even the code sample in PHP documentation does not work.

Test script:
  $db = mysqli_init();
  function callme($stream, &$buffer, $buflen, &$errmsg) {
    $buffer = fgets($stream);
    echo $buffer;
    $buffer = strtoupper(str_replace(",", "\t", $buffer));
    return strlen($buffer);
  echo "Input:\n";
  $db->query("LOAD DATA LOCAL INFILE 'input.txt' INTO TABLE t1");
  $res = $db->query("SELECT * FROM t1");
  echo "\nResult:\n";
  while ($row = $res->fetch_assoc()) {
    echo join(",", $row)."\n";

Expected result:
I expect that code will work successfully? it doesn't matter what resalt is.

Actual result:
But this error appears:

 Fatal error: Uncaught Error: Call to undefined method mysqli::set_local_infile_handler()


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2019-03-24 18:04 UTC]
-Status: Open +Status: Verified
 [2019-03-24 18:04 UTC]
These methods (and the corresponding functions) have been
removed[1], but the docs have not been updated accordingly.  Also,
it has been overlooked to remove the declarations[2].

[1] <;a=commit;h=522595086b8d654a2fd954977f7f443f2578de22>
[2] <>
 [2019-05-02 12:20 UTC] vharihar at gmail dot com
Is there a replacement function?

This seems to be a useful function to have.
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Tue Nov 24 08:01:23 2020 UTC