are site search queries listed anywhere?

[UME +]

Hi all,

I was wondering if there is a file that contains the queries users enter when using the search feature on my site? For obvious reasons, I'd like to have an idea as to what it is they are trying to find.

Thanks!

[Eric Barnes +]

No nothing is stored when a user is searching. I think you can use something like google analytics but I am not sure of all their settings if they would allow that.

[ombre +]

Originally Posted by UME

Hi all,

I was wondering if there is a file that contains the queries users enter when using the search feature on my site? For obvious reasons, I'd like to have an idea as to what it is they are trying to find.

Thanks!

This is simple to made. Just add another table search:
CREATE TABLE `search` (
`search_id` mediumint(7) unsigned NOT NULL auto_increment,
`keyword` varchar(128) NOT NULL default '',
`datum` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`search_id`),
KEY `keyword_idx` (`keyword`)
)

and in the search part you should add a insert statement in this table.

But know, if you have a busy site, your search table will be in few month big .

[UME +]

Originally Posted by ombre

This is simple to made. Just add another table search:
CREATE TABLE `search` (
`search_id` mediumint(7) unsigned NOT NULL auto_increment,
`keyword` varchar(128) NOT NULL default '',
`datum` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`search_id`),
KEY `keyword_idx` (`keyword`)
)

and in the search part you should add a insert statement in this table.

But know, if you have a busy site, your search table will be in few month big .

Thanks for the code. I'm a newbie when it comes to reading PHPcode, so how do I know where the data is being written for later retrieval? Is the name of the file 'search' as specified in the first line?

Also, what does the "insert statement" do?

Thanks again!