Receive json data in PHP

Question

I’m having trouble receiving JSON data in PHP to save to the database, and this data is sent from a python script, have tried the json_decode using the variable $_REQUEST, but unsuccessfully, when I record in a .txt i can get the data but when I try to write to a variable to save to the database I can’t print anything to confirm that the data went to variable.

Python

import json
import requests
import Adafruit_DHT
import RPi.GPIO as GPIO
import Adafruit_BMP.BMP085 as BMP085
import time

sensorBMP = BMP085.BMP085();
sensorDHT11 = Adafruit_DHT.DHT11;

GPIO.setmode(GPIO.BOARD);
pinoSensorDHT11 = 25;

temperature = 0.0;
pressure = 0.0;
humidity = 0.0;
dia = 0;
hora = 0.0;

while(1):
temperature = sensorBMP.read_temperature();
pressure = sensorBMP.read_pressure();
altitude = sensorBMP.read_altitude();
dia = time.strftime("%d/%m/%Y");
hora = time.strftime("%H/%M/%S");
while(1):
humidity, tempNotUsed = Adafruit_DHT.read_retry(sensorDHT11,pinoSensorDHT11);
    if humidity is not None and tempNotUsed is not None:
        dic = {
            'Temperature' : temperature,
            'Humidity' : humidity,
            'Pressure' : pressure,
        }
        jason = json.dumps(dic);
        print(jason);


        r = requests.post("http://54.174.181.91/tcc/jsonTeste.php",   data = {"jsonFile": jason});

        #print (r);
        if r.status_code is not 200:
            print "FALHA!!!!!!";
            print r.status_code;
            break;
    break;
break;

And when write to txt using PHP:

<?php
echo "<pre>";
var_dump($_POST); 
$data = $_POST["jsonFile"];


// Abre ou cria o arquivo bloco1.txt
// "a" representa que o arquivo é aberto para ser escrito

$fp = fopen("bloco1.txt", "w");

// Escreve "exemplo de escrita" no bloco1.txt
$escreve = fwrite($fp, $data);

// Fecha o arquivo
fclose($fp);


?>

How can I take this data and write to a common variable?

Answer 1

$_POST takes form data (headers of the kind urlencoded and form).

You will be able to get the data with

$data = json_decode(file_get_contents('php://input'));

reading the body of the request directly.

And why has this question now appeared on home ptSO after almost two years? OP failed to solve the problem in two years?

Answer 2

I didn’t quite understand the first doubt, that you can show how this json you’re trying to save would be easier.

But for your last doubt, when you save json in the file, serializes json before storing, because you would generate a serialized data and would be able to work better when picking up this file json, because when you read data from a file you can only read line by line. So you would take a single line that would have all your json data, would give a deserialize and could put into a single variable containing all its json.

To read files you can take a look at the php documentation. http://php.net/manual/en/function.file.php

Answer 3

Since you are using Rduino it does not send the page header, you can use

header('Content-Type: application/json');
echo json_encode($data);

is one of the alternatives, the other is you set when saving in the bank the type of encoding this using, preferably UTF8

Answer 4

Try it like this:

$data = json_decode($jsonFile);