I am trying to capture sensor data and upload it to a mysql database.
I have 100 bytes every 1 second I wish to transmit.
I tried using a insert.php?sensor=1&d0=1&d1=2 etc for 100 bytes, I can get it to work with 70bytes but I think I'm running into a memory issue as it just hangs when trying to http.post the data.
I have a working mysql client program but again when I try and insert it hangs at:
while (sqlLastResult == MYSQL_PROCESSING) { Net::poll(); }
I thought about creating a txt file and then pushing that to the server, I've tried reading the httptext and httpfile pages but I can't work my head around how they work and I haven't come across any example of uploading a txt file.
Can anyone suggest how I go about doing this?
I am trying to capture sensor data and upload it to a mysql database. I have 100 bytes every 1 second I wish to transmit.
I tried using a insert.php?sensor=1&d0=1&d1=2 etc for 100 bytes, I can get it to work with 70bytes but I think I'm running into a memory issue as it just hangs when trying to http.post the data.
I have a working mysql client program but again when I try and insert it hangs at: while (sqlLastResult == MYSQL_PROCESSING) { Net::poll(); }
I thought about creating a txt file and then pushing that to the server, I've tried reading the httptext and httpfile pages but I can't work my head around how they work and I haven't come across any example of uploading a txt file.
Can anyone suggest how I go about doing this?