MySQL DB, send a multiple data through Python-PHP to the server

Question

I have a Virtual Machine/Web Server with MySQL up and running, and want to receive the data from client hardware that is saved in a .csv file, how can i do a python script to send it? i was recommended requests library from Python to send it and receive it through PHP POST. Problem is ive NEVER used PHP and HTML and so im a bit stuck with the interaction between the 2. Thanks a lot!

sample code is:

import csv
import requests

session = requests.Session()
with open('r01a2.csv','rb') as f:
    reader = csv.reader(f)
    for row in reader:
        r = session.post('MyURL', data = {'date: row[0],'value': row[1]})
        print r.text

Code on Server side is:

    <?php
$formato = "INSERT INTO `datos_pruebas`.`Datos_Edison` (`id`, `date`, `pulse`) VALUES (NULL, '%s', '%f')";
$sql=sprintf($formato,$date,$pulse);
$enlace = mysql_connect('localhost','root','clinichub');
$resultado = mysql_query($sql,$enlace);
$id=NULL;
if(!empty($_POST))
{
        echo htmlspecialchars($_POST["date"]);
} else { 
echo "gg";
}

EDIT2: It finally worked after solutions gave by community and feedback, thanks a lot for your recommendations!

Shouldn't you do $_POST["data"]?

Filnor
– Filnor

2017-11-13 13:43:36 +00:00
Commented Nov 13, 2017 at 13:43 — Filnor
– Filnor, Commented Nov 13, 2017 at 13:43
I did that but didnt change answer :/

Gonzalo
– Gonzalo

2017-11-13 13:59:22 +00:00
Commented Nov 13, 2017 at 13:59 — Gonzalo
– Gonzalo, Commented Nov 13, 2017 at 13:59

DevionNL · Accepted Answer · 2017-11-13 13:42:54Z

1

Make sure the post in python uses the correct content-type and verify on the serverside php if $_FILES has an entry. (i.e. print_r($_FILES) ) should return your file, you won't find it in $_POST.

answered Nov 13, 2017 at 13:42

DevionNL

1531 silver badge13 bronze badges

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

12 Comments

Gonzalo Over a year ago

Sorry, im a total newbie regarding PHP, can you edit with an example code?

DevionNL Over a year ago

<?php print_r($_FILES) ?> to start with, it should output the uploaded file metainfo. If you wish to use the contents of the file, the temporary file will be in $_FILES[0]['tmp_name'].

Gonzalo Over a year ago

But im currently not sending the file just now, or maybe i should send it right away? thing is im not even receiving the 'name'

Gonzalo Over a year ago

Answer from server after adding that line is: HI!Array()

DevionNL Over a year ago

Shouldn't the python code be more akin to data= { 'q': '[python]' } r = requests.get('stackoverflow.com', data=data)

|

Collectives™ on Stack Overflow

MySQL DB, send a multiple data through Python-PHP to the server

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related