Sending and receiving data to PHP from Python

Question

I am working on a project that requires a python client to execute functions and send data to a PHP server. To clarify, the python program is on a client computer, the PHP script is hosted on a webserver (24hosting). I need the python script to be able to get data from an SQL server hosted on the same site as the PHP server. I have already written code to get the SQL table data using PHP, I just need a way to get that data into python.

I am hoping the process will look like this:

Data in SQL Table
Get data using PHP
Use python on remote computer to recieve data from PHP

Any advice on how to go about this will be greatly appreciated!

rogue-one · Accepted Answer · 2014-07-30 23:19:15Z

1

Take a look at the requests api library in Python. You can use this library to let your python client make web based calls to our php code hosted in a web-server.

answered Jul 30, 2014 at 23:19

rogue-one

11.6k8 gold badges56 silver badges79 bronze badges

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

Comments

Rob Irwin · Accepted Answer · 2015-10-07 17:29:22Z

0

You can pass data from PHP to Python via JSON like this.

PHP script myscript.php reads a database table into a PHP array which is then encoded as JSON:

$fields = array('pkey', 'name', 'occupation');
$result = $conn->query($sql);
$row_data = array();
while ($row = $result->fetch_assoc()) {
    $row_data[] = $row;
}
$rowfields = array('cols' => $fields, 'rows' => $row_data);
$json_data = json_encode($rowfields);
echo $json_data;

Then on a local computer running python:

import json
import urllib2
url = r'http://www.mysite/myscript.php'
response = urllib2.urlopen(url)
remote_data = json.load(response)

In this example, remote_data is a python dictionary with our server data.

answered Oct 7, 2015 at 17:29

Rob Irwin

2332 silver badges11 bronze badges

Comments

Smart Manoj · Accepted Answer · 2019-06-13 12:33:14Z

0

You probably want to send the data from the PHP webserver in some easy-to-parse format such as JSON. Python has good parsing libraries for JSON, and for sending/receiving HTTP requests. The later is not part of the standard library, but can be downloaded using pip or similar.

edited Jun 13, 2019 at 12:33

Smart Manoj

6,0736 gold badges45 silver badges66 bronze badges

answered Jul 31, 2014 at 9:14

Christian P.

4,8847 gold badges56 silver badges70 bronze badges

Collectives™ on Stack Overflow

Sending and receiving data to PHP from Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related