Solved

How Can I do this?

Posted on 2004-09-29
13
254 Views
Last Modified: 2013-12-24
I have a website which is "Professionals Directory". I have separate website for each professional. On the main  "Professionals Directory"website, I like the visitor to be able to choose the right professional by three drop downs. For example the first dropdown will list the tyoe of profession. For example
Plumber
Tinker
Mechanic
carpenter
etc.
Second dropdown will ask the visitor to enter his Zipcode, so that it will list the plumber or carpenter in his area of residence.

The third dropdown will be Language. Here the visitor will select the language spoken e.g. English, Chinese, Portugese etc. by the professional, so that a Chinese speaking customer can look for a tradesman who speaks the language.

0
Comment
Question by:msahib
  • 3
  • 3
  • 2
  • +2
13 Comments
 
LVL 7

Accepted Solution

by:
DavidBirch2dotCom earned 25 total points
ID: 12182297
for the basics:

you needs a database with the professionals and info about them, Name, Profession, Language, Address (watch you dont give this out elese the experts might not like u :) )

you would then need to query that database using the selections of the list box's which would be populated from the database - have a look @ ASP to get this done - its probably the best language for this

David
0
 
LVL 33

Expert Comment

by:humeniuk
ID: 12182933
Right, a database is the best option for storing the directory information.  Then you will use a scripting language like ASP or PHP to establish an interaction between your web pages & forms and the database.  Your choice as to which scripting language should be based on which one you are more familiar with (if any), what languages your hosting company supports (if you already have a website and hosting).  ASP and PHP are very similiar in terms of function, so I don't agree with David that ASP is better.

For a database, you can use MySQL with either language, although it is more commonly associated with PHP.  It's an open source (ie. free) database that works extremely well and is very popular.  There are other choices, though such as PostgreSQL (also open source - it's supposed to be very good, but I've never used it myself), MS SQL, or even Access, although it probably isn't adequate for what you are trying to do.

Whichever scripting language and database you use, the process is very similar.  The user will select a profession, zip code, and language preference and submit the form.  The scripting language will query the database and return any entries that the match the criteria selected by the user.  It can also create a dynamic page based on and listing these results.  Alll you have to do is choose a scripting language and database and then learn how to program the pages you want   :)
0
 

Author Comment

by:msahib
ID: 12182945
Dear David:
Thank you so much for your help. I will try!

Have a nice day.

Mike
0
 

Author Comment

by:msahib
ID: 12183057
Dear Hume:

I truly appreciate your detailed response. Could you please suggest to me a website where I can learn more on this, from the basics?

Much obliged.

Mike
0
 
LVL 33

Assisted Solution

by:humeniuk
humeniuk earned 25 total points
ID: 12183196
Here are some tutorials that should get you started:

