Hello, I need to send some data to a web page in the internet i was checking this Project Proposal viewtopic.php?f=10&t=4254&p=16000&hilit=get+method#p16000
using the get method, this example use a pachube key I’m not very sure about it.
I’m trying to send the input from arduino with shield grps v1.0 to a DB using php,
the field that I need send with arduino are, “bit” and “nota”
Php source code
<?php
if ($_GET[“bit”] || $_GET[“nota”])
// put your code here
{
$var1 = $_GET[“bit”];
$var2 =$_GET[“nota”];
echo "Welcome “. $_GET[“bit”].”
";
echo "You are ". $_GET[“nota”].“years old”;
echo $var1;
echo $var2;}
//conexión a la base de datos
$con = mysqli_connect(“mysql.xxxxxxxxxxxx”, “123_jorge”, “xxxxx”, “db_1”);
if (mysqli_connect_errno()){
echo “No se pudo conectar a la base de datos” . mysqli_connect_error();
}
//obtiene valores del formulario
$bit = mysqli_real_escape_string($con, $var1);
$nota = mysqli_real_escape_string($con, $var2);
//insertamos los valores del formulario en nuestra bd
$sql = “INSERT INTO trackflesa (bit, nota)
VALUES (’$bit’, ‘$nota’)”;
if (!mysqli_query($con,$sql)) {
die('Error: ’ . mysqli_error($con));
} else{
echo "Registro guardado exitosamente";
}
?>
I tried with at command
mySerial.println("AT+HTTPPARA=“URL”,“http://gpsguate.esy.es/phpproject/agregaflesa.php?bit=0¬a=_1"”)
But id doesn’t work for me, because this is to read and not to write.
I was reading there is a way using a TCP but I don’t know how to do it and AT+CIPSEND command but not working for me.
Any idea how to do it will be apreciate to much!, thanks in advance.