Adder
Für Reset Seite neu laden!
LOADING
Linie; Trip:
prepare($query); $statement->execute(); $result = $statement->get_result(); while ($row = $result->fetch_row()) { echo "
".$row[1]." ".$row[2]."
"; } ?>
Zielschild
Hauptrichtung
Betriebszeit
prepare($query); $statement->execute(); $result = $statement->get_result(); while ($row = $result->fetch_row()) { //get start date $query="SELECT date FROM calendar_dates WHERE service_id = '".$row[0]."' ORDER BY date ASC"; $statement = $mysqli->prepare($query); $statement->execute(); $result2 = $statement->get_result()->fetch_row(); //get end date $query="SELECT date FROM calendar_dates WHERE service_id = '".$row[0]."' ORDER BY date DESC"; $statement = $mysqli->prepare($query); $statement->execute(); $result3 = $statement->get_result()->fetch_row(); //add into select element echo "
".$row[0]." von ".$result2[0]." bis ".$result3[0]."
"; } $query="SELECT service_id, start_date, end_date FROM calendar"; $statement = $mysqli->prepare($query); $statement->execute(); $result = $statement->get_result(); while ($row = $result->fetch_row()) { echo "
".$row[0]." von ".$row[1]." bis ".$row[2]."
"; } ?>
Rufbus
Station
Ankunft
Abfahrt
Zeit hinzufügen
prepare($query); $statement->execute(); $result = $statement->get_result(); while ($row = $result->fetch_row()) { echo "
".$row[1]." -> ".$row[2]."
"; } ?>
Hinzufügen
Neue Fahrt eintragen
ID:
Uhrzeit erste Fahrt:
Uhrzeit letzte Fahrt:
Intervall in Sek.
Eintragen
Fahrten anzeigen