Status Kurzplatz
[insert_php]
$datum002 = date("Y-m-d");
$test = "Geöffnet";
$host_name = "db610638503.db.1and1.com";
$database = "db610638503";
$user_name = "dbo610638503";
$password = "Jogi_091064";
$connect = mysqli_connect($host_name, $user_name, $password, $database);
if (mysqli_connect_errno())
{
echo "Verbindung zum MySQL Server fehlgeschlagen: " . mysqli_connect_error();
};
$query001 = "SELECT * FROM `GCM_status` where `Datum` = \"$datum002\"";
$result = $connect->query($query001);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$row["Status_Kurzplatz"] = utf8_encode($row["Status_Kurzplatz"]);
if (strcmp($row["Status_Kurzplatz"], $test) == 0)
{
echo "![\"Kurzplatz](\"http://www.monrepos.golf/wp-content/uploads/2016/02/course-6-green-200x200.png\")
";
}
else {
echo "![\"Kurzplatz](\"http://www.monrepos.golf/wp-content/uploads/2016/02/course-6-red-200x200.png\")
";
}
}
} else {
echo "0 results";
}
$connect->close();
[/insert_php]
";
}
else {
echo "";
}
}
} else {
echo "0 results";
}
$connect->close();
[/insert_php]