Page 1 of 1
View search queries
Posted: Thu Jun 21, 2007 4:21 pm
by spamyboy
My client requested "View search queries" ability, recording all maden queries would be stupid - any sugestions ?
Or maybe you have some premade stuff that would fit this.
Posted: Thu Jun 21, 2007 4:27 pm
by John Cartwright
What exactly is "View search queries"
Posted: Thu Jun 21, 2007 4:30 pm
by superdezign
Do some regex on the referrer.
Posted: Thu Jun 21, 2007 4:47 pm
by spamyboy
Jcart wrote:What exactly is "View search queries"
I wish I would knew what did he waned, probaly he waned to see most serachable titles (website is about lyrics), this plugin (as I think) should probaly show / start counting for e.g. only those queries that were entered atleast 10 time or it could basicly show last 20 search queries - have you guys never done such things before ?
Posted: Thu Jun 21, 2007 4:55 pm
by superdezign
Certain hosts (such as GoDaddy) do it for you. Like I said, just parse it from the referrer URL. Search queries are (typically) sent through the URL.
Posted: Thu Jun 21, 2007 5:05 pm
by spamyboy
superdezign wrote:Certain hosts (such as GoDaddy) do it for you. Like I said, just parse it from the referrer URL. Search queries are (typically) sent through the URL.
I were talking more like about local website seacrh...
Baisicly he want's to look what lyrics peoples are looking in his website.
Posted: Thu Jun 21, 2007 5:15 pm
by superdezign
Oh. And you want to record the frequency?
Assuming you have full access to the queries, you could do something along the lines of this for each word (database-wise):
Code: Select all
REPLACE `queries` (`word`, `freq`) VALUES ('$word', `freq` + 1);
I think if you give the frequency column a default value of 0, that should work.
Posted: Thu Jun 21, 2007 5:25 pm
by John Cartwright
spamyboy wrote:Jcart wrote:What exactly is "View search queries"
I wish I would knew what did he waned, probaly he waned to see most serachable titles (website is about lyrics), this plugin (as I think) should probaly show / start counting for e.g. only those queries that were entered atleast 10 time or it could basicly show last 20 search queries - have you guys never done such things before ?
I would consider this a big problem... if you don't know what he wants there is a lack of a communication, and possibly a product he is not happy with.