|
 |
|
| Author |
Topic: Top 10 Search Keyword ?? |
|
synoo
New Member
|
  
|
Would appreciate if the next version comes with something like this, a script to display top 10 keywords search in the front and top 20 in the back...
Mariusz
|
Total Posts: 39 | Joined:
Apr 14, 2003 - 7:02pm | IP
Logged
|
|
 |
Camchoice |
New Member
|
|
I agree that a script like that would be most interesting !
Webmaster
Camchoice.com |
Total Posts: 16 | Joined:
Jun 11, 2003 - 12:44pm | IP
Logged
|
|
FocalMedia Team
Moderator
|
|
This is currently in the works.
Gerrit
|
Total Posts: 1455 | Joined:
Jul 27, 2002 - 4:28am | IP
Logged
|
|
 |
ikku |
New Member
|
|
Hey Guys,
I have a script for you to display the top XX search words. It is a PHP script, so your servers need to support PHP (but I'm sure they do). I'm not good in PHP and all, so it took me a bit less than a day to figure out how to work with MySQL.
PSEEK stores its results in MySQL tables. So I figured I could fetch those same results with PHP. And I was right 
Just download the script, rename it to whateveryoulike.php and open it in a text/HTML or PHP editor. Then change the variables that need changing, upload it to your host and run the script.
I am still setting up my PSEEK directory myself, so I only had about 30 searches in my history (from testing). So I'm not really sure how fast this script is. However, it lets MySQL do the most important calculations instead of using loops in PHP, so this script should be as fast as possible.
Here's the script:
http://www.flippy.nl/pphlogger/dlcount.php?id=ikku8&url=http://home.kabelfoon.nl/~jahe/topresults.zip
Tell me if this one works for you!
Rolf
|
Total Posts: 3 | Joined:
Jul 7, 2002 - 2:36pm | IP
Logged
|
|
ikku
New Member
|
|
Well seeing that I had the code, and I wanted to add some more for my own site, I decided I might as well post this code here as well.
I wrote some extra code so users can not only see the top searched keywords, but they can also search for keywords and see how often others have searched for those keywords in de PSEEK engine.
So like, the famous keyword tool of Overture, this script gives your potential advertisers the ability to see how often certain keywords have been searched for on your site and thus lets them pick the right keywords for their listings.
I first used the fulltext search option of MySQL that the PSEEK crew used for the engine as well. However, this function doesn't allow for keywords smaller than 4 letters. To me, that's quite a big flaw, so I tried the following line:
$result = mysql_query(SELECT keyword, COUNT(keyword) AS aantal FROM keywlog WHERE `keyword` LIKE '% . $kword . %' GROUP BY keyword ORDER BY aantal DESC LIMIT $nr_terms2)
This results in all keywords being accepted. It also results in all keywords being listed that match the word you are looking for.
For instance:
In your DB you have the keywords: email, e-mail, mail
A search for the keyword mail, would result in the listing of all of the 3 above words (and their corersposning number of instances people have searched for them on your site).
If a user searches for just one letter for instance, the script might find thousands of results. So a capping has been put into place, so not more than a certain amount of results will be displayed.
Here's the file:
http://www.flippy.nl/pphlogger/dlcount.php?id=ikku8&url=http://home.kabelfoon.nl/~jahe/topkeywords.zip
I hope this code works for the people that want to try it. It works for me. If not, you can always use it to create something better for yourself. Like I said, I made it for my own site, but seeing that perhaps some other people might be interested in it, I decided to post it here. I hope that's OK by the FM staff
Rolf
|
Total Posts: 3 | Joined:
Jul 7, 2002 - 2:36pm | IP
Logged
|
|
FocalMedia Team
Moderator
|
|
Thanks Rolf,
For others reading this: In PowerSeek you can use the option of not using fulltext searching to overcome the 4 letter keyword minimum. To change this click the 'settings' tab. Then click 'Global Engine Settings'. Look for a setting that reads 'Search Method:' and set it to 'Use PowerSeek's Relevance Formula'.
Gerrit
|
Total Posts: 1455 | Joined:
Jul 27, 2002 - 4:28am | IP
Logged
|
|
|
Forum Legend |
|
New Member
|
|
Reply
to topic |
|
More
than 50 posts | Member
|
|
Reply
to topic with quoted message |
|
More
than 100 posts | Full Member
|
|
Edit
Message |
|
More
than 150 posts | Advanced Member
|
|
View
profile |
|
More
than 200 posts | Advanced Member |
|
Email
member |
|
|
