# Storing search value in database

**URL:** <https://www.ruby-forum.com/t/storing-search-value-in-database/169837>\
**Category:** Rails\
**Created:** [June 9, 2009, 1:30pm UTC](https://www.ruby-forum.com/t/storing-search-value-in-database/169837 "2009-06-09T13:30:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![remco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/9d8465/32.png) [@remco](https://www.ruby-forum.com/u/remco)\
**Post date:** [June 9, 2009, 1:30pm UTC](https://www.ruby-forum.com/t/storing-search-value-in-database/169837/1 "2009-06-09T13:30:37Z")

</div>

Hi,

We got a search form (with autocomplete) for airlinetickets. The idea is  
that we want to store the search query of all our visitors in our  
database. The objective is to add this info to our management info.

Someone ideas?

remco

---

<div class="post-metadata">

**Author:** ![remco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/9d8465/32.png) [@remco](https://www.ruby-forum.com/u/remco)\
**Post date:** [June 10, 2009, 7:13am UTC](https://www.ruby-forum.com/t/storing-search-value-in-database/169837/2 "2009-06-10T07:13:11Z")

</div>

[#37 Simple Search Form - RailsCasts](http://railscasts.com/episodes/37) — Simple Search form

[#111 Advanced Search Form - RailsCasts](http://railscasts.com/episodes/111) — Advanced Search

On Jun 9, 4:30 pm, Remco S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![remco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/9d8465/32.png) [@remco](https://www.ruby-forum.com/u/remco)\
**Post date:** [June 10, 2009, 12:52pm UTC](https://www.ruby-forum.com/t/storing-search-value-in-database/169837/3 "2009-06-10T12:52:55Z")

</div>

Not sure exactly what the issue is…

Create a model (say, SearchQueries) and whenever anybody hits your  
search controller — presumably you only want to capture full queries  
and not auto-complete requests – save the query into the database.

If you’re using an autocomplete search which provides links direct to  
particular pages, you may also need to capture these - probably by  
appending a parameter to the address and making sure that you create  
and save a search query when someone hits those pages straight from  
the autocomplete list.

-Matt

On Jun 9, 12:30 pm, Remco S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)