Posted by Greg Schnippel on 12/29/05 18:32

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@drumsplace.com> 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
>
>

[Back to original message]