Php mysql and flash "oh my"

Dev Shed Forums Sponsor:

December 28th, 2006, 07:46 PM

isus

Contributing User

Join Date: Nov 2006

Location: MI, USA

Posts: 83

Time spent in forums: 12 h 35 m
Reputation Power: 7

Php mysql and flash "oh my"

Okay here is the scoop. I would like to create a low level CMS using flash on the font end as a UI, and mysql as a database and php to connect the two. I have never done anything like this and I need a tutorial or some really good references that would explain the nuts and bolts really well from the ground up. I am pretty profecient with flash and I understand actionscript pretty well but writing it is pretty difficult for me. Basically if I see the code I understand how it works (for the most part) but to come up with the syntax is more of a problem. I've just started to look at php so I'm total noobie. I know what mysql is but I don't have any experience with accessing and I really don't understand how the database structure works. The other issue is that I'm not totally sure how dynamic websites are created with php. I understand the concept but it seems that there are a ton of code snipits placed in various directories that are pulled together to make the website happen, but its hard for me to parse out how it actually works without seeing a roadmap of sorts with some directions.

Any ideas on all this? I know its a lot but I'm wiling to learn and read a ton just need a good start.

thanks

January 5th, 2007, 10:02 AM

issamneo

a matrix member

Join Date: Apr 2004

Location: Tunisia

Posts: 176

Time spent in forums: 1 Day 13 h 38 m 11 sec
Reputation Power: 9

isus, what you ask isn't a small task it's a whole project;
i work on a CMS, but sorry i can't give you the code.
the idea is that you have flash for the part to interact with th user and php do the server side job.
to send and get variables from php use sendandload in flash it's not hard then everything is easy. for me i haven't use mysql i use xml it's better

so flash <==> php <==> XML

if you have any precise question

i'm here

__________________
THE MATRIX HAS YOU

-------------------------------
end transmission
-------------------------------

January 5th, 2007, 01:16 PM

isus

Contributing User

Join Date: Nov 2006

Location: MI, USA

Posts: 83

Time spent in forums: 12 h 35 m
Reputation Power: 7

How do you create an xml database, and is it secure?

January 5th, 2007, 01:37 PM

b3n

Prisoner of the Sun

Join Date: Jul 2004

Location: The Mews At Windsor Heights

Posts: 5,309

Time spent in forums: 2 Months 2 Weeks 4 Days 7 h 25 m 36 sec
Reputation Power: 2348

You should use a proper MySQL database. That means you don't have to worry about things like concurrent users, caching, etc because the DBMS deals with it automatically. It's also much easier and faster to search/sort/update your data.

When you use PHP to access the database, you can return your data to Flash as XML.

__________________
.

:: My blip.fm tunes :: Web Design Feeds :: Web Dev Feeds :: CheatSheets :: PHP :: MySQL :: 13 Moon FB App.

"All matter is merely energy condensed to a slow vibration. We are all one consciousness experiencing itself - subjectively. There is no such thing as death, life is only a dream. We are the imaginations of ourselves."
- Bill Hicks

"Truth is hidden in the subtle nature of the heart of everything, although it is invisible. One cannot see it from inside and neither from the surface. One can only live and experience it."
- Heart Sutra

January 5th, 2007, 02:09 PM

isus

Contributing User

Join Date: Nov 2006

Location: MI, USA

Posts: 83

Time spent in forums: 12 h 35 m
Reputation Power: 7

Quote:

Originally Posted by b3n

Doesn't this add another layer of complexity? Won't I need to convert my output and input so I will have flash-->xml-->php-->mysql and back.

January 8th, 2007, 10:19 AM

armands_pucs

Registered User

Join Date: Jan 2007

Posts: 2

Time spent in forums: 18 m 31 sec
Reputation Power: 0

i remember there wa

i remember there was another way of getting data from php to flash.

I if remember right flash can call the php file and get variables directly from it.

Or maybe I was just dreaming it

January 8th, 2007, 11:51 AM

b3n

Prisoner of the Sun

Join Date: Jul 2004

Location: The Mews At Windsor Heights

Posts: 5,309

Time spent in forums: 2 Months 2 Weeks 4 Days 7 h 25 m 36 sec
Reputation Power: 2348

Flash and PHP can talk to each other directly.

Flash uses LoadVars() to communicate with a php script:

actionscript Code:

Original - actionscript Code
var myLoadVars:LoadVars = new LoadVars(); myLoadVars.num1 = 5; myLoadVars.num2 = 3; myLoadVars.onload = function(success) { if (success) { trace(myLoadVars.answer); // 8 } } myLoadVars.sendAndLoad('script.php', _root.myLoadVars, 'POST');

 
var myLoadVars:LoadVars = new LoadVars();
myLoadVars.num1 = 5;
myLoadVars.num2 = 3;
 
myLoadVars.onload = function(success)
{
   if (success)
   {
      trace(myLoadVars.answer); // 8
   }
}
myLoadVars.sendAndLoad('script.php', _root.myLoadVars, 'POST');

So if your PHP script outputs:

PHP Code:


		
			
// script.php

$num1 = $_POST['num1'];

$num2 = $_POST['num2'];



$answer = $num1 + $num2;



print "&answer=$answer";

Hopefully you can see the possibilities.

Last edited by b3n : January 8th, 2007 at 02:41 PM.

January 8th, 2007, 01:34 PM

isus

Contributing User

Join Date: Nov 2006

Location: MI, USA

Posts: 83

Time spent in forums: 12 h 35 m
Reputation Power: 7

This is really helpful. It seems I'm going to be working on this project in my off time now. I've just been thrown some higher priority items at work, but I will be playing with flash and php at home. Thank you.

January 8th, 2007, 02:37 PM

b3n

Prisoner of the Sun

Join Date: Jul 2004

Location: The Mews At Windsor Heights

Posts: 5,309

Time spent in forums: 2 Months 2 Weeks 4 Days 7 h 25 m 36 sec
Reputation Power: 2348

It's also possible to use an XML object instead of a LoadVars object. You can point it at an xml file or to a php script that prints out xml. I think that's faster.

Last edited by b3n : January 8th, 2007 at 02:40 PM.

#10

January 9th, 2007, 02:48 AM

armands_pucs

Registered User

Join Date: Jan 2007

Posts: 2

Time spent in forums: 18 m 31 sec
Reputation Power: 0

Made a working example

I made a working example where flash takes a variable from PHP!

I hope this will be useful!

d01.megashares.com/?d01=68a65f5

#11

January 9th, 2007, 06:47 AM

isus

Contributing User

Join Date: Nov 2006

Location: MI, USA

Posts: 83

Time spent in forums: 12 h 35 m
Reputation Power: 7

Thank you, I'll give it a whirll.

#12

October 20th, 2007, 01:25 AM

edub9

Registered User

Join Date: Oct 2006

Posts: 2

Time spent in forums: 1 h 22 m 39 sec
Reputation Power: 0

Working example

Would I be able to download the source files?
I learn by taking things apart and visually so things are difficult for me.

Thanks,

Eric

Quote:

Originally Posted by armands_pucs

I made a working example where flash takes a variable from PHP!

I hope this will be useful!

d01.megashares.com/?d01=68a65f5

#13

October 20th, 2007, 08:03 PM

XenNetwork

Contributing User

Join Date: Aug 2004

Location: In the jungle with bicycle powered computers...

Posts: 213

Time spent in forums: 17 h 39 m 10 sec
Reputation Power: 8

This sorta thing is hard for someone who dosent know how certain aspects work, i would suggest making a php + mysql guest book as a way to learn how they both work, once you get that over with, you will be off to a great start.