esp8266 + sd card+ send

Using Arduino Programming Questions
1

Hi i have question...

I have node mcu esp8266, sd card adapter, and i wanna get them work like this:

  1. Save csv file into sd card. Done...

  2. Send that csv file to internet like i send my temperature sensor data

HTTPClient http;

USE_SERIAL.print("[HTTP] begin...\n");
// configure traged server and url

http.begin("http://someaddress.com/directory/place/file.php?ipsrc=1&temperature="+String(temp) );

so question is..

How do i send a file from sd card????

2 
  WiFiClient client;
  if (client.connect(yourHost, 80)) {
    File dataFile = SD.open("filename.csv");
    client.println(F("POST /your-url HTTP/1.1"));
    client.print(F("Host: "));
    client.println(yourHost);
    client.println(F("Connection: close"));
    client.print(F("Content-Length: "));
    client.println(dataFile.size());
    client.println();
    client.write(dataFile);
    dataFile.close();
    client.stop();
  }
3

Juraj:

  while (dataFile.available()) {

client.write(dataFile.read());
  }

IIRC, you can use

client.write(dataFile);

It does some proper buffering under the hood:

4

PieterP:
IIRC, you can use

client.write(dataFile);

It does some proper buffering under the hood:
Arduino/libraries/ESP8266WiFi/src/include/ClientContext.h at b08d282673055b4758cd73d3cd99573f619112a5 · esp8266/Arduino · GitHub

thank you, I edited the snippet

5

with
client.write(dataFile);

Still don't work, but with

while (dataFile.available()) {
client.write(dataFile.read());

}

works, but is not saving on server.

6

Post all of your code, both Arduino and server-side code.

7

Code works, but i need php, what php code i need, so it could save new file in same plase where is php file?

8

vadims0201:
so it could save new file in same plase where is php file?

That's a terrible idea. I would just send a post request containing a php reverse shell, your script places it into the hosting folder, I send a new request to that file, it executes the reverse shell, and I just logged into your server.
Don't do that.

There are counless examples online on how to save files using php, please do some research.

9

WiFiClient client;
if (client.connect("server ip", 80)) {
File myFile = SD.open("test.csv");
client.println(F("POST /http://temperaturetest.com/city/place/ "));

client.print(F("Host: "));
client.println("server ip");
client.println(F("Connection: close"));
client.print(F("Content-Length: "));
client.println(myFile.size());
while (myFile.available()) {
client.write(myFile.read());
}

myFile.close();
client.stop();

}

and nothing...

just uploads to my esp8266

10

Juraj:

    client.println(F("POST /your-url HTTP/1.1"));

client.print(F("Host: "));
    client.println(yourHost);
    client.println(F("Connection: close"));
    client.print(F("Content-Length: "));
    client.println(dataFile.size());
    client.println();
    client.write(dataFile);
  }

vadims0201:

    client.println(F("POST /http://temperaturetest.com/city/place/ "));   // where's the protocol?

client.print(F("Host: "));
    client.println("server ip");
    client.println(F("Connection: close"));
    client.print(F("Content-Length: "));
    client.println(myFile.size());  // where's the second new line?
    while (myFile.available()) {
      client.write(myFile.read());
    }

Why did you change the perfectly valid HTTP request Juraj posted?

11

WiFiClient client;
if (client.connect("server ip", 80)) {
File myFile = SD.open("test.csv");
client.println(F("POST /http://temperaturetest.com/city/place/ HTTP/1.1 "));

client.print(F("Host: "));
client.println("server ip");
client.println(F("Connection: close"));
client.print(F("Content-Length: "));
client.println(myFile.size());
client.println();
while (myFile.available()) {
client.write(myFile.read());
}

myFile.close();
client.stop();

}

like that>?

I just need it to write to csv file on server,

It just connects to server and nothing else...

12

sending the file by one byte at the time is very ineffective. use the client.write(dataFile); or use buffering

13

client.write(dataFile);

if i do so
Error compiling for board NodeMCU 1.0 (ESP-12E Module).

14

vadims0201:
client.write(dataFile);

if i do so
Error compiling for board NodeMCU 1.0 (ESP-12E Module).

write(Stream&) was added to the esp8266 core 2 years ago

15

Juraj:
write(Stream&) was added to the esp8266 core 2 years ago

and??

16

Please tell me what should i do, to send from sd card csv file to my server... i did every thing you told me, but still nothing.

17

You still didn't post your server-side script. What do you want to do? What does the server expect?

18

you variable for the file is not dataFile like in my snippet so you need client.write(myFile); not client.write(dataFile).

I do not know php

19

Please, edit your post and use [code] /* your code here */ [/code] tags, (using the </> button), so your code is readable.

Don't use mysqli, use PDO instead. You are sending an HTTP POST request, so why are you using the php $_GET[] variable? That contains the data of an HTTP GET request.

Do you know what your file looks like? Is your goal to have large CSV texts as database entries? I don't think so.

If someone were to open the url http://temperaturetest.com/city/place/add.php?temperature=1)%3B%20DROP%20TABLE%20`my%20temp`%3B%20(, all of your precious data would be gone forever.

Read up on SQL injection and other security guidelines before you irresponsibly throw your vulnerable PHP code on the internet.

20

Juraj:
you variable for the file is not dataFile like in my snippet so you need client.write(myFile); not client.write(dataFile).

I do not know php

with client.write(myFile);

nothing changed..