...

View Full Version : I don't know what scripting language I need to solve my problem - Please Help



kstew923
03-27-2012, 03:53 AM
I am not super familiar with code - I can easily take code and with a little direction get the desired end result so anyone who can help me with this it will be VERY appreciated. I don't even know what terms to search in order to create a page that I am looking for....

So here goes:

I want to model our distributor page after a R E D K E N.com Distributor Locator Page.

Here is what happens....

There is a drop down menu of the 50 states, and when you select the state the table of information below changes.

screen shots below
http://www.norvelltanning.com/Screen%20Grab%201.jpg

http://www.norvelltanning.com/Screen%20Grab%202.jpg

http://www.norvelltanning.com/Screen%20Grab%203.jpg

I am sure this is fairly easy to resolve, however I don't know where to begin.

Thank You in advance for your time.

Kristi

Old Pedant
03-27-2012, 07:04 AM
How many *TOTAL* distributors are there in the USA?

If under a few hundred, you could do this all in a single HTML page with JavaScript.

If more, you will likely need to use server-side coding as well.

Also, be aware that if you do use JavaScript, then anybody who disables it in their browser (moderately easy to do...and there are a lot of idiotically paranoid people out there) won't be able to use the page.

It's really a case of pick your poison. If you can do it all in a single page, that will be the easiest route, if you don't mind the JavaScript-must-be-enabled restriction.

Mishu
03-27-2012, 07:09 AM
It's really a case of pick your poison.
You don't even have to put yourself in that sort of situation. If a task can be done both server and client side, then it should always be done server side. Very often it can be done with less code server side. If it can't be done server side then the only other option is obvious. If you do it server side then you also don't have to worry about portable or mobile devices that don't even support javascript.

Old Pedant
03-27-2012, 07:48 AM
Well, first of all, this person strikes me as a real newbie who may be looking for the easiest rather then the best solution.

But I do think that the best solution to this question might well be a two-pronged approach. Build it so that it could run with, say AJAX, but would have a fallback of server-only code.

That wouldn't really be very difficult to achieve and would give you a better "feel" for those who do have JS enabled.

Having said that, though, if I *had* to make an "either/or" choice, yes, I'd go all server-side.

felgall
03-27-2012, 08:26 AM
Build the server side only version first - then enhance it with JavaScript.

kstew923
03-27-2012, 02:30 PM
Thank you all for your feedback. It sounds as if I need to go with the "server side" option since that appears to be the best option especially for those who disable JavaScript - which I am sure there are plenty of these "Types" in our industry.

Currently our distributor list is at about 85, however we have just signed on with 3 large distribution houses that have 300+ locations each, so I want to find a solution now before having to add the 900+ locations to our site.

So if someone can point me in the right direction of a tutorial or tips on how to implement this server side it would be appreciated.

Philip M
03-27-2012, 02:45 PM
So if someone can point me in the right direction of a tutorial or tips on how to implement this server side it would be appreciated.

As this is a commercial application it would make best sense to employ a programmer to do the job for you - just as you would employ any other sort of expertise required for your business.

Old Pedant
03-27-2012, 10:35 PM
Philip is of course right.

This would take a professional programmer an hour or two to write, assuming you have a database (or at least an Excel spreadsheet?) of the company names and addresses.

As for what server-side system to use: PHP or JSP or ASP or ASP.NET.

If it's an Excel spreadsheet, and if you would prefer to leave it in a spreadsheet so it's easy for a non-programmer person to update and add a new version, then doing it in ASP or ASP.NET would be easy, as they can directly treat an Excel file as a database.

Partly, this will depend on what kind of server machine you are going to use. If it's a Linux box, you are probably going to want to use PHP with MySQL database. ASP and ASP.NET only run on Windows servers.

Are you capable of doing the page design? Using HTML code? Or would you just give this as, say, a WORD document or some such to the programmer and say "make it look like this"?

kstew923
03-28-2012, 04:14 AM
Philip is of course right.

This would take a professional programmer an hour or two to write, assuming you have a database (or at least an Excel spreadsheet?) of the company names and addresses.

As for what server-side system to use: PHP or JSP or ASP or ASP.NET.

If it's an Excel spreadsheet, and if you would prefer to leave it in a spreadsheet so it's easy for a non-programmer person to update and add a new version, then doing it in ASP or ASP.NET would be easy, as they can directly treat an Excel file as a database.

Partly, this will depend on what kind of server machine you are going to use. If it's a Linux box, you are probably going to want to use PHP with MySQL database. ASP and ASP.NET only run on Windows servers.

Are you capable of doing the page design? Using HTML code? Or would you just give this as, say, a WORD document or some such to the programmer and say "make it look like this"?

I am not necessarily a newbie when it comes to web design or HTML - but I am definitely self taught. I have added PHP and MySQL data bases to our website etc, and can easily follow tutorials.

I have no problem with getting a programmer to take care of this for us, and putting the information in an excel file is absolutely no problem.

Whatever route we choose I want to make sure that is something that can be update easily on our end.

If this is something I could do myself with a little direction I would love to know how to do it as I can see where something of this nature might behoove us in the future, if it is over my head I am not afraid to say so and would happily pay an expert in the programming field to execute this application so it works flawlessly within our site.

I am beginning a MAJOR overhaul of our website as it is not as user friendly as it needs to be so I would like to easily move this feature to the new site once it is up and running.

Old Pedant
03-28-2012, 05:15 AM
Well, if you are on a Windows server, then you could certainly use PHP with Excel.

When running PHP on Windows, there is a build in object named COM that allows easy access to Excel.

I don't use PHP, but if you know enough PHP to attempt this, I can show you the basics.

But it's really time to move this thread to whatever server-side system you are going to use. PHP or ASP or whatever.

Post an appropriate question in one of those appropriate forums.

kstew923
04-05-2012, 07:03 AM
Thank you for your help. We are working to decide the best route for this will post appropriate forum so the thread can move.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum