I'm trying to send my data to PHP and upload it to mysql database. I tried using it on a XAMPP and it is working, now i'm trying to upload it on a website but I have no idea if im doing it right.
I tried doing this line of code Serial.println(client.connect(server,80)); and it returns 0.
PS: I also posted this on this site: ethernet shield - Sending Arduino data to PHP and upload it to MYSQL DATABASE - Arduino Stack Exchange
ARDUINO CODE:
#include <SPI.h>
#include <Ethernet.h>
byte mac[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };
char server [] = "mywebsite.000webhostapp.com"; // Please assume that this is my website.
IPAddress ip(192, 168, 1, 177);
#define trigPin 2
#define echoPin 3
long duration;
float distance;
int pinSensor =8;
int pinLed =9;
int pinBuzzer =7;
int pirSensor =0;
int pirState = LOW;
String desc = "";
EthernetClient client;
void setup() {
Serial.begin(9600);
delay(1000);
Ethernet.begin(mac, ip);
Serial.print("IP Address: ");
Serial.println(Ethernet.localIP());
pinMode(pinSensor, INPUT);
pinMode(pinLed, OUTPUT);
pinMode(pinBuzzer, OUTPUT);
pinMode(trigPin, OUTPUT);
pinMode(echoPin, INPUT);
Serial.begin(9600);
Serial.println("connecting...");
delay(10000);
if (client.connect(server,80)){
Serial.println("OK");
}
else {
Serial.println("NO");
}
}
void loop()
{
digitalWrite(trigPin, LOW);
delayMicroseconds(5);
digitalWrite(trigPin, HIGH);
delayMicroseconds(10);
digitalWrite(trigPin, LOW);
duration = pulseIn(echoPin, HIGH);
distance = (duration*0.034/2)/100;
Serial.println(distance);
delay(500);
pirSensor = digitalRead(pinSensor);
if (pirSensor == HIGH)
{
digitalWrite(pinLed, HIGH);
if (pirState == LOW)
{
desc = "DISTANCE:" +String(distance) +"m";
pirState = HIGH;
if (distance < 3)
{
tone(pinBuzzer, 1000,3000);
desc = "DISTANCE:" +String(distance)+ "m";
}
delay(3000);
}
else
{
if(pirState=HIGH)
{
pirState=LOW;
noTone(pinBuzzer);
}
}
if (client.connect(server,80)){
Serial.println(desc);
client.println("GET /getdata1.php?desc=" +desc+ " HTTP/1.1");
client.println("Host: mywebsite.000webhostapp.com");
client.println("Connection: close");
client.println();
}
else
{
Serial.println("--- Connection Failed");
}
}
}```
PHP CODE:
include.php
<?php
$servername="localhost";
$username="mywebsiteusername";
$password= "P^axdR%D=vS>@bj2";
$dbase= "mywebsitedatabase";
$con= new mysqli($servername,$username,$password,$dbase);
if($con->connect_error)
{
echo("<h2>Connection Error</h2>" .$con->connect_error);
}
?>
getdata1.php
<?php
include "include.php";
$cdate = date("y-m-d");
date_default_timezone_set("Asia/Hong_Kong");
$ctime = date("h:i:sa");
$sql_insert = "INSERT INTO tbl_sensor (DATE, TIME, DESCRIPTION) VALUES ('$cdate', '$ctime',
'".$_GET['desc']."')";
if(mysqli_query($con,$sql_insert))
{
echo "Done";
mysqli_close($con);
}
else
{
echo "error is ".mysqli_error($con );
}
?>
