我正在嘗試檢查數(shù)據(jù)庫(kù)中是否已存在名稱(chēng)。但是我的Ajax沒(méi)有返回值，老實(shí)說(shuō)，甚至不確定Ajax是否正在運(yùn)行。這是我在php頁(yè)面上的代碼。<input class="form-control" id="name" name="name" onblur="checkNameStatus()" /><script> function checkNameStatus(){ //alert('Start of funtion'); var name=$("#name").val(); //alert("Name Input value is: "+name); $.ajax({ type:'post', url:'<?php echo base_url() ?>assets/ajax/checkName.php?name='+name, success:function(msg){ alert(msg); } }); //alert("End of function"); }</script>使用警報(bào)，我可以判斷該函數(shù)確實(shí)正在運(yùn)行并接收名稱(chēng)輸入的值。然后是我的阿賈克斯<?php$hostname = 'localhost';$username = 'root';$password = '123';$dbname = 'test_db';function clean($string) { return preg_replace('/[^A-Za-z0-9\- .!@#$%&]/', '', $string);}$name= clean($_GET['name']);$msg = "";$conn=mysqli_connect($hostname,$username,$password,$dbname);if (mysqli_connect_errno()){ echo ("Failed to connect to MySQL: " . mysqli_connect_error());}$sql = "SELECT * FROM pattern where name = '$name';";$check=mysqli_query($conn, $sql);$count=mysqli_num_rows($check);if($count!=0) { $msg = "A Schedule Pattern with the Name of $name already exists. If you continue to use this Name it will overwrite $name's current Data."; return $msg; } else { $msg = "Count check Failed"; echo $msg; }mysqli_close($con); ?>如何從我的ajax接收$msg變量并將其返回到腳本，然后隨后在警報(bào)中顯示它？
1 回答
函數(shù)式編程
TA貢獻(xiàn)1807條經(jīng)驗(yàn) 獲得超9個(gè)贊
我認(rèn)為你必須改變這一點(diǎn)
$check=mysql_query($sql);
$count=mysql_num_rows($check);
對(duì)此
$check=mysqli_query($conn, $sql);
$count=mysqli_num_rows($check);
您正在同時(shí)使用mysql_和mysqli_這是錯(cuò)誤的，這可能是它未能檢查計(jì)數(shù)的原因，我還建議您在找不到名稱(chēng)的情況下發(fā)送錯(cuò)誤消息。
編輯，完整代碼應(yīng)為：（菲律賓比索）：
<?php
$hostname = 'localhost';
$username = 'root';
$password = '123';
$dbname = 'test_db';
function clean($string) {
return preg_replace('/[^A-Za-z0-9\- .!@#$%&]/', '', $string);
}
if(isset($_GET['name'])){
$name= clean($_GET['name']);
$msg = "";
$conn=mysqli_connect($hostname,$username,$password,$dbname);
if (mysqli_connect_errno()){
echo ("Failed to connect to MySQL: " . mysqli_connect_error());
}
$sql = "SELECT * FROM pattern where `name` = '$name';";
$check=mysqli_query($conn, $sql);
$count=mysqli_num_rows($check);
if($count!=0)
{
$msg = "A Schedule Pattern with the Name of $name already exists. If you continue to use this Name it will overwrite $name's current Data.";
echo $msg;
} else {
$msg = "Count check Failed";
echo $msg;
}
mysqli_close($conn);
}
?>
- 1 回答
- 0 關(guān)注
- 118 瀏覽
添加回答
舉報(bào)
0/150
提交
取消