PHP tutorial (you can skip the installation stuff if you're using a hosting company): http://www.w3schools.com/php/default.asp

ASP Tutorial (again, you may not need the installation info): http://www.w3schools.com/asp/default.asp

Using PHP with MySQL: http://webmonkey.wired.com/webmonkey/programming/php/tutorials/tutorial4.html

There is a lot of great PHP info on the official PHP website (see www.php.net), including a basic overview at http://www.php.net/manual/en/introduction.php.  The MySQL website is www.mysql.com and it also includes an introductory tutorial: http://dev.mysql.com/doc/mysql/en/Tutorial.html.

Remember that whichever solution you choose, it is going to take some time to learn how to use them properly, but it is well worth the effort.  Also recommended is www.hotscripts.com, which features numerous PHP & ASP (and other) scripts that are available for use, most of them free.  You can often find a script that does what you are looking for or one you can modify for your purposes, saving you a lot of time.

I hope this helps.
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

Author Comment

by:msahib
ID: 12190194
Much obliged for all this good info.

Mike
0
 
LVL 33

Expert Comment

by:humeniuk
ID: 12190311
Glad to help out.
0
 

Expert Comment

by:SlayerX
ID: 12193758
www.hotscripts.com is one of the best for your needs, it offers most solutions for your problems.
0
 
LVL 2

Expert Comment

by:udayms
ID: 12336145
Hi, Check if this is what you are looking for? Just cut and paste this into a HTML file and view it in a browser.

***********************************************************************
<html>
<FORM name="isc">
<table border="0" cellspacing="0" cellpadding="0">
  <tr align="center">
    <td nowrap height="11"> &nbsp;

<select name="example" size="1" onChange="redirect(this.options.selectedIndex)">
<option selected>---Select1-------------</option>
<option>Coding</option>
<option>Managing</option>
</select>

<select name="stage2" size="1" onChange="redirect1(this.options.selectedIndex)">
<option value=" " selected> </option>
<option value=" " selected>---Select2--------------</option>
</select>

<select name="stage3" size="1" onChange="redirect2(this.options.selectedIndex)">
<option value=" " selected> </option>
<option value=" " selected>---Select3----------------</option>
</select>

<script>
<!--

var groups=document.isc.example.options.length
var group=new Array(groups)
for (i=0; i<groups; i++)
group[i]=new Array()

group[0][0]=new Option("---Select2---"," ");

group[1][0]=new Option("Now Select This One"," ");
group[1][1]=new Option("Web Design","47");
group[1][2]=new Option("JSP","46");
group[1][3]=new Option("EJB","45");

group[2][0]=new Option("Now Select This One"," ");
group[2][1]=new Option("Design","115");
group[2][2]=new Option("Development","116");

var temp=document.isc.stage2


function redirect(x){
for (m=temp.options.length-1;m>0;m--)
temp.options[m]=null
for (i=0;i<group[x].length;i++){
temp.options[i]=new Option(group[x][i].text,group[x][i].value)
}
temp.options[0].selected=true
redirect1(0)
}



var secondGroups=document.isc.stage2.options.length
var secondGroup=new Array(groups)
for (i=0; i<groups; i++)  {
secondGroup[i]=new Array(group[i].length)
for (j=0; j<group[i].length; j++)  {
secondGroup[i][j]=new Array()  }}

secondGroup[0][0][0]=new Option("---Select 3---"," ");
secondGroup[1][0][0]=new Option("---Select 3---"," ");
secondGroup[1][1][0]=new Option("Now Select Associate"," ");
secondGroup[1][1][1]=new Option("Uday","mailto:uday@indsoft.co.in");
secondGroup[1][1][2]=new Option("Latha","mailto:latha@indsoft.co.in");
secondGroup[1][1][3]=new Option("Anup","mailto:anup@indsoft.co.in");

secondGroup[1][2][0]=new Option("Now Select Associate"," ");
secondGroup[1][2][1]=new Option("Dinesh","mailto:dinesh@indsoft.co.in");
secondGroup[1][2][2]=new Option("Mohan","mailto:mohan@indsoft.co.in");
secondGroup[1][2][3]=new Option("Krishnakumar","mailto:kk@indsoft.co.in");

secondGroup[1][3][0]=new Option("Now Select Associate"," ");
secondGroup[1][3][1]=new Option("Bibil","mailto:bibil@indsoft.co.in");
secondGroup[1][3][2]=new Option("Bobby","mailto:bobby@indsoft.co.in");

secondGroup[2][0][0]=new Option("---Select 3---"," ");
secondGroup[2][1][0]=new Option("Now Select Associate"," ");
secondGroup[2][1][1]=new Option("Piby","mailto:piby@indsoft.co.in");
secondGroup[2][1][2]=new Option("Shakthi","mailto:sakti@indsoft.co.in");
secondGroup[2][1][3]=new Option("Rakesh","mailto:rakesh@indsoft.co.in");
secondGroup[2][1][4]=new Option("Bijay","mailto:bijay@indsoft.co.in");

secondGroup[2][2][0]=new Option("Now Select Associate"," ");
secondGroup[2][2][1]=new Option("George","mailto:george@indsoft.co.in");
secondGroup[2][2][2]=new Option("Sethu","mailto:sethu@indsoft.co.in");

var temp1=document.isc.stage3
function redirect1(y){
for (m=temp1.options.length-1;m>0;m--)
temp1.options[m]=null
for (i=0;i<secondGroup[document.isc.example.options.selectedIndex][y].length;i++){
temp1.options[i]=new Option(secondGroup[document.isc.example.options.selectedIndex][y][i].text,secondGroup[document.isc.example.options.selectedIndex][y][i].value)
}
temp1.options[0].selected=true
}

function redirect2(z){
window.location=temp1[z].value
}

//-->
</script>

            </td>
  </tr>
</table>
</FORM>

</html>
***********************************************************************

Cheers,
Uday
0
 

Expert Comment

by:SlayerX
ID: 12339540
You can sometimes go to http://www.google.com and type "html scripts"  or
"form scripts" if you want to explore those areas of your interest.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now