ajax php 实现写入数据库
2018-09-07 19:02
首先需要一个带输入表格.
复制代码 代码如下:
<!--
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);
// 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-
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 输入成功;
?>