我有以下代码:
<form action="" method="POST">
<input id="delete" name="delete" placeholder="Name" type="text"></b>
<input type="submit" name="deleteButton" value="Go!">
</form>
<?php
if (isset($_POST['deleteButton'])) {
$temp = $_POST['delete'];
$deleteSQL = "DELETE FROM `berater` WHERE `Nachname` LIKE '$temp' OR `Vorname` LIKE '$temp' OR CONCAT(Vorname,' ', Nachname) LIKE '%$temp%'";
$searchSQL = "SELECT FROM `berater` WHERE `Nachname` LIKE '$temp' OR `Vorname` LIKE '$temp' OR CONCAT(Vorname,' ', Nachname) LIKE '%$temp%'";
$search = mysqli_query($db_link, $searchSQL);
$loeschen = mysqli_query($db_link, $deleteSQL);
if (!$search) {
echo "Kein Datensatz gefunden!";
} else {
echo "$temp erfolgreich gelöscht.";
}
}我是PHP新手,我认为如果在数据库中找不到名称,mysqli_query会返回false。我在这里做错了什么?
发布于 2017-06-04 12:58:42
尝试使用mysqli_num_rows
if (mysqli_num_rows($search)==0) {
echo "Kein Datensatz gefunden!";
} else {
echo "$temp erfolgreich gelöscht.";
}https://stackoverflow.com/questions/44350822
复制相似问题