--- a/betweenpoint.submit.php
+++ b/betweenpoint.submit.php
@@ -1,76 +1,32 @@
 <?php
-/*
- * GeoPo Encode in PHP
- * @author : Shintaro Inagaki
- * @param $location (Array)
- * @return $geopo (String)
- */
-function geopoEncode($lat, $lng) {
-	// 64characters (number + big and small letter + hyphen + underscore)
-	$chars = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ-_";
-
-	$geopo = "";
-	$scale = 7;
-	
-	// Change a degree measure to a decimal number
-	$lat = ($lat + 90) / 180 * pow(8, 10);
-	$lng = ($lng + 180) / 360 * pow(8, 10);
-	// Compute a GeoPo code from head and concatenate
-	for($i = 0; $i < $scale; $i++) {
-		$geopo .= substr($chars, floor($lat / pow(8, 9 - $i) % 8) + floor($lng / pow(8, 9 - $i) % 8) * 8, 1);
-	}
-	return $geopo;
-}		
-
-/*
- * GeoPo Decode in PHP
- * @author : Shintaro Inagaki
- * @param $geopo (String)
- * @return $location (Array)
- */
-function geopoDecode($geopo) {
-	// 64characters (number + big and small letter + hyphen + underscore)
-	$chars = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ-_";
-	// Array for geolocation
-	$location = array ();
-
-	for ($i = 0; $i < strlen($geopo); $i++) {
-		// What number of character that equal to a GeoPo code (0-63)
-		$order = strpos($chars, substr($geopo, $i, 1));
-		// Lat/Lng plus geolocation value of scale 
-		$location['lat'] = $location['lat'] + floor($order % 8) * pow(8, 9 - $i);
-		$location['lng'] = $location['lng'] + floor($order / 8) * pow(8, 9 - $i);
-	}
-
-	// Change a decimal number to a degree measure, and plus revised value that shift center of area
-	$location['lat'] = $location['lat'] * 180 / pow(8, 10) + 180 / pow(8, strlen($geopo)) / 2 - 90;
-	$location['lng'] = $location['lng'] * 360 / pow(8, 10) + 360 / pow(8, strlen($geopo)) / 2 - 180;
-	$location['scale'] = strlen($geopo);
-
-	return $location;
-}	
-
 $conn = pg_connect("dbname=bus user=postgres password=snmc");
 if (!$conn) {
   echo "An error occured.\n";
   exit;
 }
-$xml = simplexml_load_file("04-locatebetweenpoints.osm");
-
-/* Access the <rating> nodes of the first movie.
- * Output the rating scale, too. */
-foreach ($xml->node as $node) {
-	$geoPo = geopoEncode((float)$node['lat'],(float)$node['lon']);
-	$node['lat'] = (int) ((float)$node['lat']*10000000);
-	$node['lon'] = (int) ((float)$node['lon']*10000000);
-	echo($node['lat'].",".$node['lon']."=$geoPo<br>");
-   $sql = "INSERT INTO stops (geohash, lat, lng) VALUES('$geoPo','{$node['lat']}','{$node['lon']}')";
+print_r($_REQUEST);
+$reverse=(isset($_REQUEST["reverse"]) ? $_REQUEST["reverse"] : "off");
+$from=pg_escape_string($_REQUEST["from"]);
+$to=pg_escape_string($_REQUEST["to"]);
+$routes=$_REQUEST["routes"] ;
+$points=$_REQUEST["between_points"];
+   $sql = "INSERT INTO between_stops (fromLocation, toLocation, points, routes) VALUES('$from','$to','$points','$routes')";
      $result = pg_query($conn, $sql);
      if (!$result) {
          echo("Error in SQL query: " . pg_last_error() ."<br>\n");
      }
+     if ($reverse === "on") {
+	$ep = explode(";",$points);
+	$epr = array_reverse($ep); 
+	$p = implode(";",$epr).";";
+	$pointsString = substr($p,1);
+$sql = "INSERT INTO between_stops ( toLocation, fromLocation, points, routes) VALUES('$from','$to','$pointsString','$routes')";
+$result = pg_query($conn, $sql);
+     if (!$result) {
+         echo("Error in SQL query: " . pg_last_error() ."<br>\n");
+     }
+     }
 flush();
     
-}
 ?>