SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Feb 2004
    Location
    Chicago
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    AJAX Autocomplete FAQ Search

    I was planing to make an autocomplete FAQ section in AJAX with search
    The moment user will type a complete word in the search box, he will get results in the page
    How to accomplish this?
    San
    Primary email: advanced.programmer@gmail.com
    MSN/Email: advanced_programmer@hotmail.com

  2. #2
    SitePoint Member
    Join Date
    Jan 2005
    Location
    Tintern
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I did something similar on the glossary on my site (http://thescriptorium.co.uk/ajaxglossary.htm)

    This uses the key event to re-read the MySQL database based on a "like" using the input so far and is really fast. If you have a large amount of data though this could be trying on the server.
    Nemo mortalium omnibus horis sapit

  3. #3
    SitePoint Member
    Join Date
    Feb 2004
    Location
    Chicago
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by melles
    I did something similar on the glossary on my site (http://thescriptorium.co.uk/ajaxglossary.htm)

    This uses the key event to re-read the MySQL database based on a "like" using the input so far and is really fast. If you have a large amount of data though this could be trying on the server.
    Thats cool
    One suggestion:
    You might want to consider using Mysql Full Text search feature for making it more fast and relevant
    http://dev.mysql.com/doc/refman/5.0/...xt-search.html

    Anyways, my plan is that while the user types the word, results dont show up till he has completed atleast one word and the moment he completes one word, he is shown the relevant links to the results
    Would it become slow that way?
    Primary email: advanced.programmer@gmail.com
    MSN/Email: advanced_programmer@hotmail.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •