Retrieving data and displaying it on a web page

[devnewbie]

Hi,

I was wondering if someone would be so kind to point me in the right direction. I would like to retrieve address from a database (could be as simple as a excel spreadsheet) and display them on my website.
A user should be able to enter a zip code in a query/search box and retrieve all of the addresses listed in the database with that zip code.

Is there a pre-existing script I might be able to use? If not, any suggestions or help would be highly appreciated.

Thanks,

Natalie

[jenkinsloveschicken]

Hi,

I was wondering if someone would be so kind to point me in the right direction. I would like to retrieve address from a database (could be as simple as a excel spreadsheet) and display them on my website.
A user should be able to enter a zip code in a query/search box and retrieve all of the addresses listed in the database with that zip code.

Is there a pre-existing script I might be able to use? If not, any suggestions or help would be highly appreciated.

Thanks,

Natalie

Natalie,

I am unaware of any pre-existing scripts, although I'm sure they are out there. Kind of need to decide how you are going to manage the base data before going forward with scripting. Connecting to an Excel spreadsheet over ODBC or ADO is going to work much differently than building your script to retrieve results from a mysql table or even an Access table. However, I would suggest using a mysql table if you have access to create and connect to one.

What you are wanting to accomplish shouldn't be that difficult once you figure out your data management. Reply with more info if you need further assistance.

Regards,
Jenkins

[devnewbie]

Natalie,

I am unaware of any pre-existing scripts, although I'm sure they are out there. Kind of need to decide how you are going to manage the base data before going forward with scripting. Connecting to an Excel spreadsheet over ODBC or ADO is going to work much differently than building your script to retrieve results from a mysql table or even an Access table. However, I would suggest using a mysql table if you have access to create and connect to one.

What you are wanting to accomplish shouldn't be that difficult once you figure out your data management. Reply with more info if you need further assistance.

Regards,
Jenkins

Hi Jenkins,

Thanks for your quick response. I have a couple more questions.
1) So if I create a MySQL database on the web server that would be best choice to store data if I intent do retrieve it for display on a website?

2) How long would it take an experienced web developer to write such a script?

3) Do you guys freelance at all?

Again, thanks a lot for you help.

Natalie

[Bodyloss]

Hey
Ive absolutely no idea if people do free-lance work here.
But setting up a MySQL database can be relatively easy., however if your new to web-development download and install Wamp Server as this is very easy to setup and start developing with (though its not a great idea to use as a public server).
Writing such a script would be pretty simple i think though, once you get your head round retrieving data from the database it'll be a doddle.
Good luck

[jenkinsloveschicken]

Natalie,

1) So if I create a MySQL database on the web server that would be best choice to store data if I intent do retrieve it for display on a website? - In my opinion this would be the best way to go.

2) How long would it take an experienced web developer to write such a script? - This depends on several factors. I would say that if you already have a site and base template layout that can be re-used that it shouldn't take too long. I would say something to the tune of 2-3 days(probably less) depending on if you want to integrate security features/sessions or things of that nature.

3) Do you guys freelance at all? - I can't speak for the forum as I am kinda new around here, but I would certainly be willing to lend assistance if needed. And there are many more folks on here that are far more experienced than I am.

Feel free to PM me once you get setup if you need help getting started on developing the script.


Regards,
Jenkins