Processing Forum

Screen name:
bcnupdate

bcnupdate's Profile

1 Posts

1 Responses

0 Followers

Activity Trend

Last 30 days

Loading Chart...

Show:

Expanded view
List view

[BezierSQLib] Send the value of a variable to a MySQL database

[2 Replies]
- 22-Dec-2012 10:36 AM
- Forum: Contributed Library Questions
Hello.

I'm a Processing newbie and I've made some code to get the values from a LM35 temperature sensor connected to an Arduino UNO board.

I want these values to be sent to a MySQL database, and I'm using the SQL library to do so.

That's the code I'm using:
1. import processing.serial.*;
  import cc.arduino.*;
  import de.bezier.data.sql.*;
  
  Arduino arduino;
  MySQL database;
  int sensorTemp = 2;
  float sensorValue = 0;
  
  void setup()
  {
  arduino = new Arduino(this, Arduino.list()[0]);
  arduino.pinMode(sensorTemp, Arduino.INPUT);
  
  String user = "root";
  String pass = "";
  String database = "data-arduino";
  
  database = new MySQL(this, "localhost", database , user , pass);
  }
  
  void draw()
  {
  sensorValue = (5.0 * arduino.analogRead(sensorTemp) * 100.0) / 1024.0; // read the value and make the conversion
  
  println(sensorValue);
  
  if ( database.connect() )
  {
  database.execute("INSERT INTO `data-arduino`.`temperature` (`TEMPERATURE`) VALUES ('sensorValue');");
  }
  else
  {
  println("Error in the connection :-( ");
  }
  
  delay(300000); // Wait 5 minutes
  }
The problem is that with this code, I send the name of the variable (sensorValue) to the MySQL database, but what I want to send to the MySQL database is the value of the variable, not the name.

What do I have to do to send the value of the variable and not the name of it to a MySQL database?

Thank you.

(And sorry for my English)

«Prev
Next »