% //developed by Ved Prakash Sharma 8/2/2005 %> <%@ page language="java" import="java.sql.*" errorPage="" %>
| 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. 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); %> <% 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) { %> <% } } if(!exist) {%> | |