Merge branch 'master' of ssh://apples.lambdacomplex.org/git/bus
[bus.git] / betweenpoint.delete.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
<?php
  
  $conn = pg_connect("dbname=bus user=postgres password=snmc");
  if (!$conn) {
      echo "An error occured.\n";
      exit;
  }
  if ($_REQUEST['oldgeopo']) {
    
      $sql = " DELETE from stops WHERE geohash = '{$_REQUEST['oldgeopo']}'";
      $result = pg_query($conn, $sql);
      if (!$result) {
          echo("Error in SQL query: " . pg_last_error() . "<br>\n");
      } else {
      echo "Deleted {$_REQUEST['oldgeopo']}<br>";
      $updatedroutes = 0;
      $result_outdatedroutes = pg_query($conn, "Select * FROM between_stops where points LIKE '%" . $_REQUEST['oldgeopo'] . ";%'");
      while ($outdatedroute = pg_fetch_assoc($result_outdatedroutes)) {
          $newpoints = str_replace($_REQUEST['oldgeopo'].';', '', $outdatedroute['points']);
          $sql = "UPDATE between_stops set points='$newpoints' where fromlocation = '{$outdatedroute['fromlocation']}' AND tolocation = '{$outdatedroute['tolocation']}' ";
          $result = pg_query($conn, $sql);
          if (!$result) {
              echo("Error in SQL query: " . pg_last_error() . "<br>\n");
          }
            echo "updated ".$outdatedroute['fromlocation']."->".$outdatedroute['tolocation']."<br>";
        
          $updatedroutes++;
      }
      echo "updated $updatedroutes routes<br>";
      }
  }
  flush();
?>