/    Sign up×
Community /Pin to ProfileBookmark

Design / strategy question re listboxes

I’m in the process of converting a prototype 😉 booking system that I built 8 years ago in a database scripting language ( Lotus Approach ).

Obviously, the time has come to code The Real Thing !!!

The original application accesses the local database to produce a dropdown list with about 3500 entries. It has a typeahead function, and the response time is very acceptable.

The question: What would be the best way to do this with my new setup?

I am using Linux, Apache and PHP (+Smarty) / Mysql on the server with Javascript on the client.

What would be the best way of coding this functionality, given a web-based architecture, on a local network? Although I have not measured this yet, I am concerned about response time. I imagine that I would need to code the dropdown in Javascript, but am hoping for input from others on this. What other ways are there of doing this?

The data of the dropdown list is somewhat dynamic, so it is not sufficient to place a one-time copy on the client, although it does not change very actively.

I appreciate any thoughts, and hope the cross-application question is not offensive!

Steve

to post a comment
JavaScript

2 Comments(s)

Copy linkTweet thisAlerts:
@MongusMar 18.2005 — Sounds like you want to do something like this:

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

Start typing in the search box and be amazed! ?

There's a guy that examined the source and reported on it here:

[URL]http://serversideguy.blogspot.com/2004/12/google-suggest-dissected.html[/URL]

I'm actually going to build a widget to do this in JavaScript before too long but I don't have anything to show you yet.
Copy linkTweet thisAlerts:
@scronjeauthorMar 18.2005 — [i]Originally posted by Mongus [/i]

[B]Sounds like you want to do something like this:

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

Start typing in the search box and be amazed! ?

[/B]
[/QUOTE]

Wow!! That would be it!!!

[B]

There's a guy that examined the source and reported on it here:

[URL]http://serversideguy.blogspot.com/2004/12/google-suggest-dissected.html[/URL]



I'm actually going to build a widget to do this in JavaScript before too long but I don't have anything to show you yet. [/B]
[/QUOTE]


I'll keep an eye out for it

Steve
×

Success!

Help @scronje spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.6,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...