// JavaScript Document
function zscheck()
{
     if(document.getElementById("name").value=="")
       {
          alert("请输入您企业的名称！");
		   document.xmzs.name.focus();
          return false;
        }
		 if(document.getElementById("pp").value=="")
       {
          alert("请输入您企业的品牌名称！");
		  document.xmzs.pp.focus();
          return false;
        }
		 if(document.getElementById("zs").value=="")
       {
          alert("请输入您企业的相关证书！");
		  document.xmzs.zs.focus();
          return false;
        } 
		if(document.getElementById("lxl").value=="")
       {
          alert("请输入联系人！");
		  document.xmzs.lxl.focus();
          return false;
        }
		
		if(document.getElementById("tel").value=="")
       {
          alert("请输入联系电话！");
		  document.xmzs.tel.focus();
          return false;
        }
		else
		{
			if(document.getElementById("tel").value.length < 8 || document.getElementById("tel").value.length>=14)
				{
				   alert("错误的电话号码，请重新填写您的电话！");
				   document.xmzs.tel.focus();
				   return false;
				}
				else
			   {
				   var phone= document.getElementById("tel").value;
				   var patrn=/^[+]{0,1}(\d){1,3}[ ]?([-]?((\d)|[ ]){1,12})+$/; 
				   if (!patrn.exec(phone)) //检查电话号码是否有效
				   {
					alert("您输入的电话有误！");
					document.xmzs.tel.focus();
					 return false;
				   }
			   }
		}
		if(document.getElementById("add").value=="")
       {
          alert("请输入企业地址！");
		  document.xmzs.add.focus();
          return false;
        }
		if(document.getElementById("bz").value=="")
       {
          alert("请输入企业备注信息！");
		  document.xmzs.bz.focus();
          return false;
        }
		if(document.getElementById("bz").value.length>300)
       {
          alert("请精简企业备注信息！");
		  document.xmzs.bz.focus();
          return false;
        }
		if(document.getElementById("verifycode").value=="")
            {
                alert("验证码不允许为空！");
				document.xmzs.verifycode.focus();
                return false;
            }
		
		
}
function checkfilterSqlName()
    {
        var checkValue = document.getElementById("bz").value; 
        var arr = new Array("action","add" ,"aggregate","all", "alter" ,"after" ,"and", "as","asc" ,"avg", "avg_row_length" ,"auto_increment" ,"between", "bigint", "bit", "binary" ,"blob" ,
        +"bool", "both", "by" ,"cascade" ,"case" ,"char", "character",
        +"change", "check" ,"checksum" ,"column" ,
        +"columns" ,"comment", "constraint" ,"create" ,
        +"cross"," current_date"," current_time","current_timestamp",
        +"data ","database ","databases"," date ",
        +"datetime"," day"," day_hour"," day_minute" ,
        +"day_second"," dayofmonth"," dayofweek","dayofyear" 
        +"dec ","decimal"," default"," delayed ",
        +"delay_key_write"," delete ","desc"," describe" ,
        +"distinct ","distinctrow ","double"," drop ",
        +"end"," else"," escape escaped ",
        +"enclosed ","enum ","explain exists" ,
        +"fields"," file"," first"," float ",
        +"float4 ","float8"," flush"," foreign" ,
        +"from"," for"," full ","function ",
        +"global"," grant"," grants ","group ",
        +"having ","heap high_priority"," hour ",
        +"hour_minute","hour_second hosts ","identified" ,
        +"ignore"," in"," index"," infile ",
        +"inner ","insert"," insert_id"," int ",
        +"integer ","interval"," int1 ","int2" ,
        +"int3 ","int4"," int8"," into ",
        +"if ","is ","isam","join",
        +"key"," keys ","kill"," last_insert_id ", 
        +"leading"," left ","length ","like" ,
        +"lines"," limit"," load local ",
        +"lock ","logs ","long ","longblob ",
        +"longtext"," low_priority"," max max_rows ",
        +"match"," mediumblob"," mediumtext"," mediumint ",
        +"middleint ","min_rows"," minute"," minute_second ",
        +"modify"," month ","monthname"," myisam" ,
        +"natural"," numeric"," no"," not ",
        +"null"," on ","optimize","option",
        +"optionally ","or ","order"," outer ",
        +"outfile ","pack_keys ","partial password ",
        +"precision ","primary ","procedure process" ,
        +"processlist"," privileges"," read real ",
        +"references"," reload"," regexp"," rename ",
        +"replace"," restrict"," returns"," revoke" ,
        +"rlike"," row"," rows ","second ",
        +"select"," set"," show"," shutdown ",
        +"smallint"," soname"," sql_big_tables sql_big_selects ",
        +"sql_low_priority_updates"," sql_log_off sql_log_update"," sql_select_limit" ,
        +"sql_small_result"," sql_big_result sql_warnings ","straight_join ",
        +"starting ","status"," string"," table ",
        +"tables ","temporary"," terminated ","text" ,
        +"then ","time"," timestamp ","tinyblob ",
        +"tinytext"," tinyint"," trailing"," to" ,
        +"type"," use using"," unique ",
        +"unlock"," unsigned ","update"," usage ",
        +"values"," varchar vvariables"," varying" ,
        +"varbinary ","with ","write"," when ",
        +"where"," year"," year_month ","zerofill");
        for(var i =0 ; i< arr.length; i++)
        {
                if(arr[i].toString() == checkValue.toLowerCase())
                {
                   alert("请不要输入非法字符!");
                }
        }

    }