Suzanne — Sat, 20 Sep 2003 21:32:07 +0000

http://www.mysql.com
http://www.php.net
http://www.phpmyadmin.net/
http://www.perl.com

All are open-source languages/applications and are free to use. You must, however, do all support and installation yourself. Happily, there is a large community to help you through the process.

Princess4ubabe — Sat, 20 Sep 2003 20:56:58 +0000

does it cost to use mysql?

druagord — Thu, 18 Sep 2003 21:39:18 +0000

mysql is a database server the easiest way to access it is to use php wich is a server side scripting language. With that kind of system you can thousands of adress and the search will still be fast

Princess4ubabe — Thu, 18 Sep 2003 20:56:03 +0000

Is mysql a program or a scripting language?

druagord — Wed, 17 Sep 2003 14:34:32 +0000

One thing you have to be careful with that kind of application is the growth of the list. probably for now the customer just a few adress to search from. but when he is going to see the result is going to get all exited and he will insert a few thousand adress then he will come back to you and say that everything is slow

wheaties_box — Wed, 17 Sep 2003 09:00:59 +0000

well, all of the info is still hardcoded *somewhere*, whether it be the actual HTML file or an external .js. The external .js would actually be a better idea if you plan on adding addresses at all... That way you don't have to fool around with the HTML file at all.. just addresses.

Abhishek Reddy — Wed, 17 Sep 2003 04:07:35 +0000

You don't have to hardcode it into the page. Stick the array in a .js file and call it using <script src="">.

Or you could indeed use an xml file and write a parser in JS (I don't know of any existing scripts, but it's likely there are).

I made a JS search once, and it was, well, limited. Imo, expanding JS search functionality is wasted effort. Use it for procuring PHP or similar alternatives.

wheaties_box — Tue, 16 Sep 2003 20:26:35 +0000

yes, yes... I too prefer MySQL far more than flat text files. but we have to work with what we have available, eh?

as for doing this with JavaScript....what I would do is create an array for addresses. Enter each address as a separate element, then you can search amongst the contents of the elements using some functions that JavaScript has built-in. I'll have to do more research to get specifics to ya (it's been a long while since I did this sort of thing in JS), unless you don't mind doing some light research yourself?

The problem with this approach (minus PHP) is that each address would be hard-coded into the page. It's not all that bad, but it's just..not my cup of tea anymore . It does make things expandable, tho.

You could also make an array for each part of the address to make things a little more interesting. It's not really practical for this application, but it is possible. This sort of approach could be used to ... say, tell how many addresses there are with a certain zip code or a certain street or a certain city... blabla. just a thought.

what say you?

Suzanne — Tue, 16 Sep 2003 18:14:53 +0000

You can use an xml "database" which is essentially a special text file. But it's probably more work than you're looking for.

A common database is http://www.mysql.com and you can use PHPMyAdmin to administer it (using http://www.php.net as the language) but it depends on your needs. Personally I find it easier to use a database than a text file, but it's up to you.

Princess4ubabe — Tue, 16 Sep 2003 17:04:12 +0000

Javascript would work.
Can you tell me how!
(I'd also like to know how to do it in php, but I think my only option would be javascript)
They don't have a database. Can I do it from a plain text file or something? Do I need a certain program or system to do a database?