no get data on mysql database from arduino by using get request

I have a arduino uno and ethernet shield.
I configure a web server with php files. If i write in my navigator www.*******.byethost16.com/?cb1=22.00&cb2=23 the data up correct to mysql.
I modified webcliend example to upload the data to mysql from arduino uno but not found.
it s the code

#include <SPI.h>
#include <Ethernet.h>

// Enter a MAC address for your controller below.
// Newer Ethernet shields have a MAC address printed on a sticker on the shield
byte mac[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };

// if you don't want to use DNS (and reduce your sketch size)
// use the numeric IP instead of the name for the server:
//IPAddress server(74,125,232,128);  // numeric IP for Google (no DNS)
char server[] = "www.*******.byethost16.com";    // name address for Google (using DNS)

// Set the static IP address to use if the DHCP fails to assign
IPAddress ip(192,168,1,57);

float temperatura=39;

// Initialize the Ethernet client library
// with the IP address and port of the server 
// that you want to connect to (port 80 is default for HTTP):
EthernetClient client;

void setup() {
// Open serial communications and wait for port to open:
 Serial.begin(9600);
  while (!Serial) {
   ; // wait for serial port to connect. Needed for Leonardo only
 }

 // start the Ethernet connection:
 if (Ethernet.begin(mac) == 0) {
   Serial.println("Failed to configure Ethernet using DHCP");
   // no point in carrying on, so do nothing forevermore:
   // try to congifure using IP address instead of DHCP:
   Ethernet.begin(mac, ip);
 }
 // give the Ethernet shield a second to initialize:
 delay(1000);
 Serial.println("connecting...");

 // if you get a connection, report back via serial:
 if (client.connect(server, 80)==1) {
   Serial.println("connected");
   client.print("GET /add.php?cb1=23&cb2=25[code]

“); // Enviamos los datos por GET
//client.print(temperatura);
client.println(” HTTP/1.1");
client.println(“Host: www.*******.byethost16.com”);
client.println(“User-Agent: Arduino 1.0”);
client.println();
Serial.println(“Conectado”);

}
else {
// kf you didn’t get a connection to the server:
Serial.println(“connection failed”);
}
}

void loop()
{
// if there are incoming bytes available
// from the server, read them and print them:
if (client.available()) {

char c = client.read();
Serial.print(c);
}

// if the server’s disconnected, stop the client:
if (!client.connected()) {
Serial.println();
Serial.println(“disconnecting.”);
client.stop();

// do nothing forevermore:
while(true);
}
}

and in serial monitor the arduino write 
connecting...
connected
Conectado
HTTP/1.1 200 OK
Server: nginx
Date: Tue, 25 Oct 2016 09:28:04 GMT
Content-Type: text/html
Content-Length: 857
Connection: keep-alive
Vary: Accept-Encoding
Expires: Thu, 01 Jan 1970 00:00:01 GMT
Cache-Control: no-cache

<html><body><script type="text/javascript" src="/aes.js" ></script><script>function toNumbers(d){var e=[];d.replace(/(..)/g,function(d){e.push(parseInt(d,16))});return e}function toHex(){for(var d=[],d=1==arguments.length&&arguments[0].constructor==Array?arguments[0]:arguments,e="",f=0;f<d.length;f++)e+=(16>d[f]?"0":"")+d[f].toString(16);return e.toLowerCase()}var a=toNumbers("f655ba9d09a112d4968c63579db590b4"),b=toNumbers("98344c2eee86c3994890592585b49f80"),c=toNumbers("067c844a14decb238b6d8dda0e82b764");document.cookie="__test="+toHex(slowAES.decrypt(c,2,a,b))+"; expires=Thu, 31-Dec-37 23:55:55 GMT; path=/"; location.href="http://www.*******.byethost16.com/add.php?cb1=22&cb2=25&i=1";</script><noscript>This site requires Javascript to work, please enable Javascript in your browser or use a browser with Javascript support</noscript></body></html>
disconnecting.

But no data show at mysql database

phong06051993:
I have a arduino uno and ethernet shield.
I configure a web server with php files. If i write in my navigator www.*******.byethost16.com/?cb1=22.00&cb2=23 the data up correct to mysql.
I modified webcliend example to upload the data to mysql from arduino uno but not found.
it s the code

#include <SPI.h>

#include <Ethernet.h>

// Enter a MAC address for your controller below.
// Newer Ethernet shields have a MAC address printed on a sticker on the shield
byte mac = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };

// if you don’t want to use DNS (and reduce your sketch size)
// use the numeric IP instead of the name for the server:
//IPAddress server(74,125,232,128);  // numeric IP for Google (no DNS)
char server = “www.*******.byethost16.com”;    // name address for Google (using DNS)

// Set the static IP address to use if the DHCP fails to assign
IPAddress ip(192,168,1,57);

float temperatura=39;

// Initialize the Ethernet client library
// with the IP address and port of the server
// that you want to connect to (port 80 is default for HTTP):
EthernetClient client;

