ajax php 实现写入数据库

2015-01-24信息快讯网

首先需要一个带输入表格.

<!-- 
To change this template, choose Tools | Templates 
and open the template in the editor. 
--> 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 
<html> 
<head> 
<title></title> 
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 
<script src="submit.js" language="javascript"></script> 
</head> 
<body> 
Insert 知识点 
<form name="insertForm"> 
<label for="question"></label>知识点 
<input name="question" type="text"/> 
<br/><br/> 
<label for="answer"> 答案</label> 
<input name="answer" type="text"/> 
<br/> 
<br/> 
<input name="confirm" value="添加" type="button" onclick="getValue();"> 
</form> 
</body> 
</html>

需要js来处理提交数据到服务器上以及从服务器获取提交后的返回数据. submit.js代码如:

/* 
* To change this template, choose Tools | Templates 
* and open the template in the editor. 
*/ 
var xmlHttp; 
function getValue(){ 
alert("getvaluel"); 
var question =document.insertForm.question.value; 
// alert(question); 
var answer = document.insertForm.answer.value; 
// alert(answer); 
submit(question,answer); 
}; 
function submit(question,answer){ 
xmlHttp=GetXmlHttpObject(); 
if (xmlHttp==null) 
{ 
alert ("Your browser does not support AJAX!"); 
return; 
} 
xmlHttp.onreadystatechange =function(){ 
if(xmlHttp.readyState ==4){ 
alert(xmlHttp.responseText); 
} 
}; 
var url = "insert1.php"; 
xmlHttp.open("post",url,true); 
xmlHttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded; charset=utf-8"); 
xmlHttp.send("question="+question+"&answer="+answer); 

} 
function GetXmlHttpObject() 
{ 
var xmlHttp=null; 
try 
{ 
// Firefox, Opera 8.0+, Safari 
xmlHttp=new XMLHttpRequest(); 
} 
catch (e) 
{ 
// Internet Explorer 
try 
{ 
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); 
} 
catch (e) 
{ 
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP"); 
} 
} 
return xmlHttp; 
}

然后PHP处理界面,负责跟服务器交换数据

<?php 
/* 
* To change this template, choose Tools | Templates 
* and open the template in the editor. 
*/ 
//echo $_POST["question"]; 
//echo $_POST["answer"]; 
$q =$_POST['question']; 
$a = $_POST['answer']; 
//$q='qq'; 
//$a="a"; 
$con = mysql_connect("localhost","joe","123"); 
if (!$con) 
{ 
//die('Could not connect: ' . mysql_error()); 
echo 'Could not connect: ' . mysql_error(); 
} 
mysql_select_db("joe",$con); 
mysql_query("INSERT INTO message VALUES ('$q', '$a', '无')"); 
mysql_close($con); 
echo "输入成功"; 
?>

PHP学习之输出字符串(echo,print,printf,print_r和var_dump)

PHP的cURL库功能简介抓取网页、POST数据及其他