21,886
社区成员
发帖
与我相关
我的任务
分享
add.php
<script type="text/javascript">
var xmlHttp=false;
try {
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
} catch (e2) {
xmlHttp=false;
}
}
if (!xmlHttp && typeof XMLHttpRequest != 'undefined') {
xmlHttp=new XMLHttpRequest();
}
function CallServer()
{
var id=document.getElementById("id").value;
var bookname=document.getElementById("bookname").value;
var issuDate=document.getElementById("issuDate").value;
var price=document.getElementById("price").value;
var synopsis=document.getElementById("synopsis").value;
var Maker=document.getElementById("Maker").value;
var publisher=document.getElementById("publisher").value;
if (id!=""&bookname!=""&issuDate!=""&price!=""&synopsis!=""&Maker!=""&publisher!="")
{
var url ="save.php?id="+encodeURI(id); //,UTF-8下要用encodeURI
xmlHttp.open("POST",url,true);
xmlHttp.onreadystatechange=UpdateData;
xmlHttp.send(null);
}else
{
alert("please write all!");
}
}
function UpdateData()
{
if(xmlHttp.readyState<4)
{
span.innerHTML="loading...";
}
if(xmlHttp.readyState==4)
{
span.innerHTML=xmlHttp.responseText;
}
}
</script>
<form action="" method="POST">
id:<input type="text" name="id"><br>
bookname:<input type="text" name="bookname"><br>
issuDate:<input type="text" name="issuDate"><br>
price:<input type="text" name="price"><br>
synopsis:<input type="text" name="synopsis"><br>
Maker:<input type="text" name="Maker"><br>
publisher:<input type="text" name="publisher"><br>
<input type="button" name="submit" value="submit" onclick="CallServer()">
<form>
save.php
<?php
$host="localhost";
$user="root";
$pass="root";
$db="db1";
$id=empty($_POST['id'])? die ("id is nulll"):
mysql_escape_string($_POST['id']);
$bookname=empty($_POST['bookname'])? die ("bookname is nulll"):
mysql_escape_string($_POST['bookname']);
$issuDate=empty($_POST['issuDate'])? die ("issuDate is nulll"):
mysql_escape_string($_POST['issuDate']);
$price=empty($_POST['price'])? die ("price is nulll"):
mysql_escape_string($_POST['price']);
$synopsis=empty($_POST['synopsis'])? die ("synopsis is nulll"):
mysql_escape_string($_POST['synopsis']);
$Maker=empty($_POST['Maker'])? die ("Maker is nulll"):
mysql_escape_string($_POST['Maker']);
$publisher=empty($_POST['publisher'])? die ("publisher is nulll"):
mysql_escape_string($_POST['publisher']);
$connection=mysql_connect($host,$user,$pass) or die ("unable to connect");
mysql_select_db($db) or die ("unable to select database");
$query="insert into table1 (id,bookname,issuDate,price,synopsis,Maker,publisher)values('$id','$bookname','$issuDate','$price','$synopsis','$Maker','$publisher')";
$result=mysql_query($query) or die ("error in query:$query. ".mysql_error());
echo "success add ,mysql_insert_id()=".mysql_insert_id();
mysql_close($connection);
}
echo ("yes");
?>
按保存后没有反应,大家帮我看看有什么问题。
var id=encodeURIComponent(document.getElementById("id").value));
其他类推
STR="id="+id+"&bookname="+bookname+"&issuDate="+issuDate+"&price="+price+"&synopsis="+synopsis+"&Maker="+Maker+"&publisher="+publisher;
改成这样还是不行啊
var id=encodeURI(encodeURI(document.getElementById("id").value));
var bookname=encodeURI(encodeURI(document.getElementById("bookname").value));
var issuDate=encodeURI(encodeURI(document.getElementById("issuDate").value));
var price=encodeURI(encodeURI(document.getElementById("price").value));
var synopsis=encodeURI(encodeURI(document.getElementById("synopsis").value));
var Maker=encodeURI(encodeURI(document.getElementById("Maker").value));
var publisher=encodeURI(encodeURI(document.getElementById("publisher").value));
var STR="id="+id+"&bookname="+bookname+"&issuDate="+issuDate+"&price="+price+"&synopsis="+synopsis+"&Maker="+Maker+"&publisher="+publisher;
str = "id=" + "$_POST(id)";
str += "&bookname=$_POST(bookname)";
str += "&issuDate=$_POST(issuDate)";
str += "&price=$_POST(price)";
str += "&synopsis=$_POST(synopsis)";
str += "&Maker=$_POST(Maker)";
str += "&publisher=$_POST(publisher)";
function CallServer()
{
var id=document.getElementById("id").value;
if (id!="")
{
var url ="save.php"; //UTF-8下要用encodeURI
str = "id=" + "$_POST(id)";
str += "&bookname=$_POST(bookname)";
str += "&issuDate=$_POST(issuDate)";
str += "&price=$_POST(price)";
str += "&synopsis=$_POST(synopsis)";
str += "&Maker=$_POST(Maker)";
str += "&publisher=$_POST(publisher)";
xmlHttp.open("POST",url,true);
xmlHttp.onreadystatechange=UpdateData;
request.setRequestHeader("Content-Type","application/x-www-form-urlencoded");//post使用时的设定,必须加上。
request.send( str );
}else
{
alert("please write all!");
}
}
function UpdateData()
{
if(xmlHttp.readyState<4)
{
span.innerHTML="loading...";
}
if(xmlHttp.readyState==4)
{
span.innerHTML=xmlHttp.responseText;
}
if (request.readyState == 4)
{ // If the request is finished
if (request.status == 200) // If it was successful
alert(request.responseText);
document.getElementById("container").innerHTML = request.responseText; // Display the server's response
}
}