• MySQL reading/writing in flash?
    13 replies, posted
A friend of my mom who owns a vacation place where you can rent houses and such, and he's asked me if I could make him an online calender where people could check if there's any free houses/rooms. I've though of making it in flash, for a more stylish finish and because it's easier for me, as a noob, to drag-and-drop in flash than learn advanced javascript/ajax. So, I'm looking for a tutorial on getting flash to read/write to a mysql database from flash. I haven't googled yet as I always ends up with some crappy tutorials, and you guys probably know a place to find a beginnerfriendly tutorial that I could use.
I know, I know but google is your best friend.
Flash sucks, do it in HTML + CSS + Javascript.
[QUOTE=andersonmat;20284422]Flash sucks, do it in HTML + CSS + Javascript.[/QUOTE] But flash is more beginner friendly, plus I suck at html/css and can't do anything in javascript. :l
[QUOTE=Tools;20284557]But flash is more beginner friendly, plus I suck at html/css and can't do anything in javascript. :l[/QUOTE] Not really, not at all. I'd much rather learn Javascript as a beginner than learn Action Script.
With flash alone you can't read/write to a sql server, you need a data access layer, probably PHP
Use PHP. It really isn't hard at all and PHP works nicely with flash.
you could use [URL="http://www.ultraapps.com/app_overview.php?app_id=19"]VCalendar[/URL] (free php calender system) i used to use it with my steam groups gaming nights
If the flash app itself could access the database you would be 5,000% vulnerable to getting hacked. They could just easily decompile then have access to your database.
[QUOTE=nivek;20303656]If the flash app itself could access the database you would be 5,000% vulnerable to getting hacked. They could just easily decompile then have access to your database.[/QUOTE] Well you could obfuscate it but people could still use network sniffers like Wireshark. It's possible to access a database from a Flash app but it's a really bad idea and you should rather communicate with a server-side application to handle the database modifications for you (for instance, a PHP script)
I know some awesome tutorials. I've never used flash for web programming but I saw them when i did some PHP[URL="http://www.youtube.com/user/flashbuilding"]. http://www.youtube.com/user/flashbuilding[/URL]
Don't. Flash isn't suited for this task.
[QUOTE=AMD 32;20387382]Don't. Flash isn't suited for this task.[/QUOTE] Excellent summary. I agree.
Alright, now for something useful :D You can use PHP/MySQL to do all the database work, and then pass the information to flash to make it all pretty and stuff. And you can use flash to pass data back through PHP to MySQL just as easy. After a quick trip to google: [url]http://www.google.com/search?q=flash+php+mysql[/url] I found a link to answer your very question, or at least point you in the right direction. [url]http://library.creativecow.net/articles/brimelow_lee/php_mysql.php[/url] My Recommendation: If you are very familiar with flash, this is easily doable. If you are not familiar with any of the concepts presented in the link, I would recommend a prebuilt framework as suggested in other replies.
Sorry, you need to Log In to post a reply to this thread.