<?php
$host="localhost";
$base="mydb";  
$user="myusername";
$pass="mypassword"; 
 
$connect=mysql_connect($host, $user, $pass) or die("Could not connect to database!!!!");
mysql_select_db($base,$connect) or die("Count not find database table!");
 
if(isset($_POST['zip'])){
    $zip=htmlspecialchars(mysql_real_escape_string($_POST['zip']));

 
<form name="zipcode_search" id="form" class="form" method="post" action="process.php">
<input name="zip" id="zip" type="text" placeholder="Zip Code" maxlength="5"/>
<button name="submit" id="search" type="submit"> Search </button>

<?php
$base="db";  

$connect=mysql_connect('localhost','username','password') or die("Could not connect to database!!!!");
mysql_select_db($base,$connect) or die("Count not find database table!");

if(isset($_POST['zip'])){
	$zip=htmlspecialchars(mysql_real_escape_string($_POST['zip']));
	$res=mysql_fetch_assoc(mysql_query("SELECT url FROM redirect WHERE zip='$zip'"));