时间戳

首页 > 解决方案 > 如果记录不存在，php 不返回消息：“记录不存在”

php - 如果记录不存在，php 不返回消息：“记录不存在”

问题描述

我制作了一个表格，如果 id "Telefoni_number" 存在，它将更新表 "Komentaar"。但即使我输入不存在的 id，我仍然会得到回显“记录成功更新”。

<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "root", "", "client.id");

// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}

// Attempt update query execution
$sql = "UPDATE clientid SET Komentaar='OK' WHERE          
    Tele foni_number=5207245";

if(mysqli_query($link, $sql)){
    echo "Records were updated successfully.";
} else  {
    echo "ERROR: Could not able to execute $sql. " .             mysqli_error($link);
}

// Close connection
mysqli_close($link);
?>

标签： phpmysql

解决方案

Records were updated successfully如果执行查询，您正在打印。当然，查询已执行，不管它是否有任何改变。您必须if any rows were affected使用mysqli_affected_rows().

$sql = "UPDATE clientid SET Komentaar='OK' WHERE Telefoni_number=5207245";
$result = mysqli_query($link, $sql);
if(if (mysqli_affected_rows($link)){
    echo "Records were updated successfully.";
} else  {
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}

推荐阅读