php - 数据是否更新，显示抱歉未插入。请检查一下。谢谢

Question

数据是否更新，显示抱歉未插入。请检查一下。谢谢您

<?php
if(isset($_POST['submit'])){

    include 'connection.php';
    $id = $_POST["id"];
    $company = $_POST["company"];
    $model =  $_POST["model"];
    $price = $_POST["price"];
    $engno = $_POST["engno"];
    $query =  "UPDATE products SET company='".$company."', model='".$model."',`price`='".$price."', `engno`=$engno WHERE `id`=$id";
    $result=mysqli_query($conn,$query);
    if($conn->query($result)===TRUE){
        echo  'Data Updated Successfully';
    }
    else{
        echo 'Sorry Not Updated';
    }
    mysqli_close($conn);

}
?>

Answer 1

检查成功状态如下，mysqli_query将返回true，您正在尝试再次运行查询$conn->query($result) 其中 $result 具有 TRUE 或 FALSE。

if($result){
    echo  'Data Updated Successfully';
}

对于mysqli_query

Return Value: For successful SELECT, SHOW, DESCRIBE, or EXPLAIN queries it will return a mysqli_result object. For other successful queries it will return TRUE. FALSE on failure

来自w3school