void setup() {
// Open serial communications and wait for port to open:
Serial.begin(9600);
 while (!Serial) {
  ; // wait for serial port to connect. Needed for Leonardo only
}

// start the Ethernet connection:
if (Ethernet.begin(mac) == 0) {
  Serial.println(“Failed to configure Ethernet using DHCP”);
  // no point in carrying on, so do nothing forevermore:
  // try to congifure using IP address instead of DHCP:
  Ethernet.begin(mac, ip);
}
// give the Ethernet shield a second to initialize:
delay(1000);
Serial.println(“connecting…”);

// if you get a connection, report back via serial:
if (client.connect(server, 80)==1) {
  Serial.println(“connected”);
  client.print(“GET /add.php?cb1=23&cb2=25”); // Enviamos los datos por GET
  //client.print(temperatura);
  client.println(" HTTP/1.1");
  client.println(“Host: www.*******.byethost16.com”);
  client.println(“User-Agent: Arduino 1.0”);
  client.println();
  Serial.println(“Conectado”);
 
 
}
else {
  // kf you didn’t get a connection to the server:
  Serial.println(“connection failed”);
}
}

void loop()
{
// if there are incoming bytes available
// from the server, read them and print them:
if (client.available()) {
 
  char c = client.read();
  Serial.print(c);
}

// if the server’s disconnected, stop the client:
if (!client.connected()) {
  Serial.println();
  Serial.println(“disconnecting.”);
  client.stop();

// do nothing forevermore:
  while(true);
}
}

[code]
and in serial monitor the arduino write
connecting…
connected
Conectado
HTTP/1.1 200 OK
Server: nginx
Date: Tue, 25 Oct 2016 09:28:04 GMT
Content-Type: text/html
Content-Length: 857
Connection: keep-alive
Vary: Accept-Encoding
Expires: Thu, 01 Jan 1970 00:00:01 GMT
Cache-Control: no-cache

This site requires Javascript to work, please enable Javascript in your browser or use a browser with Javascript support disconnecting.

But no data show at mysql database

Your code appears to working just fine, It sends a GET to your Server

  Serial.println("connected");
   client.print("GET /add.php?cb1=23&cb2=25"); // Enviamos los datos por GET
   //client.print(temperatura);
   client.println(" HTTP/1.1");

The Server Replies with a OK:

HTTP/1.1 200 OK
Server: nginx
Date: Tue, 25 Oct 2016 09:28:04 GMT
Content-Type: text/html
Content-Length: 857
Connection: keep-alive
Vary: Accept-Encoding
Expires: Thu, 01 Jan 1970 00:00:01 GMT
Cache-Control: no-cache

<html><body><script type="text/javascript" src="/aes.js" ></script>
<script>function toNumbers(d){
  var e=[];
  d.replace(/(..)/g,function(d){e.push(parseInt(d,16))});
  return e}
function toHex(){
  for(var d=[],
    d=1==arguments.length&&arguments[0].constructor==Array?arguments[0]:arguments,
    e="",
    f=0;
    f<d.length;
    f++)
   e+=(16>d[f]?"0":"")+d[f].toString(16);
   return e.toLowerCase()}
var 
 a=toNumbers("f655ba9d09a112d4968c63579db590b4"),
 b=toNumbers("98344c2eee86c3994890592585b49f80"),
 c=toNumbers("067c844a14decb238b6d8dda0e82b764");

document.cookie="__test="+toHex(slowAES.decrypt(c,2,a,b))+"; expires=Thu, 31-Dec-37 23:55:55 GMT; path=/";
 location.href="http://www.*******.byethost16.com/add.php?cb1=22&cb2=25&i=1";
</script>
<noscript>This site requires Javascript to work, please enable Javascript in your browser or use a browser with Javascript support</noscript>
</body></html>
disconnecting.

Based on this, your problem is on your Server, it is not executing the .php script. Or the .php script is non functional.

Chuck.

This is the response from the server.

This site requires Javascript to work, please enable Javascript in your browser or use a browser with Javascript support

The IDE ethernet library does not support Javascript.

SurferTim: This is the response from the server. The IDE ethernet library does not support Javascript.

@SurferTim, All the javascript does is create a cookie. I don't see anywhere that the 'cookie' is actually returned?

Chuck.

char server[] = "www.*******.byethost16.com";    // name address for Google (using DNS)

Does that REALLY look like google’s address? Why can’t you delete useless comments, or make them accurate useless comments?

Apparently, the host the OP is using requires Javascript to complete the mysql transaction, or it would not return this:

This site requires Javascript to work, please enable Javascript in your browser or use a browser with Javascript support

edit: And I don’t know what this Javascript file has in it.

<script type="text/javascript" src="/aes.js" ></script>

After creating the cookie, it sends the request back to the server.

 location.href="http://www.*******.byethost16.com/add.php?cb1=22&cb2=25&i=1";

SurferTim:
Apparently, the host the OP is using requires Javascript to complete the mysql transaction, or it would not return this:
edit: And I don’t know what this Javascript file has in it.

<script type="text/javascript" src="/aes.js" ></script>

After creating the cookie, it sends the request back to the server.

 location.href="http://www.*******.byethost16.com/add.php?cb1=22&cb2=25&i=1";

I did not realize that location.href() returned the cookie, I just thought it stored the location with the cookie on the ‘local’ webBrowser.

myBad.

I did one of those assumes :confused:

Chuck.