mysql修改local_infile,切换到mysqli后LOCAL INFILE的问题

Anyone that is aware of the issues with using LOCAL INFILE in PHP will understand my frustration with this.

I previously got LOCAL INFILE working properly in all my PHP scripts by using the 128 flag in my connection call.

mysql_connect(DB_SERVER,DB_USER,DB_PASS,false,128)

I am now trying to switch to mysqli since the old mysql is depreciated.

I have tried everything I could find on every forum out there with no luck.

My connection call in mysqli seems fine:

$connection = mysqli_init();

if (!$connection) {die('mysqli_init failed');}

if (!mysqli_options($connection, MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 0')) {die('Setting MYSQLI_INIT_COMMAND failed');}

if (!mysqli_options($connection, MYSQLI_OPT_CONNECT_TIMEOUT, 5)) {die('Setting MYSQLI_OPT_CONNECT_TIMEOUT failed');}

if (!mysqli_