sending the json data from python to php

Question

I am sending the json data from a python program using the below code

import json
import requests

data = {"temp_value":132}
data_json = json.dumps(data)
payload = {'json_playload': data_json}
r = requests.get('http://localhost/json1/js2.php',data=payload)

and receiving it in a php server side using the below code.

<?php

if($_GET['temp_value']) {
    $temp_value = $_GET['temp_value'];
    echo $temp_value;

  #  $data = array($id, $description);
   $arr=json_decode($temp_value,true);

   } else {
echo "not found";}
// Connect to MySQL
    include("dbconnect.php");

    // Prepare the SQL statement
    $SQL = "INSERT INTO test1.temperature1 (temp_value) VALUES ('$arr')";    

    // Execute SQL statement
    mysqli_query($dbh,$SQL);
    Echo "<a href=http://localhost/json1/review_data.php><center><u><b><h1>Manage values<h1><b><u></center></a>"

?>

along with the json data I have implemented like Id,time and date also gets updated in the database when i send the data.But what is happening here is like whenever i send the data from the python program it won't give any errors,when i see in the database and in the php page only 0(zero) values are inserted in both,however time and id gets updated.please someone suggest me a proper code and way.

zero.When i send the data from python and checked in the database only zero values are stored,not the actual values i sent. — Vishwa
– Vishwa, Commented Feb 27, 2015 at 4:59
( ! ) Notice: Undefined index: temp_value in C:\wamp\www\json1\js2.php on line 3 not found,when i commented the database part and just tried to get that temp_value in $arr — Vishwa
– Vishwa, Commented Feb 27, 2015 at 5:11

Richard · Accepted Answer · 2015-02-27 06:31:45Z

0

Try this:

<?php
  $json_payload = json_decode($_GET['json_payload']);
  $temp_value   = $json_payload['temp_value'];
?>

When you do this:

r = requests.get('http://localhost/json1/js2.php',data=payload)

You are sending a get request containing a JSON string representation of your data:

'{"temp_value": 132}'

stored in the get parameter named json_payload.

Therefore, on the client side, you must retrieve the contents of the json_payload parameter and decode the JSON string therein in order to retrieve temp_value.

Alternatively, you could do this:

payload = {"temp_value":132}
r = requests.get('http://localhost/json1/js2.php',data=payload)

And leave your PHP code unmodified.

answered Feb 27, 2015 at 6:31

Richard

62.8k40 gold badges198 silver badges277 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sivasailanathan · Accepted Answer · 2015-02-27 06:46:57Z

0

import json
import requests

data = {"temp_value":132}
data_json = json.dumps(data)
payload = {'json_playload': data_json}
r = requests.get('http://localhost/json1/js2.php',data=payload)
print(r.url)//http://localhost/json1/js2.php

Json data is not passed in to php.Check your python code

payload = {'key1': 'value1', 'key2[]': ['value2', 'value3']}
r = requests.get("http://httpbin.org/get", params=payload)
print(r.url)

Result: http://httpbin.org/get?key1=value1&key2%5B%5D=value2&key2%5B%5D=value3

You have to use like payload = {"temp_value":132}

edited Feb 27, 2015 at 6:46

answered Feb 27, 2015 at 6:27

Sivasailanathan

1352 silver badges11 bronze badges

1 Comment

Vishwa Over a year ago

i have tried all the ways listed here,but no way has worked me

Collectives™ on Stack Overflow

sending the json data from python to php

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related