I need assistance with updating a MySQLi table called "achievements" using PHP in an AngularJS app. The app calculates various statistics, and when a goal is achieved, I send the relevant information to a PHP script using AngularJS's "$http.post" method. My intention is for PHP to handle this information and update the corresponding table accordingly. However, despite receiving a success message from the $http.post request, the table does not actually get updated. I have double-checked and am confident that the database connection information is accurate.
Below is my AngularJS code for the "$scope.updatePhp" function using "$http.post":
$scope.updatePhp = function(table, column, value, whereColumn, whereValue) {
$http.post(
"update-data.php", {
'table': table,
'column': column,
'value': value,
'whereColumn': whereColumn,
'whereValue': whereValue
}
);
}
Here is an alternative version of the "$scope.updatePhp" function without utilizing the ".post" shortcut:
$scope.updatePhp = function(table, column, value, whereColumn, whereValue) {
console.log("Updating. Table: " + table + ", Column: " + column + ", Value: " + value + ", Where: " + whereColumn + ", WhereValue: " + whereValue);
$http({
method: 'POST',
url: 'update-data.php',
data: { table: table.toString(), column: column.toString(), value: value.toString(), whereColumn: whereColumn.toString(), whereValue: whereValue.toString() },
headers: { 'Content-Type' : 'application/x-www-form-urlencoded; charset=UTF-8' }
}).then(function successCallback(response) {
console.log("Success.");
}, function errorCallback(response) {
console.log("Error.");
});
}
Here is the content of my PHP file named "update-data.php":
<?php
// Adding CORS header
header("Access-Control-Allow-Origin: *");
// Retrieve posted information in PHP
$info = file_get_contents('php://input');
// Connect to database and update the table
$hostname_DB = "databaseHost";
$database_DB = "databaseName";
$username_DB = "databaseUser";
$password_DB = "databasePass";
$portnum_DB = "databasePort";
$mysqli = mysqli_connect($hostname_DB, $username_DB, $password_DB, $database_DB, $portnum_DB ) or die(mysqli_error());
$table = $info->table;
$column = $info->column;
$value = $info->value;
$whereColumn = $info->whereColumn;
$whereValue = $info->whereValue;
$query = "UPDATE '$table' SET '$column' = '$value' WHERE '$whereColumn' = '$whereValue' ";
$mysqli->query($query) or die(mysqli_error());
?>
I am encountering an error when attempting to access the variables "table", "column", "value", etc. within the PHP script. Specifically, I receive the following notice for each variable: "PHP Notice: Trying to get property 'table' of non-object in /update-data.php on line 16". It appears that there may be an issue with how the information is being sent or retrieved, rather than with the SQL query itself.
Please provide any insight you may have into resolving this issue. Thank you in advance!