my site acts search engine people enter search queries on main page. wanted make trending / recent feature each query gets recorded mysql database, data, calculates searches being searched most, , displayed on page labeled trending searches. also, under that, "recent searches" displays last 5 or searches.
honestly, have no experience mysql. don't know how move data site mysql. appreciated. searched , searched these questions , google, didn't find anything. thanks!
first of all, need create database, in want table timestamp , keyword that's been searched. (create table)
then want store each keyword access table (insert ... values ...)
then can select top key words creating select query "group keyword", order ing count(*) (the number of occurrences of keyword)
this bit vague, you'll need go through number of steps i've uppercased terms you'd need google each step. come if run complications in of steps!
Comments
Post a Comment