Untitled

<?php
$host = "192.168.2.30";
$name = "root";
$pass = "root";
$db = "main";
?>
<html>
	<head>
	</head>
	<body>
		<h1>My cool site</h1>
		<p>This is server: <?php echo $_SERVER['SERVER_ADDR']; ?></p>
		<form method="post" action="">
			<input id="name" name="name" type="text" required="required" placeholder="Name">
			<input id="countrycode" name="countrycode" type="text" required="required" placeholder="CountryCode">
			<input id="Ssubmit" name="submit" type="submit" value="Send">
		</form>
	</body>
</html>
<?php
if(isset($_POST['submit'])){
	if(!isset($_POST['name']) || !isset($_POST['countrycode'])){
		die("You didn't filled everything in. >:C");
	} else {
		$nameSQL = strip_tags($_POST['name']);
		$countrycodeSQL = strip_tags($_POST['countrycode']);
		$nameSQL = preg_replace('/[^a-zA-Z]/','', $nameSQL);
		$countrycodeSQL = preg_replace('/[^a-zA-Z]/','', $countrycodeSQL);

		if(strlen($nameSQL) < 1 || strlen($countrycodeSQL) < 1 || strlen($nameSQL) > 35 || strlen($countrycodeSQL) > 3){
			die("Only valid text allowed. Name max 35, CountryCode max 3 chars. >:C");
		} else {
			try {
				$mysqli = new mysqli($host, $name, $pass, $db);
				if(!$mysqli || $mysqli->connect_error) { die("Oops, no database"); } else {
				$sql = "INSERT INTO city(Name, CountryCode) VALUES('".$nameSQL."','".$countrycodeSQL."')";
				if($mysqli->query($sql) === TRUE){ echo "New record is added"; } else { echo "Error: " . $mysqli->error; }

				$mysqli->close();


				}
			} catch(PDOException $e){ echo "Failed".$e->getMessage(); }
		}
	}
}

$mysqli = new mysqli($host, $name, $pass, $db);
if(!$mysqli || $mysqli->connect_error) { die("Oops, no database"); } else {
	$search = "SELECT Name, CountryCode FROM city";
	$result = $mysqli->query($search);
	if($result->num_rows > 0){
		while($row = $result->fetch_assoc()){
			echo "Name: ".$row['Name']." - CountryCode: ".$row['CountryCode']."<br>";
		}
	}
	$mysqli->close();
}

?>