After receiving an array from JAVA and using print_r($_POST), I have tried various methods to extract data but with no success. The format of the array is as follows:
{"attending":0,"eventid":1,"userid":1}
I've attempted different approaches found on SO and online, such as those surrounded by single quotes (' ') and square brackets ([]).
This is my code snippet:
print_r($_POST);
$data = json_decode($_POST);
$userid = $data['userid'];
$eventid = $data['eventid'];
$attending = $data['attending'];
My question is, how can I effectively retrieve values from the Post method and assign them accordingly?
I'm still new to PHP, so please be patient with me.
I also gave this a shot:
$data = json_decode($_POST, true);
But now I'm encountering the following warning:
Warning: json_decode() expects parameter 1 to be string, array given in C:\xampp\htdocs\attendanceradio.php on line 9
Here's the output of var_dump($_POST);:
Array
(
[{"attending":0,"eventid":2,"userid":1}] =>
)
array(1) {
["{"attending":0,"eventid":2,"userid":1}"]=>
string(0) ""
}
And here is the complete PHP code:
<?php
$user = 'root';
$pass = '';
$db = 'testuser';
$con=mysqli_connect('localhost', $user, $pass, $db) or die('Unable to connect');
print_r($_POST['json']);
var_dump($_POST);
$json = json_decode(trim(key($_POST), '[]'), true);
var_dump($json);
$userid = $json['userid'];
$eventid = $json['eventid'];
$attending = $json['attending'];
$statement = mysqli_prepare($con,
'INSERT INTO user_has_event(user_user_id, event_event_id, attendance)
VALUES (?, ?, ?)
ON DUPLICATE KEY UPDATE attendance = ?');
mysqli_stmt_bind_param($statement, 'iii', $userid, $eventid, $attending);
mysqli_stmt_execute($statement);
mysqli_stmt_store_result($statement);
mysqli_stmt_bind_result($statement, $userid, $eventid, $attending);
mysqli_stmt_close($statement);
mysqli_close($con);
?>