Ethercard + Arduino posting data is blank in db
hi,
i'm using enc28j60 arduino , using ethercard library. when url parse data browser data gets mysql db. arduino post blank. below sketch , please me resolve this.
when try send data maybe problem stash or when sending stash
so please tell me doing wrong. need urgent guys
thanks advance
i'm using enc28j60 arduino , using ethercard library. when url parse data browser data gets mysql db. arduino post blank. below sketch , please me resolve this.
code: [select]
#include <ethercard.h>
// variable
string key = "a123ds";
string sid = "ps1"
// ethernet interface mac address, must unique on lan
byte mymac[] = { 0x74,0x69,0x69,0x2d,0x30,0x31 };
const char website[] progmem = "192.168.1.106";
byte ethernet::buffer[700];
uint32_t timer;
stash stash;
void setup () {
serial.begin(57600);
serial.println("\n[webclient]");
if (ether.begin(sizeof ethernet::buffer, mymac, 4) == 0)
serial.println( "failed access ethernet controller");
if (!ether.dhcpsetup())
serial.println("dhcp failed");
ether.printip("ip: ", ether.myip);
ether.printip("gw: ", ether.gwip);
ether.printip("dns: ", ether.dnsip);
#if 0
if (!ether.dnslookup(website))
serial.println("dns failed");
#else
ether.parseip(ether.hisip, "192.168.1.106");
#endif
ether.printip("srv: ", ether.hisip);
}
void loop () {
ether.packetloop(ether.packetreceive());
if (millis() > timer) {
timer = millis() + 5000;
byte sd = stash.create();
stash.print("apikey=");
stash.print(key);
stash.print("station_id=");
stash.print(sid);
stash.save();
stash::prepare(pstr("post http://192.168.1.106/savecontactinfo.php?sd http/1.0" "\r\n"
"host: 192.168.1.106 \r\n"
"content-length: $d" "\r\n"
"content-type: application/x-www-form-urlencoded \r\n"
"\r\n"
"$h"),
stash.size(), sd);// website, pstr(path), website,
// send packet - releases stash buffers once done
ether.tcpsend();
}
}
when try send data maybe problem stash or when sending stash
code: [select]
stash::prepare(pstr("post http://192.168.1.106/savecontactinfo.php?apikey=a123ds&station_id=ps1 http/1.0" "\r\n"
"host: 192.168.1.106 \r\n"
"content-length: $d" "\r\n"
"content-type: application/x-www-form-urlencoded \r\n"
"\r\n"
"$h"),
stash.size(), sd);// website, pstr(path), website,
// send packet - releases stash buffers once done
ether.tcpsend();
so please tell me doing wrong. need urgent guys
thanks advance
- have tried ensure reachability form arduino network? sure works?
- web server use? sure it's reachable outside hosting machine?
- see in logs of web server?
as side note, don't think matters but
- have space @ end of
"host: 192.168.1.106 \r\n" before \r\n --> rid of it
- size last element before empty line, move "content-type: application/x-www-form-urlencoded \r\n"before "content-length: $d" "\r\n"
- web server use? sure it's reachable outside hosting machine?
- see in logs of web server?
as side note, don't think matters but
- have space @ end of
"host: 192.168.1.106 \r\n" before \r\n --> rid of it
- size last element before empty line, move "content-type: application/x-www-form-urlencoded \r\n"before "content-length: $d" "\r\n"
Arduino Forum > Using Arduino > Programming Questions > Ethercard + Arduino posting data is blank in db
arduino
Comments
Post a Comment