我使用下面的代码从表中删除一个条目,我想做的是检查是否从表中删除了任何值。如果删除了一个值,脚本应该打印成功,否则为 false。这是我所实现的,直到现在请帮忙
<?PHP
$mysqli = new mysqli("SQLHOST.COM","CLIENT","PASSWORD", "DNAME", 1234);
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}
else
{
printf("cONN Sucees");
if ($result = $mysqli->query("DELETE FROM ktable WHERE code='value'")) {
printf("Select returned %d rows.\n", $result->num_rows);
printf($result->num_rows);
$result->close();
}
}
?>
您删除的内容需要返回的是affected_rows
http://www.php.net/manual/en/mysqli.affected-rows.php
您需要更换什么
if ($result = $mysqli->query("DELETE FROM ktable WHERE code='value'")) {
printf("Select returned %d rows.\n", $result->num_rows);
printf($result->num_rows);
$result->close();
}
工作代码
$value = ""; // Set To any Value
$mysqli = new mysqli ( "SQLHOST.COM", "CLIENT", "PASSWORD", "DNAME", 1234 );
if ($mysqli->connect_errno) {
printf ( "Connect failed: %s\n", $mysqli->connect_error );
exit ();
} else {
printf ( "cONN Sucees" );
if ($mysqli->query (sprintf ( "DELETE FROM ktable WHERE code='%s'", mysqli_real_escape_string ( $mysqli, $value ) ) )) {
printf ( "Affected Rows %d rows.\n", $mysqli->affected_rows );
}
}
你应该有一个有效的输出
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)