\n";
echo "This page should be run from within the admin interface!\n";
exit;
}else {
if ($_POST['action'] == "add_non_mesh_station") {
echo "";
if (($_POST['sub_action'] == "new_station") && (isset($_POST['new_station_name'])) && (isset($_POST['new_station_description'])) &&
(isset($_POST['new_station_type'])) && (isset($_POST['new_station_lat'])) && (isset($_POST['new_station_lon']))) {
$newStationName = $_POST['new_station_name'];
$newStationDescription = $_POST['new_station_description'];
$newStationType = $_POST['new_station_type'];
$newStationLat = $_POST['new_station_lat'];
$newStationLon = $_POST['new_station_lon'];
$addedToSql = wxc_putMySQL("INSERT INTO marker_info (name, description, type, lat, lon) VALUES ('$newStationName', '$newStationDescription', '$newStationType', '$newStationLat', '$newStationLon')");
if ($addedToSql = 1) {
echo "Sucessfully added " . $newStationName . " to the database. ";
unset($_POST['new_station_name']);
unset($_POST['new_station_description']);
unset($_POST['new_station_type']);
unset($_POST['new_station_lat']);
unset($_POST['new_station_lon']);
unset($_POST['sub_action']);
}
}
$nonMeshStationsAndMarkers = mysqli_query($GLOBALS['sql_connection'], "SELECT name, description, type, lat, lon FROM marker_info") or die ("Could not get list of non mesh stations" . mysqli_error($GLOBALS['sql_connection']));
if ($nonMeshStationsAndMarkers) {
$nonMeshStationsAndMarkers = mysqli_fetch_all($nonMeshStationsAndMarkers, MYSQLI_ASSOC);
echo "This is what is in the database: \n";
echo "
";
echo "
Name
Description
Type
Lat
Lon
";
foreach ($nonMeshStationsAndMarkers as $value) {
echo "