Hi everyone,
I'm trying to create a dynamic landing page for a client of mine. My intention here is this. Take a single template page that loads the end users search engine search query's into the appropriate spots on the landing page. As in, someone looks for "Rentals Denver Colorado". when they click on the link for our site in Google their search terms are passed through a script, compared against our database of cities and states, matched and displayed on the landing page. There is more that will happen but my problem here is in the matching. I've gotten the script to where it pulls the search query words out, now I need to figure out how to match that against mysql db, drop any non matching words, and make the matched words available for use on the landing page.
here's what I have so far, this pulls the query words out as an array, splits the words then makes them a single string.
[code=php]global $referer, $engine, $query, $query_array, $query_terms;
// Setup
$referer = $_SERVER['HTTP_REFERER'];
$engine = false;
$query = null;
$query_array = array();
$query_terms = null;
// Remove protocol from start of string
$referer = explode('//', $referer);
if(isset($referer[1]))
$referer = $referer[1];
else
$referer = $referer[0];
// Remove www. is it exists
if(substr($referer, 0, 4) == 'www.')
$referer = substr($referer, 4);
// Get substrings
$sub7 = substr($referer, 0, 7);
$sub9 = substr($referer, 0, 9);
$sub10 = substr($referer, 0, 10);
$sub11 = substr($referer, 0, 11);
$sub12 = substr($referer, 0, 12);
$sub13 = substr($referer, 0, 13);
$sub14 = substr($referer, 0, 14);
$sub15 = substr($referer, 0, 15);
$sub16 = substr($referer, 0, 16);
$sub17 = substr($referer, 0, 17);
$sub19 = substr($referer, 0, 19);
$sub20 = substr($referer, 0, 20);
$sub23 = substr($referer, 0, 23);
// Search string for engine and set query delimiter
if($sub7 == 'google.')
{
$engine = 'google';
$delimiter = "q";
}
elseif($sub13 == 'search.atomz.')
{
$engine = 'atomz';
$delimiter = "sp-q";
}
elseif($sub11 == 'search.msn.')
{
$engine = 'msn';
$delimiter = "q";
}
elseif($sub13 == 'search.yahoo.')
{
$engine = 'yahoo';
$delimiter = "p";
}
elseif($sub16 == 'msxml.excite.com')
{
$engine = 'excite';
$delimiter = "qkw";
}
elseif($sub16 == 'search.lycos.com')
{
$engine = 'lycos';
$delimiter = "query";
}
elseif($sub13 == 'alltheweb.com')
{
$engine = 'alltheweb';
$delimiter = "q";
}
elseif($sub14 == 'search.aol.com')
{
$engine = 'aol';
$delimiter = "query";
}
elseif($sub15 == 'search.iwon.com')
{
$engine = 'iwon';
$delimiter = "searchfor";
}
elseif($sub7 == 'ask.com')
{
$engine = 'ask';
$delimiter = "q";
}
elseif($sub23 == 'search.cometsystems.com')
{
$engine = 'cometsystems';
$delimiter = "qry";
}
elseif($sub10 == 'hotbot.com')
{
$engine = 'hotbot';
$delimiter = "query";
}
elseif($sub12 == 'overture.com')
{
$engine = 'overture';
$delimiter = "Keywords";
}
elseif($sub15 == 'metacrawler.com')
{
$engine = 'metacrawler';
$delimiter = "qkw";
}
elseif($sub19 == 'search.netscape.com')
{
$engine = 'netscape';
$delimiter = "query";
}
elseif($sub13 == 'looksmart.com')
{
$engine = 'looksmart';
$delimiter = "key";
}
elseif($sub13 == 'go.google.com')
{
$engine = 'gogoogle';
$delimiter = "q";
}
elseif($sub20 == 'dpxml.webcrawler.com')
{
$engine = 'webcrawler';
$delimiter = "qkw";
}
elseif($sub20 == 'search.earthlink.net')
{
$engine = 'earthlink';
$delimiter = "q";
}
elseif($sub20 == 'search.viewpoint.com')
{
$engine = 'viewpoint';
$delimiter = "k";
}
elseif($sub9 == 'mamma.com')
{
$engine = 'mamma';
$delimiter = "query";
}
elseif($sub9 == 'ask.co.uk')
{
$engine = 'askcouk';
$delimiter = "ask";
}
elseif(preg_match('/home\.bellsouth\.net\/s\/s\.dll/i', $referer))
{
$engine = 'bellsouth';
$delimiter = "string";
}
// Actually do the work if an engine was found
if($engine)
{
// Get raw query
$query = explode($delimiter.'=', $referer);
$query = explode('&', $query[1]);
$query = urldecode($query[0]);
//-------------------------
// Data has been retrieved
//-------------------------
// Additional processing
// Remove single quotes
$query = str_replace("'", '', $query);
// Remove double quotes
$query = str_replace('"', '', $query);
// Split into words
$query_array = preg_split('/[\s,\+\.]+/',$query);
// Make single string
$query_terms = implode(' ', $query_array);
// Format for HTML display
$query_terms = htmlspecialchars(urldecode($query_terms));
}[/code]
so now I need to know how to select the items in my db, compare $query_terms with those items in db, match identical words such as "Denver", drop non matching words, and make the matched words available for use on the main page.
Thanks for your time, I could really use some help with this one.
Michael Smith
