Quick Search from huge datas

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SUMMANANA
    New Member
    • Feb 2008
    • 1

    Quick Search from huge datas

    Hi php Grop members..

    I am one of the php programmer holding as a next to beginners level.
    I got one new site like yellow pages. I need to store more that 10 lakhs of information as well as i have to retrieve data from that huge set using KEYWORD. So that i want to know the easy procedure to get values quickly[Filter datas] using keywords anybody know kindly answer to me.
  • rohypnol
    New Member
    • Dec 2007
    • 54

    #2
    Originally posted by SUMMANANA
    So that i want to know the easy procedure to get values quickly[Filter datas] using keywords anybody know kindly answer to me.
    I think the best approach would be to store everything in the database and filter the information using <SELECT rows FROM table> queries having <WHERE field LIKE 'input'> clauses. Of course you need to sanitize the user input before putting it in the statement.

    Comment

    • Markus
      Recognized Expert Expert
      • Jun 2007
      • 6092

      #3
      Originally posted by SUMMANANA
      Hi php Grop members..

      I am one of the php programmer holding as a next to beginners level.
      I got one new site like yellow pages. I need to store more that 10 lakhs of information as well as i have to retrieve data from that huge set using KEYWORD. So that i want to know the easy procedure to get values quickly[Filter datas] using keywords anybody know kindly answer to me.
      I suggest getting familiar with php and mysql first.

      Mysql (database) is a paramount key for this project of yours - it'll save immense amounts of time.

      Google for some begginer tutorials
      tizag has a good one

      Regards.

      Comment

      • aktar
        New Member
        • Jul 2006
        • 105

        #4
        Just to pick up on rohypnols comments, if you have a very large databse then efficiency will also be very important.

        If you're going to search a field that holds sentences instead of single words, then its a good idea to enable fulltext on that field and use match() against() pair for your search, eg:

        [CODE=mysql]MATCH(field_nam e) AGAINST('your_k ey_word') [/CODE]

        Comment

        Working...