how to track search phrases

[mga_ka_php]

how do i track the search phrases used by users in search engine to go to my website?

[flyhoney]

Do you have a mysql database?  If you do, create a search_phrases table in your database.  Whenever anyone searches, add an entry for their search phrase.  Along with the search phrase, have a count column.  If someone searches for a phrase that already exists in the database, increment the count column.

 

<?php
$query = $_GET['query'];
$query = "SELECT COUNT(*) as total FROM search_phrases WHERE phrase = '". mysql_real_escape_string($query) ."'";
// Im honestly too drunk to finish this code, but if the search phrase exists, increment the count, if it doesnt, insert it into the database.
?>

 

[mga_ka_php]

how do $_GET['query'] will have value?

 

i add  echo $_GET['query'] into my index.php

 

then go to google then entered the search phrases then click my site and it doesn't have a value

 

how do i get that search phrase?

[mga_ka_php]

anyone?

[RussellReal]

$_SERVER['HTTP_REFERER'];

 

parse the search phrase from the referer