js ajax提交留言评论工作笔记

var xmlHttp

function checkgoobkform()
{
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null)
{
  alert ("Browser does not support HTTP Request")
  return false;
} else{
 var name = document.getElementById("name").value;
 if(name=='') {
    alert("请输入您的姓名! ");
    document.getElementById("name").focus();
    return false;
  }
 
 var email = document.getElementById("email").value;
 if(email=='')
 {
  alert("请输入电子邮件!");
  document.getElementById("email").focus();
  return false; 
 }else if((email.indexOf("@")==-1)||(email.indexOf(".")==-1))
 {
  alert("电子邮件格式不正确!");
  document.getElementById("email").focus();
  return false; 
 }
 
 var content = document.getElementById("content").value;
 if(content=='') {
   document.getElementById("content").focus();
    alert("请填写您的留言! ");
    return false;
  }
}

var url="/functionsubmit.php"
url=url+"?name="+name
url=url+"&email="+email
url=url+"&content="+content
url=url+"&action=addgbook"
url=url+"&sid="+Math.random()
xmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}

function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 {
  var restext=xmlHttp.responseText;
  if(restext=="ok"){
   alert("提交成功，感谢您的留言！");
   document.getElementById("name").value="";
   document.getElementById("email").value="";
   document.getElementById("content").value="";
  }
  else
  {
   alert('提交失败!'+restext);
  }
 }
}

$sname =isset($_GET['name'])?addslashes(iconv('gbk','utf-8',$_GET['name'])):0;
$email =isset($_GET['email'])?addslashes($_GET['email']):0;
$content =isset($_GET['content'])?addslashes(iconv('gbk','utf-8',$_GET['content'])):0;

include("data/common.inc.php");
mysql_connect('localhost',$cfg_dbuser,$cfg_dbpwd) or die('database connect failer');
mysql_select_db($cfg_dbname);
mysql_query("set Names '$cfg_db_language'");
$sql ="insert into ".$cfg_dbprefix.'guestbook'."(title,email,msg)values('$sname','$email','$content')";
$query = mysql_query( $sql ) or die($sql);
if( $query )
{
 echo 'ok';
 
}
else
{
 echo '参数错误或记录己被删除！';
}

?>

--
-- 表的结构 `xjz_guestbook`
--

CREATE TABLE IF NOT EXISTS `xjz_guestbook` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(60) NOT NULL DEFAULT '',
  `tid` mediumint(8) NOT NULL DEFAULT '0',
  `mid` mediumint(8) unsigned DEFAULT '0',
  `posttime` int(10) unsigned NOT NULL DEFAULT '0',
  `uname` varchar(30) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `homepage` varchar(50) NOT NULL DEFAULT '',
  `qq` varchar(15) NOT NULL DEFAULT '',
  `face` varchar(10) NOT NULL DEFAULT '',
  `ip` varchar(20) NOT NULL DEFAULT '',
  `dtime` int(10) unsigned NOT NULL DEFAULT '0',
  `ischeck` smallint(6) NOT NULL DEFAULT '1',
  `msg` text,
  PRIMARY KEY (`id`),
  KEY `ischeck` (`ischeck`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;