Changeset 9028 for src/django_gheat/csv_to_db.php

Timestamp:

Apr 7, 2011, 1:25:48 PM (14 years ago)

Author:

dennisw

Message:

django_gheat - bezig met generate_tiles script

File:

• src/django_gheat/csv_to_db.php (modified) (4 diffs)

src/django_gheat/csv_to_db.php

@@ -2 +2 @@
 
 // edit with personal settings
-$location = '';
-$username = '';
-$password = '';
-$database = '';
-
-$filelist = array();
-$filelist = scandir("csv");
-sort($filelist);
-unset($filelist[0]);
-unset($filelist[1]);
-unset($filelist[2]);
-
+$location = '127.0.0.1';
+$username = 'root';
+$password = 'password';
+$database = 'project_heatmap';
 
 // connect to database
@@ -25 +17 @@
 foreach($filelist as $file) {
 
-$table = "gheat_points";
+$table = "gheat_meting";
 
-        // create table
-        mysql_query("
-                CREATE TABLE IF NOT EXISTS ".$table." (
-                        latitude double(9,7) NOT NULL,
-                        longitude double(9,7) NOT NULL,
-                        ssid varchar(45) NOT NULL,
-                        mac varchar(45) NOT NULL,
-                        encryption tinyint(4) NOT NULL,
-                        ID int(11) NOT NULL AUTO_INCREMENT,
-                        PRIMARY KEY (ID)
-                )
-        ");
-
-
-        // .csv file to open
-        if (($handle = fopen("csv/".$file, "r")) !== FALSE) {
+        if (($handle = fopen("wleiden.csv", "r")) !== FALSE) {
                 while (($data = fgetcsv($handle, 1000, "\t")) !== FALSE) {
                         $lat=str_replace("N ", "", $data[0]);
@@ -48 +25 @@
                         $ssid=str_replace("'", "", $data[2]);
                         $enc = substr($data[8], -2, 1);
-                        echo "\"".$lat.", ".$lon."\", \"".$data[2]."\", \"".$data[4]."\", \"".$enc."\"<br />\n";
-                        $query=mysql_query("INSERT INTO ".$table." (latitude, longitude, ssid, mac, encryption) VALUES ('$lat','$lon','$ssid','$data[4]','$enc')");
+                        $query=mysql_query("INSERT INTO ".$table." (lat, long) VALUES ('$lat','$lon')");
                         if (!$query) {
                                 die('Invalid query: ' . mysql_error());
@@ -55 +31 @@
                 }
                 fclose($handle);
-                rename("csv/".$file, "csv/backup/".$file);
         }