qE5KngUE

1<?php
2
3
4
5$filename = "data.txt";
6$lines = file($filename);
7
8
9try{
10	$database = new PDO('sqlite:ProducerDB.sqlite');
11	$database->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
12	$q = 'CREATE TABLE IF NOT EXISTS Producers (producerID INT, longitude INT, latitude INT, description TEXT)';
13	$database->query($q);
14	
15	$sql = 'INSERT INTO Producers (producerID, longitude, latitude, description) VALUES (?,?,?,?)';
16	$stmt = $database->prepare($sql);
17	
18	foreach ($lines as $line) {
19		$data = explode(',',$line);
20
21		$stmt->execute(array(
22			'producerID' => trim($data[2]),
23			'longitude' => trim($data[0]),
24			'latitude' => trim($data[1]),
25			'description' => trim($data[3])
26			));
27	}
28}catch(PDOException $e){
29	//die($e->getMessage());
30	throw $e;
31}
32
33
34
35// $handle = fopen($filename, "r");
36// $contents = fread($handle, filesize($filename));
37// fclose($handle);
38// echo $contents;