MYSQLI_OPT_LOCAL_INFILE

Is there a way to set this parameter directly in the config/database.php settings or should it be done another way?

Thanks

No, you cannot set in config/Database.php.

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

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

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

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);

But this still gives me the error "LOAD DATA LOCAL INFILE is forbidden, check related settings like mysqli.allow_local_infile|mysqli.local_infile_directory or PDO::MYSQL_ATTR_LOCAL_INFILE|PDO::MYSQL_ATTR_LOCAL_INFILE_DIRECTORY".


How can I overcome this?

As the error message says, check related settings like mysqli.allow_local_infile|mysqli.local_infile_directory in your php.ini.

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

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.

Ah, we cannot set MYSQLI_OPT_LOCAL_INFILE with CI4 MySQLi driver,
because

mysqli_options() should be called after mysqli_init() and before mysqli_real_connect().
https://www.php.net/manual/en/mysqli.opt...escription

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

You can:
- create your DB driver. See https://forum.codeigniter.com/thread-782...83813.html
- send a Pull Request to add setting for mysqli options in Config\Database

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

You can:
- create your DB driver. See https://forum.codeigniter.com/thread-782...83813.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!