<?php
    $DBloadbalancer = "checked";
    $DBserver0 = "";
    $DBserver1 = "";
	$servername = "172.16.20.2";
    if (isset($_GET["database"]) && ($_GET["database"] == "172.16.20.2")) {
		$DBloadbalancer = "checked";
        $DBserver0 = "";
        $DBserver1 = "";
		$servername = "172.16.20.2";
    }
    if (isset($_GET["database"]) && ($_GET["database"] == "172.16.20.10")) {
		$DBloadbalancer = "";
        $DBserver0 = "checked";
        $DBserver1 = "";
		$servername = "172.16.20.10";
    }
    if (isset($_GET["database"]) && ($_GET["database"] == "172.16.20.11")) {
		$DBloadbalancer = "";
        $DBserver0 = "";
        $DBserver1 = "checked";
		$servername = "172.16.20.11";
    }
?>

Selecteer de gebruikte Database-server:
<form method="get">
  <div>
	<input type="radio" name="database" value="172.16.20.2" <?php print($DBloadbalancer); ?> > DBloadbalancer
	<input type="radio" name="database" value="172.16.20.10" <?php print($DBserver0); ?> > DBserver0
	<input type="radio" name="database" value="172.16.20.11" <?php print($DBserver1); ?> > DBserver1
  </div>
  <div>
    <input type="submit" value="Bevestigen">
  </div>
</form>

<form method="post">
    <br>Typ hier je bericht voor NerdyGadgets (Maximaal 50 karakters) <input type="text" name="bericht">
	<input type="submit" value="Indienen">
</form>

<?php
	$username = "website";
	$password = "f2urUeK4W85YWfMz";
	$dbname = "nerdytest";

	if(isset($_POST["bericht"]) AND $_POST["bericht"] != "") {
		$bericht = $_POST["bericht"];
		try {
			$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
			$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$sql = "INSERT INTO `berichten` (bericht) VALUES ('".$bericht."')";
			$conn->exec($sql);
			echo "Bericht verzonden naar NerdyGadgets!";
			}
		catch(PDOException $e) {
			echo $sql . "<br>" . $e->getMessage();
		}
	}

	echo "<br><br><b>Ingezonden berichten:</b><br>";
	$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
	$fetchD = $conn->prepare("SELECT bericht FROM berichten WHERE 1");
	$fetchD->execute();
	$resultArr = array();

	while($row = $fetchD->fetch())
	{
		$resultArr[] = $row['bericht'];
	}

	foreach ($resultArr as $item) {
		echo $item;
		echo "<br>";
	}
	$conn = null;
?>