Hi. I have a code that send dht22 data to mysql base in specific time with ds3231:
#include <SPI.h>
#include <Ethernet.h>
#include "DHT.h"
#include <TimeLib.h>
#include <TimeAlarms.h>
#include <Wire.h>
#include <DS1307RTC.h>
#define DHTPIN 7
#define DHTTYPE DHT22
DHT dht(DHTPIN, DHTTYPE);
byte mac[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED }; //Newer Ethernet shields have a MAC address printed on a sticker on the shield
IPAddress server(192, 168, 7, 1); //IPv4 address
EthernetClient client;
void setup() {
Serial.begin(9600);
// wait for Arduino Serial Monitor
while (!Serial) ;
// get and set the time from the RTC
setSyncProvider(RTC.get);
if (timeStatus() != timeSet)
Serial.println("Unable to sync with the RTC");
else
Serial.println("RTC has set the system time");
// to test your project, you can set the time manually
//setTime(8,29,0,1,1,11); // set time to Saturday 8:29:00am Jan 1 2011
// create the alarms, to trigger functions at specific times
Alarm.alarmRepeat(10, 25, 0, MorningAlarm);
Alarm.alarmRepeat(10, 25, 30, EveningAlarm);
Ethernet.begin(mac);
dht.begin();
}
void loop() {
digitalClockDisplay();
// wait one second between each clock display in serial monitor
Alarm.delay(1000);
}
void AlaramFunc() {
int idSensor = 1;
float hum = dht.readHumidity();
float temp = dht.readTemperature();
float fah = dht.readTemperature(true);
float heat_index = dht.computeHeatIndex(fah, hum);
float heat_indexC = dht.convertFtoC(heat_index);
if (client.connect(server, 80)) {
Serial.println("connected");
client.print("GET /data.php?");
client.print("temperature=");
client.print(temp);
client.print("&humidity=");
client.print(hum);
client.print("&heat_index=");
client.print(heat_indexC);
client.print("&idSensor=");
client.print(idSensor);
client.println(" HTTP/1.1");
client.println("Host: 192.168.7.1");
client.println("Connection: close");
client.println();
Serial.print("GET /data.php?");
Serial.print("temperature=");
Serial.print(temp);
Serial.print("&humidity=");
Serial.print(hum);
Serial.print("&heat_index=");
Serial.print(heat_indexC);
Serial.print("&idSensor=");
Serial.print(idSensor);
Serial.println(" HTTP/1.1");
client.stop(); //Closing the connection
} else {
//if you didn't get a connection to the server:
Serial.println("connection failed");
}
}
void MorningAlarm() {
AlaramFunc();
}
void EveningAlarm() {
AlaramFunc();
}
void digitalClockDisplay() {
// digital clock display of the time
Serial.print(hour());
printDigits(minute());
printDigits(second());
Serial.println();
}
void printDigits(int digits) {
Serial.print(":");
if (digits < 10)
Serial.print('0');
Serial.print(digits);
}
I am trying to combine my code with the code from this tutorial, to also show the current temperature and humidity. But it's not fully working. It shows data on the web server, but can't connect (connection failed on serial monitor) to send data to the database. What's the problem?
#include <SPI.h>
#include <Ethernet.h>
#include "DHT.h"
#include <TimeLib.h>
#include <TimeAlarms.h>
#include <Wire.h>
#include <DS1307RTC.h>
#define DHTPIN 7
#define DHTTYPE DHT22
DHT dht(DHTPIN, DHTTYPE);
byte mac[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED }; //Newer Ethernet shields have a MAC address printed on a sticker on the shield
IPAddress server(192, 168, 7, 1); //IPv4 address
EthernetClient client;
IPAddress ip(192, 168, 1, 99);
EthernetServer server1(80);
void setup() {
Serial.begin(9600);
// wait for Arduino Serial Monitor
while (!Serial) ;
// get and set the time from the RTC
setSyncProvider(RTC.get);
if (timeStatus() != timeSet)
Serial.println("Unable to sync with the RTC");
else
Serial.println("RTC has set the system time");
// to test your project, you can set the time manually
//setTime(8,29,0,1,1,11); // set time to Saturday 8:29:00am Jan 1 2011
// create the alarms, to trigger functions at specific times
Alarm.alarmRepeat(15, 27, 0, MorningAlarm);
Alarm.alarmRepeat(15, 28, 0, EveningAlarm);
Ethernet.begin(mac, ip);
dht.begin();
server1.begin();
}
void loop() {
digitalClockDisplay();
// wait one second between each clock display in serial monitor
Alarm.delay(1000);
float h = dht.readHumidity( );
float t = dht.readTemperature( );
EthernetClient client = server1.available();
if (client)
{
boolean currentLineIsBlank = true;
while (client.connected ( ) )
{
if (client.available ( ) )
{
char character = client.read ( );
Serial.write(character);
if (character == '\n' && currentLineIsBlank)
{
client.println ("HTTP/1.1 200 OK");
client.println ("Content-Type: text/html");
client.println ("Connection: close");
client.println ("Refresh: 5");
client.println ( );
client.println ("<!DOCTYPE HTML>");
client.println ("<html>");
client.print ("<Title>Arduino Ethernet Webserver </Title>");
client.print ("<h1>Arduino Ethernet Shield Webserver </h1>");
client.print ("<h4>Temperature in C: ");
client.print (t);client.print("C");
client.print ("</h4><h4>Humidity: ");
client.print (h);client.print("%");
client.println ("
");
client.println ("</html>");
break;
}
if ( character == '\n')
{
currentLineIsBlank = true;
}
else if (character != '\r')
{
currentLineIsBlank = false;
}
}
}
delay(1);
client.stop();
}
}
void AlaramFunc() {
int idSensor = 1;
float hum = dht.readHumidity();
float temp = dht.readTemperature();
float fah = dht.readTemperature(true);
float heat_index = dht.computeHeatIndex(fah, hum);
float heat_indexC = dht.convertFtoC(heat_index);
if (client.connect(server, 80)) {
Serial.println("connected");
client.print("GET /data.php?");
client.print("temperature=");
client.print(temp);
client.print("&humidity=");
client.print(hum);
client.print("&heat_index=");
client.print(heat_indexC);
client.print("&idSensor=");
client.print(idSensor);
client.println(" HTTP/1.1");
client.println("Host: 192.168.7.1");
client.println("Connection: close");
client.println();
Serial.print("GET /data.php?");
Serial.print("temperature=");
Serial.print(temp);
Serial.print("&humidity=");
Serial.print(hum);
Serial.print("&heat_index=");
Serial.print(heat_indexC);
Serial.print("&idSensor=");
Serial.print(idSensor);
Serial.println(" HTTP/1.1");
client.stop(); //Closing the connection
} else {
//if you didn't get a connection to the server:
Serial.println("connection failed");
}
}
void MorningAlarm() {
AlaramFunc();
}
void EveningAlarm() {
AlaramFunc();
}
void digitalClockDisplay() {
// digital clock display of the time
Serial.print(hour());
printDigits(minute());
printDigits(second());
Serial.println();
}
void printDigits(int digits) {
Serial.print(":");
if (digits < 10)
Serial.print('0');
Serial.print(digits);
}