加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

ajax php 实现写入数据库

发布时间:2020-12-15 23:34:34 所属栏目:百科 来源:网络整理
导读:首先需要一个带输入表格. div class="codetitle" a style="CURSOR: pointer" data="75935" class="copybut" id="copybut75935" onclick="doCopy('code75935')" 代码如下: div class="codebody" id="code75935" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01

首先需要一个带输入表格.
<div class="codetitle"><a style="CURSOR: pointer" data="75935" class="copybut" id="copybut75935" onclick="doCopy('code75935')"> 代码如下:<div class="codebody" id="code75935">

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">



<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<script src="submit.js" language="javascript">


Insert 知识点
<form name="insertForm">
<label for="question">知识点
<input name="question" type="text"/>



<label for="answer"> 答案
<input name="answer" type="text"/>




<input name="confirm" value="添加" type="button" onclick="getValue();">




需要js来处理提交数据到服务器上以及从服务器获取提交后的返回数据. submit.js代码如:
<div class="codetitle"><a style="CURSOR: pointer" data="67649" class="copybut" id="copybut67649" onclick="doCopy('code67649')"> 代码如下:<div class="codebody" id="code67649">
/
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处理界面,负责跟服务器交换数据
<div class="codetitle"><a style="CURSOR: pointer" data="45622" class="copybut" id="copybut45622" onclick="doCopy('code45622')"> 代码如下:<div class="codebody" id="code45622">
<?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 "输入成功";
?>

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读