-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path10kToDB.php
126 lines (119 loc) · 4.72 KB
/
10kToDB.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<html>
<body>
<?php
$user='velin';
$pass='9810017583';
$host='localhost';
$db='wp_task';
$dbcon = new mysqli($host,$user,$pass,$db);
if ($dbcon->connect_error) {
echo ("Connection failed");
}
$content = file_get_contents('10kBiggest.json');
$result = json_decode($content);
for ($i=0; $i < 10000; $i++)
{
//$i = 0;
$result->records[$i]->fields->name = str_replace("'","''",$result->records[$i]->fields->name);
$result->records[$i]->fields->admin1_code = str_replace("'","''",$result->records[$i]->fields->admin1_code);
$result->records[$i]->fields->admin2_code = str_replace("'","''",$result->records[$i]->fields->admin2_code);
$result->records[$i]->fields->admin3_code = str_replace("'","''",$result->records[$i]->fields->admin3_code);
$result->records[$i]->fields->admin4_code = str_replace("'","''",$result->records[$i]->fields->admin4_code);
$result->records[$i]->fields->country = str_replace("'","''",$result->records[$i]->fields->country);
$result->records[$i]->fields->timezone = str_replace("'","''",$result->records[$i]->fields->timezone);
$result->records[$i]->fields->ascii_name = str_replace("'","''",$result->records[$i]->fields->ascii_name);
$result->records[$i]->fields->alternate_names = str_replace("'","''",$result->records[$i]->fields->alternate_names);
$sqlcol = "insert into map_coords (name, latitude, longitude";
$sqlval = "values ( '" . $result->records[$i]->fields->name . '\', \'' . $result->records[$i]->fields->latitude . '\', \'' . $result->records[$i]->fields->longitude;
if(isset($result->records[$i]->fields->admin1_code))
{
$sqlcol .= ", admin1_code";
$sqlval .= "', '" . $result->records[$i]->fields->admin1_code;
}
if(isset($result->records[$i]->fields->admin2_code))
{
$sqlcol .= ", admin2_code";
$sqlval .= '\', \'' . $result->records[$i]->fields->admin2_code;
}
if(isset($result->records[$i]->fields->admin3_code))
{
$sqlcol .= ", admin3_code";
$sqlval .= '\', \'' . $result->records[$i]->fields->admin3_code;
}
if(isset($result->records[$i]->fields->admin4_code))
{
$sqlcol .= ", admin4_code";
$sqlval .= '\', \'' . $result->records[$i]->fields->admin4_code;
}
if(isset($result->records[$i]->fields->modification_date))
{
$sqlcol .= ", modification_date";
$sqlval .= '\', \'' . $result->records[$i]->fields->modification_date;
}
if(isset($result->records[$i]->fields->country))
{
$sqlcol .= ", country";
$sqlval .= '\', \'' . $result->records[$i]->fields->country;
}
if(isset($result->records[$i]->fields->country_code))
{
$sqlcol .= ", country_code";
$sqlval .= '\', \'' . $result->records[$i]->fields->country_code;
}
if(isset($result->records[$i]->fields->feature_class))
{
$sqlcol .= ", feature_class";
$sqlval .= '\', \'' . $result->records[$i]->fields->feature_class;
}
if(isset($result->records[$i]->fields->feature_code))
{
$sqlcol .= ", feature_code";
$sqlval .= '\', \'' . $result->records[$i]->fields->feature_code;
}
if(isset($result->records[$i]->fields->alternate_names))
{
$sqlcol .= ", alternate_names";
$sqlval .= '\', \'' . $result->records[$i]->fields->alternate_names;
}
if(isset($result->records[$i]->fields->geoname_id))
{
$sqlcol .= ", geoname_id";
$sqlval .= '\', \'' . $result->records[$i]->fields->geoname_id;
}
if(isset($result->records[$i]->fields->timezone))
{
$sqlcol .= ", timezone";
$sqlval .= '\', \'' . $result->records[$i]->fields->timezone;
}
if(isset($result->records[$i]->fields->dem))
{
$sqlcol .= ", dem";
$sqlval .= '\', \'' . $result->records[$i]->fields->dem;
}
if(isset($result->records[$i]->fields->ascii_name))
{
$sqlcol .= ", ascii_name";
$sqlval .= '\', \''. $result->records[$i]->fields->ascii_name;
}
if(isset($result->records[$i]->fields->population))
{
$sqlcol .= ", population";
$sqlval .= '\', \'' . $result->records[$i]->fields->population;
}
if(isset($result->records[$i]->fields->coordinates))
{
$sqlcol .= ", coordinates";
$sqlval .= '\', '. 'POINT(' . $result->records[$i]->fields->coordinates[0] . ', ' . $result->records[$i]->fields->coordinates[1] . ')';
}
$sqlcol .= " ) ";
if(isset($result->records[$i]->fields->coordinates)) $sqlval .= " );";
else $sqlval .= "' );";
$sql = $sqlcol . $sqlval;
//echo($sql);
if ($dbcon->query($sql) !== TRUE) {
echo "Error: " . $sql . "<br>" . $dbcon->error;
}
}
?>
</body>
<html>