<% //developed by Ved Prakash Sharma 8/2/2005 %> <%@ page language="java" import="java.sql.*" errorPage="" %> 123world web directory new listing
Guidelines          Terms & Conditions          Payment Details           Minimum Site Criteria
123world new Listing Information
Your Site Information

Your website would be reviewed by our analysts for accuracy, quality, and functionality as laid down under the guidelines for submissions.

You are required to pay USD 49 towards the review service for your website. If found suitable and upon payment realization, your website will be listed in our web directory within 48 hours. Please remember that your site will not be included in the web directory by paying this amount only. This is a small fee for reviewing your website. Final listing is subject to terms and conditions mentioned in the guidelines.

Enter information about your site below to help us describe and categorize it. Be brief and do not use all capital letters. 123world reserves the right to edit all titles and descriptions.

NOTE: All the Fields are required to be filled:

Existing users enter email address below to get the form auto filled.

<%! String exist_btn,error; String email_txt; Connection con=null; Statement stat=null; ResultSet rs=null; int flag=0; boolean flag1=false,exist=false; String categoryitem[]={"Arts & Culture: ","Cooking","Dancing ", "Fashion Houses ", "Languages","Museums & Galleries", "Photography", "Autos: Automobiles","Motorcycles","Business: Advertising Agencies","Banks","Chambers Of Commerce","Corporate Entities","Department Stores","IT Companies","Search Engines","Shipping","Online Shopping","Stock Exchange", "Taxation","Education: Libraries","Universities", "Entertainment: Amusement Parks","Circus ","Magicians", "Movies", "Music Bands & Singers","Studios","Radio Stations","Television","Theatre", "Toon Characters", "Government: Cities","Countries","Judiciary","Military","US Departments","US States", "Health: Blindness","Children's Health", "Dentistry","Disabilities","Diseases","Environmental Health", "Epilepsy","Women's Health","First Aid","Fitness","Lead Poisoning", "Food and Nutrition","Health Care", "Men's Health","Medicine","Hospitals","Mental Health","Neurology","Procedures and Therapies", "Public Health","Reproductive Health","Senior Health","Weight Issues","News & Media: Publications","Radio Stations","Television","Organization: International","NGO's","Sport Federations","United Nations","Wildlife Associations", "Science & Technology: Archaeology","Astronomy","Observatories","Research Centers","Society: Awards","Festivals", "Political Parties","Religions","Wars Of The World","World Personalities","Travel & Tourism: Airlines","Airports", "Hotels","Railways","Seaports","Tourism","Tours and Travel"}; String stateitem[]={"Other","Alaska","Alabama","Arkansas","Arizona","California","Colorado"," Connecticut", "Washington, DC","Delaware","Florida","Georgia","Hawaii","Iowa","Idaho","Illinois","Indiana","Kansas","Kentucky", "Louisiana","Massachusetts","Maryland","Maine","Michigan","Minnesota","Missouri","Mississippi","Montana","North Carolina", "North Dakota","Nebraska","New Hampshire","New Jersey","New Mexico","Nevada","New York","Ohio", "Oklahoma", "Oregon","Pennsylvania","Rhode Island","South Carolina","South Dakota","Tennessee","Texas","Utah", "Virginia","Vermont", "Washington","Wisconsin","West Virginia","Wyoming"}; String countryitem[]={"Select Your Country of Residence","Afghanistan","Albania","Algeria","American Samoa", "Andorra","Angola","Anguilla","Antarctica","Antigua and Barbuda","Argentina","Armenia","Aruba","Australia","Austria", "Azerbaijan","Bahamas","Bahrain","Bangladesh","Barbados","Belarus","Belgium","Belize","Benin","Bermuda","Bhutan","Bolivia","Bosnia and Herzegovina","Botswana","Brazil","British Indian Ocean Territory","British Virgin Islands","Brunei","Bulgaria", "Burkina Faso","Burundi","Cambodia","Cameroon","Canada","Cape Verde","Cayman Islands","Central African Republic", "Chad","Chile","China","Christmas Island","Cocos Islands","Colombia","Comoros","Congo","Cook Islands","Costa Rica ", "Croatia","Cuba","Cyprus","Czech Republic","Denmark","Djibouti","Dominica","Dominican Republic","East Timor", "Ecuador", "Egypt","El Salvador ","Equatorial Guinea" ,"Eritrea","Estonia","Ethiopia","Falkland Islands","Faroe Islands","Fiji","Finland", "France", "French Guiana","French Polynesia","French Southern Territories","Gabon","Gambia","Georgia","Germany","Ghana", "Gibraltar","Greece","Greenland","Grenada","Guadeloupe","Guam","Guatemala","Guinea","Guinea-Bissau","Guyana","Haiti", "Heard McDonald Islands","Honduras","Hong Kong","Hungary ","Iceland","India","Indonesia","Iran","Iraq","Ireland","Israel", "Italy","Ivory Coast","Jamaica","Japan","Jordan","Kazakhstan","Kenya","Kiribati","Korea, North","Korea, South","Kuwait", "Kyrgyzstan"," Laos","Latvia","Lebanon","Lesotho","Liberia","Libya","Liechtenstein","Lithuania","Luxembourg","Macau", "Madagascar","Malawi","Malaysia","Maldives","Mali","Malta","Marshall Islands","Martinique","Mauritania","Mauritius", "Mayotte","Mexico","Micronesia, Federated States of,","Moldova","Monaco","Mongolia","Montserrat","Morocco", "Mozambique","Myanmar","Namibia","Nauru","Nepal","Netherlands","Netherlands Antilles","New Caledonia","New Zealand", "Nicaragua","Niger","Nigeria","Niue","Norfolk Island","Northern Mariana Islands","Norway","Oman","Pakistan","Palau", "Panama","Papua New Guinea","Paraguay","Peru","Philippines","Pitcairn Island","Poland","Portugal","Puerto Rico","Qatar", "Reunion","Romania","Russia","Rwanda","S. Georgia and S. Sandwich Isls","Saint Kitts & Nevis","Saint Lucia","Saint Vincent and The Grenadines","Samoa","San Marino","Sao Tome and Principe","Saudi Arabia","Senegal","Seychelles", "Seychelles","Singapore","Slovakia","Slovenia","Somalia","South Africa","Spain","Sri Lanka","St. Helena","St. Pierre and Miquelon","Sudan","Suriname","Svalbard and Jan Mayen Islands","Swaziland","Sweden","Switzerland","Syria","Taiwan", "Tajikistan","Tanzania","Thailand","Togo","Tokelau","Tonga","Trinidad and Tobago","Tunisia","Turkey","Turkmenistan", "Turks and Caicos Islands","Tuvalu","U.S. Minor Outlying Islands","Uganda","Ukraine","United Arab Emirates","United Kingdom", "United States of America","Uruguay","Uzbekistan","Vanuatu","Vatican City","Venezuela","Vietnam","Virgin Islands", "Wallis and Futuna Islands","Western Sahara","Yemen","Yugoslavia (Former)","Zaire","Zambia","Zimbabwe"}; %> <% exist_btn = (request.getParameter("submit")==null)?null:request.getParameter("submit"); email_txt = (request.getParameter("email")==null)?null:request.getParameter("email"); //out.println("submit :"+exist_btn); // out.println("email :"+email_txt); %>
Enter E-mail :
<% try{ exist=false; if(exist_btn!=null && exist_btn.equals("Submit")) { flag1=true; Class.forName("org.gjt.mm.mysql.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost/worlddb", "world", "worlduser"); stat=con.createStatement(); rs=stat.executeQuery("SELECT contactname,category,title,url,location,contactemail,bill_first,bill_last,bill_street1, bill_street2, bill_city,bill_state,bill_country,date,time,amount,list_id,companyname,designation,phoneno,description,entity_name,alias1,alias2,alias3,alias4,bill_zip FROM url_submit WHERE contactemail='"+email_txt+"' ORDER BY s_no DESC"); flag=0; while(rs.next()) { if(rs.getString("contactemail").equals(email_txt)) { exist=true; break; } } if(exist) { %>
Site Details Contact Information
             
Site Title:  size=30>   Contact Name:  size=30 >
Category :        Contact Email:  size=30 >
Verify that the email address above is correct.
URL:  >       Company Name:  size=30 >
Designation:  size=30 >
Entity Name* :  size="30" maxlength="100" >
Description: 
A brief phrase or sentence describing the contents of the site
· Maximum 150 characters
· Avoid repeating the site title or category name
· Do not capitalize the first letter of every word or use HTML tags

      Common Aliases* :   1.  >
  (Optional)   2.  >
     3.  >
 

*Entity Name :
General Motors
*Common Aliases :
  1. General Motors
  2. GM
  3. G M
 4.  >
*Entity Name :
United States of America
*Common Aliases :
  1. US
  2. USA
  3. US of A
  4. United States
Currency Type:     
Geographic  
Location:
 
size=30 >
The city/state and country, if relevant to placement of your site.
  Address
  First Name:  size=30 >
  Last Name:  size=30 >
     
      Phone No:  size=15 >
    Street:  size=30 >
    size=30 >
    City:   size=25>
    State: 
    Postal Code:  size=10 >
    Country: 
           
         

<% } } if(!exist) {%>
Site Details Contact Information
             
Site Title:      Contact Name: 
Category :        Contact Email: 
Verify that the email address above is correct.
URL:        Company Name: 
Designation: 
Entity Name* : 
Description: 
A brief phrase or sentence describing the contents of your site
· The phrase should not exceed 150 characters
· Avoid repeating the site title or category name
· Do not capitalize the first letter of every word or use HTML tags

      Common Aliases* :   1. 
  (Optional)   2. 
     3. 
 

*Entity Name :
General Motors
*Common Aliases :
  1. General Motors
  2. GM
  3. G M
 4. 
*Entity Name :
United States of America
*Common Aliases :
  1. US
  2. USA
  3. US of A
  4. United States
Currency Type:     
Location: 
The city/state and country, if relevant to placement of your site.
  Address
  First Name: 
  Last Name: 
     
      Phone No: 
    Street: 
   
    City:  
    State: 
    Postal Code: 
    Country: 
           
         

<% } } catch(Exception eee){ error="Error:"+eee.getMessage(); } finally{ if(flag1) { rs.close(); stat.close(); con.close(); } } if(error!=null && !(error.equals("null")) && !(error.equals("")) ) out.print(error); %>