SQL query in cron job!
De query werkt perfect wanneer ik het script via de browser laat draaien!
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
<?php
mail('test@*****.nl','testenFF','testen@*****.nl');
$database = mysql_connect("localhost", "*****", "*****");
mysql_select_db("*****", $database);
mysql_query("LOAD DATA LOCAL INFILE './upload/artikel.txt' INTO TABLE artikel FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY '\"' (test1, test2, test3, test4, test5, test6, test7, test8, test9, test10, test11, test12, test13, test14, test15, test16, test17, test18, test19)")or die("Werkt niet...");
mail('test@*****.nl','testenDONE','testen@*****.nl');
?>
mail('test@*****.nl','testenFF','testen@*****.nl');
$database = mysql_connect("localhost", "*****", "*****");
mysql_select_db("*****", $database);
mysql_query("LOAD DATA LOCAL INFILE './upload/artikel.txt' INTO TABLE artikel FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY '\"' (test1, test2, test3, test4, test5, test6, test7, test8, test9, test10, test11, test12, test13, test14, test15, test16, test17, test18, test19)")or die("Werkt niet...");
mail('test@*****.nl','testenDONE','testen@*****.nl');
?>
Elwin