Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $file = fopen($fname,"r");
- while(! feof($file))
- {
- $data = fgetcsv($file);
- if ($data[0] == "BEGINNING OF DESIRED DATA")
- {
- while(! feof($file))
- {
- $data = fgetcsv($file);
- $desc = $data[1].' '.$data[2];
- $sql = "INSERT IGNORE INTO database (date, type, desc, tot) VALUES ('$date','$data[0]', '$desc', '$data[12]')";
- if ($data[0] != "END OF DESIRED DATA")
- {
- if ($conn->query($sql) === TRUE)
- {
- $addOne = $conn -> affected_rows;
- $howMany = $howMany + $addOne;
- $howMany+1;
- }
- }
- if ($data[0] == "END OF DESIRED DATA")
- {
- break;
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement