MySQL Connection

Integration and Hardware

morrow.li..

in Integration and Hardware • 2 years ago

How do I take information from a table in mysql and insert it into a variable in processing.

Heres my attempt:

Thanks,

msql = new MySQL( this, dbHost, database, user, pass );
if ( msql.connect() )
{
msql.query( "SELECT Size FROM circles" );
radius=msql.getInt(Size);
println(radius);
for(int i=0; i<2; i++){
num=random(1,10);

Replies(3)

PhiLho

You should take a look at the examples coming with the library, it is often useful.
You have to use msql.next() to get the next row of information. Usually programs loop on this call to get all the rows, or use a more specific request to get only one.
Also I don't know what you have in your Size variable. It might contain "Size" (a string) or 1 (first column of the request).

morrow.li..

Re: MySQL Connection

2 years ago

I have been using an example. Size is a column in my table, that I wish to take information from. Here's the full code. I'm able to insert a declared variable into my table. I just want to know how to do the opposite.

import de.bezier.data.sql.*;
MySQL msql;
float num;
int Size;
float radius;
void setup()
{
size( 500, 500 );
String user = "sketchyg_proc";
String pass = "112288";
String dbHost = "localhost";
String database = "sketchyg_parametrics";
msql = new MySQL( this, dbHost, database, user, pass );
if ( msql.connect() )
{
msql.query( "SELECT Size FROM circles" );
radius=msql.getInt(Size);
println(radius);
for(int i=0; i<2; i++){
num=random(1,10);
msql.execute( "INSERT INTO circles (Size) VALUES ("+num+");" );
}
}
else
{
println( "FAIL" );
}
}
void draw()
{
ellipse(width/2,height/2,radius*10, radius*10);
}

PhiLho

Re: MySQL Connection

2 years ago

Read again my answer, please.

Top Reply