<!--
---- Sample code to demonstrate simple database driven redirect.
---- Use this code form to construct ads using Google Adwords 
---- Dynamic Keywords.
----
---- Coded by: Jawad Shuaib (http://jawadonweb.com)
---- jawad.php@gmail.com
--->
<?php
// Get the Google Adwords keyword from the URL
$query = $_GET['search'];

// Clean up the query
$query = str_replace ("Shoes", "", $query);
$query = strtoupper($query);
$query = strip_tags($query);
$query = trim ($query);	

// Assuming you are already connected to the database	
$sql = $mainDB->query ("SELECT productURL FROM products WHERE (upper(name) LIKE '%".$query."%')");	
$totalResults = mysqli_num_rows ($sql);
if ($totalResults == 1) {
	// This is the URL to the product specific page
	$theSQL = mysqli_fetch_array ($sql);
	$productURL = $theSQL['productURL'];
}
else {
	// Redirect to generic homepage if no results are found
	$productURL = "http://example.com";
}
// Use this header function for quick redirect. You may alternatively use JavaScript
header ("location: ".$productURL);
?>