sql2.0.php

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>

<body>
<?php
$servername = "localhost";
$username = "sid";
$password = "temp";
$dbname = "usadb";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
	die("Connection failed: " . $conn->connect_error);
} else {
	echo "Connection Successful!";
}	
$state = $_POST["state"];
	
$sql = "SELECT * FROM city where state = '$state';";
	
$result = $conn->query($sql);
	
if ($result->num_rows > 0) {
	// output data of each row
	while($row = $result->fetch_assoc()) {
		echo "zipcode: " . $row["zipcode"]. " - Name: " . $row["name"]. " " . " - State: " . $row["state"]. " " ." - County: " . $row["county"]. "<br>";
	}
} else {
	echo "0 results";
}
$conn->close();
?>
</body>
</html>