read output of php file using python

Question

I have a php file on server that prints some data from the mysql database in json format.

When I run my php file in my browser I can see the json array. Now I want to get that json array in a python file. Is there a way to do it?

here is the code i am using

import subprocess
import json
import codecs

proc = subprocess.Popen("http://www.rpi-connect.esy.es/getappliances?room=1", shell=True, stdout=subprocess.PIPE)
script_response = str(proc.stdout.read().decode('utf8'))
print(script_response)

M2skills · Accepted Answer · 2016-07-01 11:12:30Z

2

I finally got the answer after trying a lot of different python libraries

import json
import urllib.request
url = "http://example.com/your-filename.php"
x = urllib.request.urlopen(url)
raw_data = x.read()
encoding = x.info().get_content_charset('utf8')  # JSON default
print(raw_data)   #this is data in string format
data = json.loads(raw_data.decode(encoding))
print(data)   #this would be your json data

this works for python 3.4. for python 2.7 try using json.load() instead of json.loads()

answered Jul 1, 2016 at 11:12

M2skills

3211 gold badge5 silver badges19 bronze badges

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

Comments

David Smith · Accepted Answer · 2016-06-30 07:52:39Z

0

You can achieve this by having your PHP script output the JSON to a file on your server, then have your python script read that JSON in from the file.

You can achieve it like this:

PHP Script:

<?php
$json = json_encode('your data');
$file = '/tmp/json-file';

file_put_contents($file, $json);

Python script:

import json

with open('/tmp/json-file') as data_file:    
    data = json.load(data_file)

    # do whatever you need to do with data here

answered Jun 30, 2016 at 7:52

David Smith

6034 silver badges10 bronze badges

3 Comments

M2skills Over a year ago

I am trying you solution too. should the json-file be already present on server or php creates it on its own

David Smith Over a year ago

The PHP script that I've included in my answer will take care of writing the file to the server. You should change the filepath /tmp/json-file to wherever you'd like the file to be written to on your environment. PHP's file_put_contents() function will take care of creating the file if it doesn't already exist, and will also overwrite a file if one already exists at the location.

M2skills Over a year ago

i am getting no ouput just 2 blank lines I have put the code but this seems to get no output. You can use the link on your browser to see the json array this is the file path rpi-connect.esy.es/jsondata

Amin Alaee · Accepted Answer · 2016-06-30 07:58:25Z

0

Run the code with the following command and store its standard output to a variable:

import subprocess

proc = subprocess.Popen("php /path/to/your/script.php", shell=True, stdout=subprocess.PIPE)
script_response = proc.stdout.read()

And if you need that data in json in python too:

import json
data = json.loads(script_response)

edited Jun 30, 2016 at 7:58

answered Jun 30, 2016 at 7:51

Amin Alaee

1,92519 silver badges27 bronze badges

4 Comments

M2skills Over a year ago

i am getting following error for json.load()Traceback (most recent call last): File "C:\Users\MOHIT\Desktop\pyurl\url.py", line 5, in <module> data = json.loads(script_response) File "C:\Python34\lib\json_init_.py", line 312, in loads s.__class__.__name__)) TypeError: the JSON object must be str, not 'bytes'

Amin Alaee Over a year ago

Try this instead: script_response = proc.stdout.read().decode('utf8') and do the rest.

M2skills Over a year ago

i am getting no ouput just 2 blank lines I have put the code but this seems to get no output. You can use the link on your browser to see the json array

Amin Alaee Over a year ago

Has your problem been solved? If yes then please choose this as the answer. Thank you

Collectives™ on Stack Overflow

read output of php file using python

3 Answers 3

Comments

PHP Script:

Python script:

3 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

PHP Script:

Python script:

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related