下面代码,按钮事件,写入一条数据记录,用浏览器调试,步进时,能顺利写入,正式使用时,无法写入,是什么原因?百思不得其解。
//ajax onclick代码
function set_chat_msg()
{
if(typeof XMLHttpRequest != "undefined")
{
oxmlHttpSend = new XMLHttpRequest();
}
else if (window.ActiveXObject)
{
oxmlHttpSend = new ActiveXObject("Microsoft.XMLHttp");
}
if(oxmlHttpSend == null)
{
alert("Browser does not support XML Http Request");
return;
}
var url = "chat_send_ajax.php";
var strname="noname";
var strmsg="";
if (document.getElementById("txtname") != null)
{
strname = document.getElementById("txtname").value;
document.getElementById("txtname").readOnly=true;
}
if (document.getElementById("txtmsg") != null)
{
strmsg = document.getElementById("txtmsg").value;
document.getElementById("txtmsg").value = "";
}
url += "?name=" + strname + "&msg=" + strmsg;
oxmlHttpSend.open("GET",url,true);
oxmlHttpSend.send(null);
}
//get php代码写入数据库
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "a0510151251";
// 创建连接
$conn = mysqli_connect($servername, $username, $password, $dbname);
// 检测连接
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
mysqli_set_charset($conn,'UTF8');
$msg = $_GET["msg"];
$dt = date("Y-m-d H:i:s");
$user = $_GET["name"];
$sql = "INSERT INTO chat (USERNAME,CHATDATE,MSG)
VALUES ('$user', '$dt', '$msg')";
$result = mysqli_query($conn, $sql);
if(!$result)
{
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
exit();
}
?>