MySQL and Processing help, with $_SESSION

Programming Questions

harrison...

MySQL and Processing help, with $_SESSION

in Programming Questions • 3 years ago

Hey all i'm trying to create an app that will work when the user is logged in on my site and the session is started but im not sure what the syntax is for it in processing, at present the code runs when you boot from the local machine but I get class not found errors when I try to run it on the site, so I can't actually test it. Any ideas would be gratefully appreciated.

Thanks, Harrison

here is the problem block:

code:

if ( dbconnection.connect() )
{
// now read it back out
//
dbconnection.query( "SELECT score FROM players WHERE player_name = '{$_SESSION['player_name]'}" );
while (dbconnection.next())
{
dbscore = dbconnection.getInt("score");
if(dbscore < score)// if the db score is lower than the new we update it.
{
dbconnection.execute(" UPDATE players SET score ='"+score+"' WHERE player_name = '{$_SESSION['player_name]'}");
}
}
}
else
{
// connection failed !
}
}
}

Replies(4)

harrison...

Re: MySQL and Processing help, with $_SESSION

3 years ago

Oh just a thought would I need a session_start(); somewhere?

fjenett

Re: MySQL and Processing help, with $_SESSION

3 years ago

1)
You are mixing PHP with Processing / Java here. PHP variables and functions are not available inside Processing.

2)
Although it is possible to let an applet inside a HTML page connect to your database i wouldn't recommend it since you have to put your username and password into the applet (which can be read out by decompiling), plus your database has to allow access from everywhere. This is a big security risk.

The recommended way of doing this, which will solve your session problem as well, is to have a script (PHP/Perl/Ruby) inbetween the applet and the database.

harrison...

Re: MySQL and Processing help, with $_SESSION

3 years ago

Ah ok thankyou :) is there another libary to export data to a PHP script?

Many Thanks

PhiLho

Re: MySQL and Processing help, with $_SESSION

3 years ago

It depends on the kind of data. For simple data, just call the URL with GET parameters, it is enough to pass a couple of key/value pairs. For files, there is the postToWeb library.

Top Reply