+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: MYSQLI_OPT_LOCAL_INFILE (/showthread.php?tid=90599)
MYSQLI_OPT_LOCAL_INFILE - serialkiller - 04-08-2024
Is there a way to set this parameter directly in the config/database.php settings or should it be done another way?
Thanks
RE: MYSQLI_OPT_LOCAL_INFILE - kenjis - 04-11-2024
No, you cannot set in config/Database.php.
RE: MYSQLI_OPT_LOCAL_INFILE - kenjis - 04-11-2024
You can get MySQLi object.
When CI4 MySQLi connection does not yet connect to MySQL server.
$db = db_connect();
$mysqli = $db->connect();
d($mysqli); // mysqli object
When CI4 MySQLi connection has already connected to MySQL server.
$db = db_connect();
dd($db->mysqli); // mysqli object
RE: MYSQLI_OPT_LOCAL_INFILE - martin_ci - 05-30-2024
(04-11-2024, 06:29 PM)kenjis Wrote: You can get MySQLi object.
When CI4 MySQLi connection does not yet connect to MySQL server.
$db = db_connect();
$mysqli = $db->connect();
d($mysqli); // mysqli object
When CI4 MySQLi connection has already connected to MySQL server.
$db = db_connect();
dd($db->mysqli); // mysqli object
Following this I thought I can set the option like this:
Code:
$db->mysqli->options(MYSQLI_OPT_LOCAL_INFILE, true);How can I overcome this?
RE: MYSQLI_OPT_LOCAL_INFILE - kenjis - 05-31-2024
As the error message says, check related settings like mysqli.allow_local_infile|mysqli.local_infile_directory in your php.ini.
RE: MYSQLI_OPT_LOCAL_INFILE - martin_ci - 05-31-2024
php.ini settings on my localhost are correct (mysql.allow_local_infile=On) but CI somehow establish the connection without that option.
As I wrote I can setup the connection manually (outside CI) with the right PDO attribute so that I can use that sql command but not inside CI.
I wonder where I can set this option in CI. The default array in the config/database.php seems not to be the correct place.
RE: MYSQLI_OPT_LOCAL_INFILE - kenjis - 05-31-2024
Ah, we cannot set MYSQLI_OPT_LOCAL_INFILE with CI4 MySQLi driver,
because
Quote:mysqli_options() should be called after mysqli_init() and before mysqli_real_connect().
https://www.php.net/manual/en/mysqli.options.php#refsect1-mysqli.options-description
RE: MYSQLI_OPT_LOCAL_INFILE - kenjis - 05-31-2024
You can:
- create your DB driver. See https://forum.codeigniter.com/thread-78294-post-383813.html
- send a Pull Request to add setting for mysqli options in Config\Database
RE: MYSQLI_OPT_LOCAL_INFILE - martin_ci - 05-31-2024
(05-31-2024, 01:50 PM)kenjis Wrote: You can:
- create your DB driver. See https://forum.codeigniter.com/thread-78294-post-383813.html
- send a Pull Request to add setting for mysqli options in Config\Database
Mmh, not sure if I am able/good enough to implement that correctly. But thank you very much for the links!