Imam fajl.txt koji preuzimam sa neta putem CURL i sacuvavam ga u root dir.
E ja to sve uradim kako valja sada taj faj moram da sacuvam u bazu...
Faj izgleda ovako:
File.txt
Code:
#type value1 value2
#type value1 value2
#type value1 value2
#type value1 value2
#type value1 value2
#type value1 value2
#type value1 value2
#type value1 value2
Ja sada uradim sledece, ucitam fajl i pokusam da ga ubacim u bazu u tabelu (table [type][val1][val2]
Code:
$fp = @fopen('file.txt','r');
while(!feof($fp)){
$buffer = fgets($fp, 999);
list($a, $b, $c) = explode("\n", $buffer);
// query INSERT INTO <table> (type, val, val) VALUES($a, $b, $c);
}
$fp = @fopen('file.txt','r');
while(!feof($fp)){
$buffer = fgets($fp, 999);
list($a, $b, $c) = explode("\n", $buffer);
// query INSERT INTO <table> (type, val, val) VALUES($a, $b, $c);
}
ovo sa query sam dodao kao primer ali stalno dobojam onu gresku. Gde ja gresim?