Comments on: ESP32/ESP8266 Publish Data to Raspberry Pi LAMP Server

By: john clark

john clark — Wed, 23 Jul 2025 09:52:03 +0000

for more than 8 weeks mine worker perfectly with 4 values UNTIL lightning destroyed my router and pi. I bought a new 4b raspberry pi and sd card but when testing phpmyadmin the index.php file does not run but lists its contents. the only thing i can think is that the latest imager software offers bookworm as an image OS not raspbian OS and they may not work the same.
have you any thoughts ?
kind regards john.

By: Paul OHare

Paul OHare — Sat, 07 Jun 2025 20:16:37 +0000

Thank you. Your article got my project unstuck!
One issue that stymied me was I was using a URI of ‘HTTP://www.something.org/…’.
This caused my ESP32 to return -1 (conn refused). Changing the URI to
‘http://www.something.org/…’ resolved it!

By: John

John — Sun, 20 Apr 2025 05:29:15 +0000

In reply to Kev. After months of trying i still can't do it, if i try to get my value 4 from the esp32 i get an error but if i change the php file to say value 4 ="popcorn" then popcorn appears in the database which contains over 15000 correct entries so it is how the data is collected from the esp somewhere

By: Kev

Kev — Thu, 17 Apr 2025 15:49:28 +0000

Im new to PHP etc – I’ve changed the table fields etc for my own data and I’m getting a -1 error.

is there a way of seeing the echo’s from the post.php files for error checking, I think I’ve changed all the area’s that corresponed with the new database

By: john clark

john clark — Wed, 26 Feb 2025 11:29:16 +0000

Could i please ask for help once again because i cant get past the error-1,i can put data into the db with my admin but not from the esp32 nor can i read it out.
I am sure i have done something stupid so could you clear up 2 points for me :-
i have set my pi up with username and password and used another name and password in myadmin so which should i use in the files given.
question 2 is after setting up the database it is esp_data with an under score, the two instructions that create the php files using nano use esp-data with a minus sign after the esp. it is beyond my ability to understand ,please help this last time.john

By: john clark

john clark — Mon, 17 Feb 2025 11:04:51 +0000

In reply to Sara Santos. Thank you Sara

By: Sara Santos

Sara Santos — Wed, 12 Feb 2025 10:27:27 +0000

In reply to john clark.

Hi.
To copy on the terminal, select and press the mouse right button. It will be copied.
To paste, just press the right button on the mouse again without anything selected.
Regards,
Sara

By: john clark

john clark — Wed, 12 Feb 2025 08:08:11 +0000

Oh my very old head needs help : i am following your example line by line but get stuck by the line Copy the following PHP script to the newly created file (post-esp-data.php):
the example script i have stored as windows text but the file (post-data.php) is on the pi, control c control v does not seem to work.
how do i get the win10 script onto the pi by ssh connection
thank you

By: Andrew Longdon

Andrew Longdon — Mon, 02 Sep 2024 19:43:05 +0000

In reply to Dustin.

Ding-dong-do! – I emptied the dataset and it started filling again and I can now see it via http://“IP of server”/esp-data.php

By: Dustin

Dustin — Sun, 01 Sep 2024 23:10:30 +0000

In reply to Andrew Longdon. Yeah. Those huge datasets have bit me in the past. I was never good at php, but I know in other languages you can do some asynchronous calls that’ll retrieve smaller chunks of data and setup paging so it only displays a set number of rows per page. Not sure if that’s a possibility in php