PHP mysqli set_local_infile_handler() Function
Definition and Usage
The set_local_infile_handler() / mysqli_set_local_infile_handler() function sets a callback function for LOAD DATA LOCAL INFILE command.
The callback functions tasks are to read input from the file specified in LOAD DATA LOCAL INFILE, and to reformat it into the format understood by LOAD DATA INFILE.
The returned data must match the format specified in the LOAD DATA.
Syntax
Object oriented style:
$mysqli ->
set_local_infile_handler(read_file)
Procedural style:
mysqli_set_local_infile_handler(read_file)
Parameter Values
| Parameter | Description |
|---|---|
| connection | Required. Specifies the MySQL connection to use |
| read_func | Required. Specifies a callback function or objext that can take the
following params: stream - A PHP stream associated with the SQL commands INFILE &buffer - A string buffer to store the rewritten input into buflen - The maximum number of characters to be stored in the buffer &erromsg - If an error occurs you can store an error message in here |
Technical Details
| Return Value: | TRUE on success. FALSE on failure |
|---|---|
| PHP Version: | 5+ |
❮ PHP MySQLi Reference
