soil-report-ai/dashboard/client-settings/updateproduct.php

<?php
	error_reporting(E_ALL);
	ini_set('display_errors', 1);
	
    //Database connection
    //$con = mysqli_connect("localhost", "root", "R3M0T31", "cropmonitor");
    $con = mysqli_connect("localhost", "cropmonitor", "brvnCcaEYxlPCS3", "cropmonitor");
    
    // Check connection
    if (mysqli_connect_errno()) {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
	
	$column =  mysqli_real_escape_string($con, $_POST["column"]);
	$id =  mysqli_real_escape_string($con, $_POST["id"]);
	$editval =  mysqli_real_escape_string($con, $_POST["editval"]);
	
	$result = mysqli_query($con, "INSERT INTO fertiliser_specifications(id, $column) VALUES ('$id', '$editval') ON DUPLICATE KEY UPDATE $column = '$editval'" );

	if(mysqli_query($con, $result))
	{
		echo $result;
	}
	?>