Changeset 8968

Timestamp:

Mar 16, 2011, 11:26:10 AM (14 years ago)

Author:

dennisw

Message:

csv_to_db.php - vars aanpassen voor gebruik
create.sql - db en tbl aangepast voor gemak

Location:

src/db

Files:

• create.sql (modified) (1 diff)
• csv_to_db.php (modified) (2 diffs)

src/db/create.sql

@@ -1 @@
-CREATE TABLE `project_heatmap`.`test_1` (
+CREATE TABLE `db`.`tbl` (
   `latitude` double(9,7) NOT NULL,
   `longitude` double(9,7) NOT NULL,

src/db/csv_to_db.php

@@ -2 +2 @@
 
 // edit with personal settings
-function connectdb()
-{
- mysql_connect("location", "username", "password")
-  or die("Error connecting to mysql: " . mysql_error());
- mysql_select_db('database')
-  or die("Error connecting to database: " . mysql_error());
-}
-connectdb();
+$location = '';
+$username = '';
+$password = '';
+$database = '';
+$table = '';
+$file = '.csv';
+
+
+// connect to database
+mysql_connect($location, $username, $password)
+        or die("Error connecting to mysql: " . mysql_error());
+mysql_select_db($database)
+        or die("Error connecting to database: " . mysql_error());
+
+        
+// 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("file.csv", "r")) !== FALSE) {
+if (($handle = fopen($file, "r")) !== FALSE) {
         while (($data = fgetcsv($handle, 1000, "\t")) !== FALSE) {
                 $lat=str_replace("N ", "", $data[0]);
@@ -18 +38 @@
                 $enc = substr($data[8], -2, 1);
                 echo "\"".$lat.", ".$lon."\", \"".$data[2]."\", \"".$data[4]."\", \"".$enc."\"<br />\n";
-                $query=mysql_query("INSERT INTO test_1 (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','$data[2]','$data[4]','$enc')");
                 if (!$query) {
                         die('Invalid query: ' . mysql_error());