<?php
header("content-type:text/xml; charset=utf-8");
include_once("mysql.php");
$xh=$_POST['xh'];
$xm=$_POST['xm'];
$xb=$_POST['xb'];
$mz=$_POST['mz'];
$csrq=$_POST['csrq'];
$query="INSERT INTO student(`学号`, `姓名`, `性别`, `民族`, `出生日期`) VALUES('$xh', '$xm', '$xb', '$mz', '$csrq')";
if(mysql_query($query))
echo "<data><lst value='yes'></lst></data>";
else
echo "<data><lst value='no'></lst></data>";
?>
--------------------------------------------------------------------------------------------------------------
<?php
include("mysql.php");
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>添加学生信息</title>
<style type="text/css">
<!--
#apDiv1 {
position:relative;
left:0px;
top:0px;
width:980px;
height:554px;
z-index:1;
overflow: visible;
}
#apDiv2 {
position:absolute;
left:20px;
top:18px;
width:957px;
height:113px;
z-index:2;
}
-->
</style>
<script type="text/javascript" src="ajax.js"></script>
<script type="text/javascript">
var delObj=null;
function add()
{//
delObj=GetAjax(do_modi);
delObj.open("POST","adomodi.php",true);
delObj.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
var param="xh="+document.getElementById("xh").value+"&xm="+document.getElementById("xm").value+"&xb="+document.getElementById("xb").options[document.getElementById("xb").selectedIndex].value+"&mz="+document.getElementById("mz").value+"&csrq="+document.getElementById("csrq").value;
//alert(param);
delObj.send(param);
}
function do_modi()
{
if(delObj.readyState==4 && delObj.status==200)
{
var myLst=delObj.responseXML.getElementsByTagName("lst");
var result=myLst[0].getAttribute("value");
if(result=="yes")
{
alert("学生信息添加成功!");
}
else
{
alert("学生信息不能被添加!");
}
}
}
</script>
</head><body>
<table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div id="apDiv1">
<div id="apDiv2">
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="16%">学号:</td>
<td width="34%"><input type="text" name="xh" id="xh" value="<?php echo $xh; ?>" ></td>
<td width="14%">姓名:</td>
<td width="36%"><input type="text" id="xm" name="xm" value="<?php echo $xm; ?>"></td>
</tr>
<tr>
<td>性别:</td>
<td><select name="xb" id="xb">
<option value="男" <?php if($xb=="男") echo "selected"; ?>>男</option>
<option value="女" <?php if($xb=="女") echo "selected"; ?>>女</option>
</select></td>
<td>民族:</td>
<td><input type="text" id="mz" name="mz" value="<?php echo $mz; ?>"></td>
</tr>
<tr>
<td>出生日期:</td>
<td><input type="text" id="csrq" name="csrq" value="<?php echo $csrq; ?>"></td>
<td colspan="2"><input type="button" name="queding" id="queding" value="确定" onClick="add()"> <input type="button" name="fanhui" id="fanhui" value="返回" onClick="javascript:location.href='index.php';"></td>
</tr>
</table>
</div>
</div></td>
</tr>
</table>
</body>
</html>第一段代码是adomodi.php高手帮菜鸟解决哈为什么添加新内容总是失败
header("content-type:text/xml; charset=utf-8");
include_once("mysql.php");
$xh=$_POST['xh'];
$xm=$_POST['xm'];
$xb=$_POST['xb'];
$mz=$_POST['mz'];
$csrq=$_POST['csrq'];
$query="INSERT INTO student(`学号`, `姓名`, `性别`, `民族`, `出生日期`) VALUES('$xh', '$xm', '$xb', '$mz', '$csrq')";
if(mysql_query($query))
echo "<data><lst value='yes'></lst></data>";
else
echo "<data><lst value='no'></lst></data>";
?>
--------------------------------------------------------------------------------------------------------------
<?php
include("mysql.php");
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>添加学生信息</title>
<style type="text/css">
<!--
#apDiv1 {
position:relative;
left:0px;
top:0px;
width:980px;
height:554px;
z-index:1;
overflow: visible;
}
#apDiv2 {
position:absolute;
left:20px;
top:18px;
width:957px;
height:113px;
z-index:2;
}
-->
</style>
<script type="text/javascript" src="ajax.js"></script>
<script type="text/javascript">
var delObj=null;
function add()
{//
delObj=GetAjax(do_modi);
delObj.open("POST","adomodi.php",true);
delObj.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
var param="xh="+document.getElementById("xh").value+"&xm="+document.getElementById("xm").value+"&xb="+document.getElementById("xb").options[document.getElementById("xb").selectedIndex].value+"&mz="+document.getElementById("mz").value+"&csrq="+document.getElementById("csrq").value;
//alert(param);
delObj.send(param);
}
function do_modi()
{
if(delObj.readyState==4 && delObj.status==200)
{
var myLst=delObj.responseXML.getElementsByTagName("lst");
var result=myLst[0].getAttribute("value");
if(result=="yes")
{
alert("学生信息添加成功!");
}
else
{
alert("学生信息不能被添加!");
}
}
}
</script>
</head><body>
<table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div id="apDiv1">
<div id="apDiv2">
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="16%">学号:</td>
<td width="34%"><input type="text" name="xh" id="xh" value="<?php echo $xh; ?>" ></td>
<td width="14%">姓名:</td>
<td width="36%"><input type="text" id="xm" name="xm" value="<?php echo $xm; ?>"></td>
</tr>
<tr>
<td>性别:</td>
<td><select name="xb" id="xb">
<option value="男" <?php if($xb=="男") echo "selected"; ?>>男</option>
<option value="女" <?php if($xb=="女") echo "selected"; ?>>女</option>
</select></td>
<td>民族:</td>
<td><input type="text" id="mz" name="mz" value="<?php echo $mz; ?>"></td>
</tr>
<tr>
<td>出生日期:</td>
<td><input type="text" id="csrq" name="csrq" value="<?php echo $csrq; ?>"></td>
<td colspan="2"><input type="button" name="queding" id="queding" value="确定" onClick="add()"> <input type="button" name="fanhui" id="fanhui" value="返回" onClick="javascript:location.href='index.php';"></td>
</tr>
</table>
</div>
</div></td>
</tr>
</table>
</body>
</html>第一段代码是adomodi.php高手帮菜鸟解决哈为什么添加新内容总是失败
第一:少了<form id="form" name="form" method="post" action="adomodi.php">.....</form>
第二:少了提交按钮<input type="submit" name="queding" id="queding" value="确定" onClick="add()">相对正确的html代码(保证你的mysql.php页没有问题的话,应该可以插入成功的)应该是:
<?php
include("mysql.php");
?><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>添加学生信息</title>
<style type="text/css">
<!--
#apDiv1 {
position:relative;
left:0px;
top:0px;
width:980px;
height:554px;
z-index:1;
overflow: visible;
}
#apDiv2 {
position:absolute;
left:20px;
top:18px;
width:957px;
height:113px;
z-index:2;
}
-->
</style>
<script type="text/javascript" src="ajax.js"></script>
<script type="text/javascript">
var delObj=null;
function add()
{//
delObj=GetAjax(do_modi);
delObj.open("POST","adomodi.php",true);
delObj.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
var param="xh="+document.getElementById("xh").value+"&xm="+document.getElementById("xm").value+"&xb="+document.getElementById("xb").options[document.getElementById("xb").selectedIndex].value+"&mz="+document.getElementById("mz").value+"&csrq="+document.getElementById("csrq").value;
//alert(param);
delObj.send(param);
}
function do_modi()
{
if(delObj.readyState==4 && delObj.status==200)
{
var myLst=delObj.responseXML.getElementsByTagName("lst");
var result=myLst[0].getAttribute("value");
if(result=="yes")
{
alert("学生信息添加成功!");
}
else
{
alert("学生信息不能被添加!");
}
}
}
</script>
</head><body>
<form id="form" name="form" method="post" action="adomodi.php">
<table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div id="apDiv1">
<div id="apDiv2">
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="16%">学号:</td>
<td width="34%"><input type="text" name="xh" id="xh" value="<?php echo $xh; ?>" ></td>
<td width="14%">姓名:</td>
<td width="36%"><input type="text" id="xm" name="xm" value="<?php echo $xm; ?>"></td>
</tr>
<tr>
<td>性别:</td>
<td><select name="xb" id="xb">
<option value="男" <?php if($xb=="男") echo "selected"; ?>>男</option>
<option value="女" <?php if($xb=="女") echo "selected"; ?>>女</option>
</select></td>
<td>民族:</td>
<td><input type="text" id="mz" name="mz" value="<?php echo $mz; ?>"></td>
</tr>
<tr>
<td>出生日期:</td>
<td><input type="text" id="csrq" name="csrq" value="<?php echo $csrq; ?>"></td>
<td colspan="2"><input type="submit" name="queding" id="queding" value="确定" onClick="add()"> <input type="button" name="fanhui" id="fanhui" value="返回" onClick="javascript:location.href='index.php';"></td>
</tr>
</table>
</div>
</div></td>
</tr>
</table>
</form>
</body>
</html>
这样需要环境帮你测试了!
你还是先按我的那个试一下能不能插入,如果可以插入成功的话
你再来测试ajax的代码吧!
{
if(delObj.readyState==4 && delObj.status==200)
{
var xml = delObj.responseXML;
if(xml.xml == '') {
alert(xmlhttp.responseText);
return;
}
var myLst = xml.getElementsByTagName("lst");
var result=myLst[0].getAttribute("value");要改写成这样,只在返回了正确的 xml 文档时才做后续工作。否则返回
你可以根据 alert(xmlhttp.responseText) 给出的信息调整你的程序,无需借助其他调试工具
请将 xmlhttp 改为 delObj