Load URLs Loadstrings help!

Programming Questions

harrison...

in Programming Questions • 2 years ago

Hey all, I couldn't be more confused, I'm tying to get processing to load up a php script and send the int vaule of score to it but it's kicking out an error about the url, here is the code, the php and the error msg:

{
loopcheck2 = 1;
String url ="score.php" + score; // i've tried my site as the url "www.epiphanystudios.co.uk/score.php" still get errors
loadStrings(url);
}
error: The file "score.php1" is missing or inaccessible, make sure the URL is valid or that the file has been added to your sketch and is readable.

here is the PHP:

<?php
session_start();
$score = $_GET['score'];
$connect = mysql_connect('','',''') or die("couldn't connect");
mysql_select_db("test")or die("can't find ya database fool!");
$query = ("SELECT rank FROM players WHERE player_name = '{$_SESSION['player_name']}'");
$dbscore = mysql_query($query);
if($score > $dbscore)
{
mysql_query("UPDATE score SET score = '$score'
WHERE player_name = '{$_SESSION['player_name']}'");
}
?>

Any ideas would be greatly appreciated :D

Harrison.

Replies(8)

blindfish

Re: Load URLs Loadstrings help!

2 years ago

Well assuming your applet is local to the PHP page then it should probably be:

String url ="score.php?score=" + score;

I guess you may need to pass some other URL VARS too, depending on what your PHP is doing...

But even then I think you may have a bit of a problem. loadStrings() is designed specifically to handle text files; whereas from the full URL you post all I see is some HTML. Sure that is effectively a text file; but you may have to do extra work to parse it...

harrison...

Load URLs Loadstrings help!

2 years ago

I've tried that for the string url still isn't working, Im really stuck, all i want it to is pass on the score value to a PHP script and PHP handles it all from there, is there another way I could do this?

blindfish

Re: Re: Load URLs Loadstrings help!

2 years ago

'still isn't working' isn't particularly descriptive. If you're still getting the url not found error then do as phi.lho suggested and use the full url; and then make sure you pass the URL VARS correctly. If your database isn't getting updated then it's more likely your PHP or database setup. It should be easy enough to test if loadStrings() is working as it should: just set up a PHP page that echos back the URL VAR and println the result of loadStrings in your sketch...

PhiLho

Re: Load URLs Loadstrings help!

2 years ago

Put the full URL: http://www.epiphanystudios.co.uk/score.php
Obviously, the PHP should return simple values, no HTML.
Side remark:
$query = ("SELECT rank FROM players WHERE player_name = '{$_SESSION['player_name']}'");
is perfect for a SQL injection, where malicious people can alter your database by forging special names...
See the infamous xkcd: Exploits of a Mom for a good example...

harrison...

Re: Load URLs Loadstrings help!

2 years ago

Sorry for not being descriptive im still getting the same error, I'll try your suggestive when Im home, also thank you phi.Iho for the remark, i'll sort that out soon.

Thank You both very much.

harrison...

Re: Load URLs Loadstrings help!

2 years ago

Hmm I'm wondering if I could just present a link for the person to click on and then send the score to the the linked page which would be a PHP/Html page?

blindfish

Re: Load URLs Loadstrings help!

2 years ago

Well - I just tested this out and loadStrings works just fine at passing a variable to a PHP script via a URL_VAR. If you're having issues then I guess it's with your database injection... So whether you're passing that variable from a link someone clicks on or abusing loadStrings you're still going to have the same problem.

Here's my code for reference; though there's nothing new here:

void setup() {
size(100,100);
String url = "[full path to web folder]/index.php?input=whatever";
String foo[] = loadStrings(url);
// prints: [0] "whatever"
println(foo);
}

PHP code is just:

<?php echo $_GET["input"]; ?>

harrison...

Re: Re: Load URLs Loadstrings help!

2 years ago

Wonderful thank you so much

Top Reply