Simple Database Wtih Filter-As-You-Type Search - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Programming
Click Here to Login
Thread Tools Display Modes
Old 08-09-2012, 10:41 AM   #1 (permalink)
Super Techie
Join Date: Jan 2004
Posts: 272
Default Simple Database Wtih Filter-As-You-Type Search

Our organization deals with many different personal contacts with mailing addresses on file. These addresses all have a "region code" assigned to the city, based on geographical location.
We currently have this list of region codes in a shared spreadsheet and whenever we need to lookup a city or number, we have to open that file in Excel and use the built-in Find function.

What I'd like to do is create a simple webpage that can be hosted locally on our office server that will simply display our entire list of cities and their corresponding region codes and then have the ability to filter that list as you type, similar to this example:

How to build a fast, simple list filter with jQuery

Is there a way to use this method of filter-as-you-type but with an external text file of some sort? The list is routinely updated with new cities and region codes so I'd like to be able to quickly update an external file (preferably a file based on a spreadsheet for sorting purposes) and immediately have those changes reflected on the webpage.

Thanks for your help.

Blizzard596 is offline   Reply With Quote
Old 08-10-2012, 10:09 AM   #2 (permalink)

Baez's Avatar
Join Date: Sep 2005
Location: Toronto, Canada
Posts: 6,987
Default Re: Simple Database Wtih Filter-As-You-Type Search

Moved to Programming.

Take a look at jQuery UI Autocomplete Remote Datasourcing. You can pull from a file or database. I would suggest using a CSV file and parse that into a JSON string that Autocomplete can use.

Baez is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for a Tiny, Simple, Searchable Database List Program Blizzard596 Servers and Virtualization 1 08-23-2011 09:32 PM
i want to create simple database linux1880 Programming 4 09-29-2007 12:01 PM
database type thing funkywaggnelz Computer Networking and Internet Hardware 4 08-27-2007 01:27 PM
Database search anshu SEO and Web Traffic 1 05-29-2007 01:20 PM
Database search anshu Internet Software and Browsers 0 05-29-2007 02:06 AM

All times are GMT -5. The time now is 02:00 AM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2020, vBulletin Solutions, Inc.