-
Notifications
You must be signed in to change notification settings - Fork 0
/
fix_stretches.php
55 lines (50 loc) · 1.64 KB
/
fix_stretches.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
<?php
$host = "localhost";
$dbname = "railway_atlas";
$username = "atlas";
$password = "Showmethemaps!";
$conn = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
$nl = "<br>\n";
function getIdFromName($conn, $name) {
$id_return = null;
$query = "SELECT id FROM maps_objects WHERE Name='" . $name . "';";
$stmt = $conn->prepare($query);
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
extract($row);
$id_return = $id;
}
return $id_return;
}
$query = "SELECT * FROM maps_stretches;";
$stmt = $conn->prepare($query);
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
extract($row);
$name = str_replace("Mestre", "Venezia Mestre", $name);
$name = str_replace("Venezia", "Venezia Santa Lucia", $name);
$name = str_replace("Castelfranco", "Castelfranco Veneto", $name);
$name = str_replace("", "", $name);
$name = str_replace("", "", $name);
$name = str_replace("", "", $name);
$name = str_replace("", "", $name);
$name = str_replace("", "", $name);
$name = str_replace("", "", $name);
$names = explode(' - ', $name);
if (count($names) < 2) {
echo "Dati insufficienti: " . $name . $nl;
continue;
}
$id_from = getIdFromName($conn, $names[0]);
if (is_null($id_from)) {
echo "Impossibile ricavare id stazione partenza: " . $names[0] . $nl;
continue;
}
$id_to = getIdFromName($conn, $names[1]);
if (is_null($id_to)) {
echo "Impossibile ricavare id stazione arrivo: " . $names[1] . $nl;
continue;
}
#echo $name . " :: " . $id_from . " -> " . $id_to . $nl;
}
?>