PIC18F4510|ENC28J60 send data to mysql-server

[egoveedee]

I want to make a temperaturesensor connected to a mysql database with ethernetcable.

So, I choose a temperature-sensor(DS1820) connected to a PIC18F4510 and the pic is connected with the ENC28J60 with a SPI connection.

Is it possible to send periodicly(ex each second) a message to the databaseserver like this=> "192.168.1.30/index.php?dev_id=xxxxxxx&temp=xxxxxxxx"

There is running a phpscript to put the value's in the database.

?????????????????????????????????????????????????????????????????

Right now, I can see the temperature on a lcd and on the pic-webserver. So I only need to send the data to the database-server.

Thanks,
Thomas

[codesmith]

Hi,

If you are seeing it on your server, the only thing you need to do is write the PHP code to save it to the database...you already have the other communication going.

[egoveedee]

hey,

I already have a php script on my database server(Intel core T2250), but the PIC(with enc28j60) must connect periodicly to this server and send the data(device_id and temperature).

I only need the code so my pic can send 2 GET-vars to my database server.
In a normal browser you can simple add value to put this "http://192.168.1.130/insert.php?dev_id=xxx&temp=xxx" in the browseradres. I want to know how can I fix this with a pic.

Thanks,
Thomas

ps: I've read that there is a small bug in the libary in v8.1.0. Can somebody post the exact link to the topic? Because I have v8.1.0... ANd how I can fix it.
Thanks for all!

[deploser]

Hi, I want to send data from PIC to PHP script file over ethernet. I have investigated MikroC's ethernet library but I can't find anything about my problem. Thanks for your help.

Best regards
deploser

[anikolic]

Hi,
Our current Ethernet library currently doesn't support TCP client implementation. I have answered to your similar question here: http://www.mikroe.com/forum/viewtopic.p ... 030#116030

Best regards,
Aleksandar

[srdjan]

Hi,

Hi,
Our current Ethernet library currently doesn't support TCP client implementation. I have answered to your similar question here: http://www.mikroe.com/forum/viewtopic.p ... 030#116030

Best regards,
Aleksandar

It's here.
http://www.libstock.com/projects/view/1 ... et-library