如何使用PATCH更新简单的数据库字段? [英] How to use PATCH for updating a simple database field?

问题描述

我是php和API的新手，我正在尝试学习方法.但是我无法执行PATCH或PUT来更新我的简单mysql数据库.我使用了以下代码.

I am new to php and API and I am trying to learn the methods. But I am not able to perform PATCH or PUT to update my simple mysql database. I used the following code.

if(isset($_PATCH)){     
    $con = mysqli_connect("localhost", "root", "root","wordpress");
    $sql = "UPDATE trainsample SET Location = ('$_PATCH[Location]'), Data = ('$_PATCH[Data]') WHERE Name = ('$_PATCH[Name]')";
    mysqli_query($con,$sql);
    echo "Data Updated<br>";
}
else
{
    echo "Data Not found ";
}

我将邮递员用作REST客户端，并尝试发送数据以更新字段.任何帮助表示赞赏.预先谢谢你.

I am using postman as REST client and try to sent data to update the fields. Any help is appreciated. Thank you in advance.

推荐答案

我发现了使用POST的解决方法.我是初学者，如果有更好的方法，请回复.

I found a workaround using POST. I am a beginner, if there is a better way please respond.

<?php
if(isset($_POST)){  

    $con = mysqli_connect("localhost", "root", "root","wordpress");
    $sql = "UPDATE `trainsample` SET `Location`='".$_POST['Location']."', 
            `Data`='".$_POST['Data']."' WHERE `Name`='".$_POST['Name']."'";
    if (mysqli_query($con, $sql)) {
        echo "Record updated successfully";
    } 
    else {
        echo "Error updating record: " . mysqli_error($con);
    }

    mysqli_close($con);
}
else
{
    echo "Data Not found ";
}
?>

这篇关于如何使用PATCH更新简单的数据库字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！