Changeset 8989 for src/db

Timestamp:

Mar 25, 2011, 3:51:21 PM (14 years ago)

Author:

dennisw

Message:

csv_to_db.php - str_replace updated

File:

• src/db/csv_to_db.php (modified) (2 diffs)

src/db/csv_to_db.php

@@ -2 +2 @@
 
 // edit with personal settings
-$location = ' ';
-$username = ' ';
-$password = ' ';
-$database = ' ';
+$location = 'localhost:3306';
+$username = 'root';
+$password = 'dsql';
+$database = 'project_heatmap';
 
 $filelist = array();
@@ -46 +46 @@
                         $lat=str_replace("N ", "", $data[0]);
                         $lon=str_replace("E ", "", $data[1]);
+                        $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','$data[2]','$data[4]','$enc')");
+                        $query=mysql_query("INSERT INTO ".$table." (latitude, longitude, ssid, mac, encryption) VALUES ('$lat','$lon','$ssid','$data[4]','$enc')");
                         if (!$query) {
                                 die('Invalid query: ' . mysql_error());