--- a/myway/myway_timeliness_reconcile.php +++ b/myway/myway_timeliness_reconcile.php @@ -17,27 +17,25 @@ include ('../include/common.inc.php'); auth(); foreach ($_REQUEST as $key => $value) { - if (strstr($key, "route") && !strstr($value, "Select")) { + if (strstr($key, "route") && !strstr($value, "Select")) { $myway_route = str_replace("route", "", $key); - $route_full_name = $value; - $query = "update myway_routes set route_full_name = :route_full_name where myway_route = :myway_route"; + $route_id = $value; + $query = "update myway_routes set route_id = :route_id where myway_route = :myway_route"; debug($query, "database"); $query = $conn->prepare($query); $query->bindParam(":myway_route", $myway_route, PDO::PARAM_STR, 5); - $query->bindParam(":route_full_name", $route_full_name, PDO::PARAM_STR, 42); + $query->bindParam(":route_id", $route_id, PDO::PARAM_STR, 42); $query->execute(); die(print_r($conn->errorInfo(), true)); } if (strstr($key, "myway_stop")) { $myway_stop = $value; - $stop_code = $_REQUEST['stop_code']; - $stop_street = $_REQUEST['stop_street']; - $query = "update myway_stops set stop_code = :stop_code, stop_street = :stop_street where myway_stop = :myway_stop"; + $stop_id = $_REQUEST['stop_id']; + $query = "update myway_stops set stop_id = :stop_id where myway_stop = :myway_stop"; debug($query, "database"); $query = $conn->prepare($query); $query->bindParam(":myway_stop", $myway_stop, PDO::PARAM_STR, 25); - $query->bindParam(":stop_code", $stop_code, PDO::PARAM_STR, 32); - $query->bindParam(":stop_street", $stop_street); + $query->bindParam(":stop_id", $stop_id, PDO::PARAM_STR, 32); $query->execute(); die(print_r($conn->errorInfo(), true)); } @@ -68,7 +66,7 @@ echo "
" . $stopKey++ . " | " . $stopResult['stop_name'] . " | " . $stopResult['stop_code'] . " |
" . $stopKey++ . " | " . $stopResult['stop_name'] . " | " . $stopResult['stop_id'] . " |