MySQL Forums :: Connector/Arduino :: Arduino MySQL Connector Select Query- How to access individual values


Advanced Search

Arduino MySQL Connector Select Query- How to access individual values
Posted by: Patrick LAFFORGUE ()
Date: January 25, 2015 04:42AM

Hello,

thanks for this helpfull and usefull Arduino MySQL Connector.
I try to command LEDs on an Arduino board from a HTML page using a PHP script and a MySQL Database. I succeed in updating the MySQL Database, reading it with Arduino board and displaying the pin states on the serial monitor. But I didn't succeed in accessing the individual pin state. Where is my mistake ?

Thanks in advance for your help.

Best regards.

Here is the concerned part of the code :

int Pin0, Pin1, Pin2, Pin3, Pin4, Pin5 ;

.......

if (r)
{
rows++;
for (int i = 0; i < num_cols; i++)
{
Serial.print(r->values);

if (i == 0) Pin0 = atoi(r->values[0]) ;
if (i == 1) Pin1 = atoi(r->values[1]) ;
if (i == 2) Pin2 = atoi(r->values[2]) ;
if (i == 3) Pin3 = atoi(r->values[3]) ;
if (i == 4) Pin4 = atoi(r->values[4]) ;
if (i == 5) Pin5 = atoi(r->values[5]) ;
else break ;
}

my_conn.free_row_buffer(); // Free the row buffers
}
} while (r);

Serial.println() ;
Serial.print(rows);
Serial.println(" rows in result");

Serial.println(Pin0);
Serial.println(Pin1);
Serial.println(Pin2);
Serial.println(Pin3);
Serial.println(Pin4);
Serial.println(Pin5);

Options: ReplyQuote


Subject Views Written By Posted
Arduino MySQL Connector Select Query- How to access individual values 3029 Patrick LAFFORGUE 01/25/2015 04:42AM
Re: Arduino MySQL Connector Select Query- How to access individual values 1139 Charles Bell 01/28/2015 02:47PM
Re: Arduino MySQL Connector Select Query- How to access individual values 1044 Patrick LAFFORGUE 02/02/2015 02:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.