PHP Flash High Score Tutorial

[iambubbathedog]

Link to website?

[projectfinale]

@iambubbathedog projectfinale(dot) com haha I dont have a written tutorial up unfortunately... I need to make a better tutorial for this still

[blakeleypaul]

Hi there, your video is great, but I'm using AS3, any idea how I can convert your tutorial into AS3?

[TheKorostudio]

Thanks man but Um do you have a way to make a flash to send a score to an e-mail

or even just send a word but not like a the things that you can input .

could anyone please tell me

[jastruss]

Great tutorial. I forgot to select the table too.

[Sabooru]

Hey I used your code but I keep getting errors

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [filepath].scores on line 9

I've connected my database and made the for loop.

I think it has problems with if($line = mysql_fetch_assoc($results)){

I get $line an undefined variable when I play around

Any such luck? Going to look at your other videos now

[projectfinale]

If you check, I failed to add in the connect to database in the code, because i was filling in my own... so add this code and it should work fine...

$link = mysql_connect(SERVER,USERNAME,­PASSWORD);

mysql_select_db(DATABASE NAME);

Add those lines in at the top of the PHP code and it should work fine, fill in the all caps variables first

[Sabooru]

I've already connected properly to the database. I played around with it initially and got disconnected errors so I returned it to the way it was and the errors disappeared so I am connected to the database I'm pretty sure

[Sabooru]

is $line an undefined variable?

[projectfinale]

it shouldn't be... It is being set to the results... It should equal 1 if it is returned correctly... which would make it go through the while loop...

it works fine for me still... the only think i could think of is to set it to 0 above...

$line = 0;

just put it at the top so it is initialized... otherwise i would look up the error in google and see what results you get

[Sabooru]

ah i just figured it out. When I connected to mySqlAdmin I connected correctly there but I'd put the name of the table in where the name of the database should have been and it screwed everything up. It works perfectly now :) going to move on to the next part of the tutorial

[Sabooru]

actually should mySql close connection be used after the scores have been received?

mysql_close - or is it unimportant because its not a persistent connection?

[projectfinale]

I apologize for the late response, I didn't notice you replied again... I think to be on the safe side, you should always close a connection, but I will admit that I don't do it half the time and haven't run into any major problems.

[steinbergur]

Hey Babeee!

Can you tell me how I put score from flash game into mysql ? .... btw. I know PHP and mysql. Just thinking how I do it in Flash

maybe can u tell me also how I connect Online User into the Flash? Like Automatic insert when he-she top the highscore?

[projectfinale]

yup no problem, ill post a second video in the next few days :)

[steinbergur]

@projectfinale

THANKS!

Can you Reply this comment when u have uploaded ?

[projectfinale]

hey, new video is up, enjoy!