Salve ragazzi ho questo codice qua fatto per una ethernet shield in pratica dovrebbe fare delle somme da mettere in 3 variabili e inviarle periodicamente a un database ho fatto le varie connessioni a mysql slo che vorrei far girare il codice della ethernet sullo yun e non so quali parametri cambiare
Connessione al database
<?php
$username="YUN";
$password ="password1";
$servername="localhost";
$connex =mysql_connect($username,$password,$servername);
$db =mysql_select_db('bancadati',$connex);
if($connex)
{
echo"Connected man";
}else{
echo"try again :)) " .mysqli_connect_error();
}
?>
i vari insert
<?php
include("connessione.php")
$sens1= $_GET['sensore1'];
$sens2= $_GET['sensore2'];
$sens3= $_GET['sensore3'];
$sql_insert ="insert into tabbellaarduino (sensore1,sensore2,sensore3) values ('$sens1','$sens2','$sens3')";
mysql_query($sql_insert);
if($sql_insert)
{
echo "Dati salvati con successo";
}else{
echo "errore bello :))";
}
?>
E questo codice per la ethernet che io vorrei convertitre per farlo girare sullo yun ma non so quali parametri andare a cambiare
#include <SPI.h>
#include <Ethernet.h>
byte mac[] = {
0x00, 0xAA, 0xBB, 0xCC, 0xDE, 0x02
};
byte ip[] = {
10, 42, 0, 42
};
byte server[] = {
10, 42, 0, 1
};
EthernetClient client;
float sensore1 = 0;
float sensore2 = 0;
float sensore3 = 0;
String readString = String(30);
unsigned long previousMillis = 0;
const long interval = 1000;
void setup() {
Ethernet.begin(mac, ip);
Serial.begin(9600);
}
void loop() {
EthernetClient client =server.available();
unsigned long currentMillis = millis();
if (currentMillis - previousMillis >= interval) {
previousMillis = currentMillis;
if (client.connect(server, 80)) {
Serial.println("connesso");
client.println("GET /arduino/salvadati.php");
client.println("sensore1=");
client.println(sensore1);
client.println("sensore2=");
client.println(sensore2);
client.println("sensore3=");
client.println(sensore3);
Serial.println("Sensore 1 = ");
Serial.println(sensore1 );
Serial.println("Sensore 2 = ");
Serial.println(sensore2 );
Serial.println("Sensore 3 = ");
Serial.println(sensore3 );
client.stop();
}
else {
Serial.println("connessione falita");
}
}
if(client)
{
while(client.connected())
{
if(client.available())
{
char c = client.read();
if(readString.length() <30){
readString +=(c);
}
if(c== '\n')
{
client.println("HTTP/1.1 200 OK");
client.println("Content-Type: text.html");
client.println();
client.println("<doctype : html>");
client.println("<html>");
client.println("<head>");
client.println("<title>Prova</title>");
client.println("<meta name =\"viewport\" content=\"width=320\">");
client.println("<meta name =\"viewport\" content=\"width=device-width\">");
client.println("<meta charset=\"utf-8\">");
client.println("<meta name =\"viewport\" content=\"initial -scale=1.0 userscalable=no\">");
client.println("<meta http-equiv=\"refresh\"content=\"3; URL=http//10.42.0.42:8090\">")
client.println("</head>");
client.println("<body>");
client.println("<center>");
client.println("<font size=\"5\" face=\"verdana\" color=\"green\">Mysql</font>");
client.println("<font size=\"5\" face=\"verdana\" color=\"red\">e</font>");
client.println("<font size=\"5\" face=\"verdana\" color=\"blue\">Arduino</font>");
client.println("<font size=\"5\" face=\"verdana\" color=\"red\">Sensore1= </font>");
client.println("<font size=\"5\" face=\"verdana\" color=\"red\">");
client.println(sensore1);
client.println("</font>
");
client.println("<font size=\"5\" face=\"verdana\" color=\"red\">Sensore2= </font>");
client.println("<font size=\"5\" face=\"verdana\" color=\"red\">");
client.println(sensore2);
client.println("</font>
");
client.println("<font size=\"5\" face=\"verdana\" color=\"red\">Sensore3= </font>");
client.printl
char comando = Serial.read();
if (comando == 'a')
{
if (client.connect(server, 80)) {
Serial.println("connesso");
client.println("GET /arduino/salvadati.php");
client.println("sensore1=");
client.println(sensore1);
client.println("sensore2=");
client.println(sensore2);
client.println("sensore3=");
client.println(sensore3);
Serial.println("Sensore 1 = ");
Serial.println(sensore1 );
Serial.println("Sensore 2 = ");
Serial.println(sensore2 );
Serial.println("Sensore 3 = ");
Serial.println(sensore3 );
client.stop();
}
else {
Serial.println("connessione falita");
}
}
}
n("<font size=\"5\" face=\"verdana\" color=\"red\">");
client.println(sensore3);
client.println("</font>
");
client.println("</center>");
client.println("</body>");
client.println("</html>");
readString="";
client.stop();
}
}
}
}
}
