Re: php / mysql / js search result question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi -

It sounds like you're trying to implement something similar to "google
suggest" which uses ajax to allow a user to navigate through a large
list of entries. The "google suggest" method does use a lot of calls
to the database but its asynchronous which eliminates cumbersome page
loads.

http://www.google.com/webhp?complete=1&hl=en

I found this article which gives advice on how to implement "google
suggest" using php:

http://www.phpriot.com/d/articles/php/application-design/google-suggest-ajaxac/

A quick google search on +php +"google suggest" +ajax came up with
others as well.

If you're just interested in the javascript (i.e. you're not
navigating that large of a list) these articles should be able to help
with that as well.

- schnippy

On 12/27/05, Dave Carrera <dave@xxxxxxxxxxxxxx> wrote:
> Hi List,
>
> I have a very long list of customer names which i know is easy to get
> from a mysql result using php, no prob there.
>
> But what i would like to do is offer input box and when the user enters
> a letter, i think this will require client side onchange(), the full
> list, i think might be in an iframe, will move to the first instance of
> user input.
>
> Example:
>
> 1 Alpha Customer
> 2 Apple Customer
> 3 Beta Customer
> 4 Crazy customer
> 5 Doppy customer
>
> User input is "a" so the list moves to first instance of "a".  User
> continues to input "ap" so the list moves to "2 Apple Customer" and so on.
>
> If the user had input "d" then the list would move to "5 Doppy customer"
> and i suppose this could  become selected ready for the user to hit the
> return key to select this customer.
>
> I would prefer to not do multiple "POSTS" and return result, which i can
> do already, so i think some natty client side JS might do the trick but
> i have very little knowledge of this.
>
> Any urls or direct help / advise is gratefully received.
>
> Thank you in advance
>
> Dave c
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux