Load data infile... and PHP 4.3.8 problem

[GeorgeK]

Hi,
I have problem with load data local infile.... in the new version of PHP, 4.3.8. MySQL server - 4.0.12. Since this version of PHP, we have installed PHP 4.3.0 and everything was OK with our script.

here is source code, please may anyone help me?

<?

include "./xxxxx.php"; // connection parameters...

$conn1 = MySQL_Connect($ac_server, $ac_user, $ac_pass, 0, 128);

$result1 = mysql_DB_Query ($ac_db, "drop table skup");
$result2 = mysql_DB_Query ($ac_db, "create table skup (

s11 int,
s12 int,
s13 int)");

echo "result: $result2<br><br>";

$result3 = mysql_DB_Query ($ac_db, "load data local infile 'skup.txt' into table skup FIELDS ENCLOSED BY '\t' lines terminated by '%%'");

echo "result3: $result3<br>";

MySQL_Close();

?>

PHP variables you can find there -
http://www.fitsport-jt.cz/tech/php-info.php

more info:
1. --local-infile=1 parameter in MySQL server
2. there is no any error message
3. $result3 value after load data infile is false... (none)

---

Thank you

[rachel2004]

Try using mysql_error() while you are troubleshooting:

$result3 = mysql_DB_Query ($ac_db, "load data local infile 'skup.txt' into table skup FIELDS ENCLOSED BY '\t' lines terminated by '%%'")
    or die("<p>Couldn't execute result3 query: <strong>".mysql_error()."</strong></p>");

When you run your script again, it should tell you what the problem is (if the problem is a MySQL problem).

Also, use error_reporting(E_ALL) so you can get some feedback from PHP.