Flash, PHP, MySQL Integration Example Tutorial

New Channel: http://www.youtube.com/BokoNOM

Category:

Howto & Style

Tags:

• flash
• php
• mysql
• sql
• my
• integration
• help
• tutorial
• support
• as2
• as3
• dynamic
• register
• registration
• login
• script
• database
• parse
• loadVars
• vars
• load
• sendAndLoad
• send
• and
• get
• method
• query
• nu
• cora
• nucora
• boko
• insctructions
• editing
• technology
• electronics
• howto
• how
• to
• software
• computers
• internet
• website
• web
• site
• security
• optimization
• cat
• cats
• lol
• bored
• kittens
• meow

[YDProductionz]

All you used is PHP my admin or more stuff?

[linkinpark9sc]

@YDProductionz phpMyAdmin for the db, yes. You need PHP support to access it though and the scripting to integrate. Can be done locally or on a web server (most paid/free ones have PHP/MySQL support). Something I forgot to mention in this tutorial which I will do later on my other channel 'Bokonom' is the inclusion of a policy file in order to interact with the db through flash when not local.

[spazl7]

What version of PHP is this for? My server only supports PHP5...

[linkinpark9sc]

@spazl7 I used PHP5 in this tutorial, it really doesn't matter whether you use PHP4/5, don't think I used any functions which limit the use to PHP5.

[minifrij]

it wont register my user D:

[linkinpark9sc]

@minifrij I can't really be of any help with a lack of info. Do you get any error? Have you tried browsing to the PHP files to see if you get any error in those? (Or check your error log on the FTP server if you have logging enabled). As long as you have a server whether it's local or not and it supports PHP/SQL this guide will work, make sure you followed it correctly. I can help with anything you feel unsure on, but I'm not on this account very often anymore.

[BokoNOM]

@TableWolfMusic lol yep, boko is my new account but I havn't made tutorials for a while, might start up again in future.

[TableWolfMusic]

@BokoNOM Erm... Thanks for the reply although I am confused now. Are @BokoNOM and @linkinpark9sc the same person?

[BokoNOM]

@TableWolfMusic Yep, you would encrypt it before sending it over. I havn't explained that here because the tutorial is intended to be basic, security is another matter.

[TableWolfMusic]

@linkinpark9sc Pausing at 5:46 are you using the GET method to parse the variables from flash to PHP, rather than the POST method? I'm guessing there would be a security issue by parsing the username and password as plain text in the URL by using the inapproriate method?

[YDProductionz]

I recommend you actually make a website that has a login/password BEFORE doing it in flash. TRUST ME

[mkurza]

worked using as2.0 in flash Cs5.

used different database entries and it didnt work at first, just make sure you doublecheck everything twice over.

i have a very odd question though. If i run this script through my PS3 browser it seems to make its very own unique ids that can only be logged into by the ps3.

otherwise the script works great.

[YDProductionz]

@linkinpark9sc I was wondering because i see you uploaded the files you created and i tried to upload via 000webhost and i get some error message saying access denied, with password(YES)

[spazl7]

@linkinpark9sc Ok cool, I am going to give it a try today. I had a script that was all functional until my server was upgraded to PHP5 and now nothing works.... so yeah here I am