Send data to php server from Python

Question

I have a php script on server side that collects data and inserts into MySQL database ;

$sql = "INSERT INTO tbl_marks (value) VALUES ('".$_GET["value"]."')";

I can add values from browser without issues as such ;

http://localhost/write.php?value=100

But I can't post from Python using requests ;

r = requests.post('https://localhost/write.php?', data = {'value':'100'})

There are no errors or warnings but I see that no entries are written to the table from Python. What am I doing wrong ?

print(r.status_code) check if your POST message was successful? — Or Y
– Or Y, Commented Sep 24, 2020 at 15:13
Have you debugged your POST object to see what the result was? — Random Davis
– Random Davis, Commented Sep 24, 2020 at 15:15
status_code returns "200". Yes http-https difference was a typo, sorry — servedc0ld
– servedc0ld, Commented Sep 24, 2020 at 15:21
I searched around and tried all the methods like mimicing a browser with header but still issue remains. Anyone encountered similar behavior ? At response of Python : >This site requires Javascript to work, please enable Javascript in your browser or use a browser with Javascript support. How can I resolve this issue ? — servedc0ld
– servedc0ld, Commented Sep 24, 2020 at 16:18

Jackson · Accepted Answer · 2020-09-24 16:25:19Z

1

The PHP you submitted is looking at GET values (Directly from the user by the way. Look into SQL injection attacks), but your python is making a POST request. Try this instead:

r = requests.get('http://localhost/write.php', params={'value': '100'})

answered Sep 24, 2020 at 16:25

Jackson

881 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

Send data to php server from Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related