我已经花费了数小时来排除故障,但不确定为什么这不起作用。我正在尝试使用Qt应用程序发送HTTP POST请求,并将此作为我的PHP脚本:
<?php
$con=mysqli_connect("*.mysql.eu2.*.com:3306","*****","****","****");
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
$price = filter_input(INPUT_POST, 'price', FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
$type = filter_input(INPUT_POST, 'type', FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
$stock= filter_input(INPUT_POST, 'stock', FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
$currentid = mysqli_insert_id();
if (trim($id) == '') {
exit('id cannot be empty!');
}
if (trim($price) == '') {
exit('price cannot be empty!');
}
if (trim($type) == '') {
exit('type cannot be empty!');
}
if (trim($stock ) == '') {
exit('stock cannot be empty!');
}
$result = "insert into ammo (ammoType,storeId,ammoStock,ammoPrice) VALUES ('".$type."','".$id."','".$stock."','".$price."');";
mysqli_query($result) or die("Could not insert data");
mysqli_close($con);
?>
我曾经遇到过这样一种情况,即虽然取得了成功,但实际上数值并没有出现在我的数据库中。
谢谢, -David
or die("Could not insert data");
对你来说并没有什么用处。 - Funk Forty Ninermysqli_query($result) or die("Could not insert data");
更改为mysqli_query($con,$result) or die(mysqli_error($con));
。 - Alive to die - Anant