MySQL Database Access (Flash)

[Dysan]

How do I access data from an MySQL database, and display the results in Flash?

[shlumph]

Make a call to a PHP page, that accesses the database, through flash. 

[HaLo2FrEeEk]

To my knowledge from my small amount of flash..ing, you need to parse a RSS or XML page, but I could be wrong.  I made a newsreader of sorts to show recent news from my site that would put the results, formatted, into a scrollbox that was inside a frame that looked like my site's layout.  I haven't done much flash so I could be incorrect, but that's what worked for me.  So what you should do is make a php page that outputs an xml doc (header: text/xml, I believe) and format it like a xml doc, and have the flash script parse that.  It's not as hard as it would seem, really, try it out.

[.josh]

Make a call to a PHP page, that accesses the database, through flash. 

 

Right.  You need to use a server side language (like php) to access and retrieve the info from the db and pass the results to flash.

[rondog]

Like crayon said use PHP to access the DB and then use flash's sendAndLoad method to get the data..or just send.

[.josh]

Like rondog said, use php.

 

[shlumph]

Here you go champ

public function postData() {
if(titleTxt.text != "" && descriptionTxt.text != "") {
	//Setup the Request and method (POST)
	var myData:URLRequest = new URLRequest("addEvent.php");
	myData.method = URLRequestMethod.POST;

	//Set up the POST variables
	var variables:URLVariables = new URLVariables();
	variables.title = titleTxt.text;
	variables.description = descriptionTxt.text;

	//Set the variables to the request
	myData.data = variables;

	var loader:URLLoader = new URLLoader();
	loader.dataFormat = URLLoaderDataFormat.TEXT;
	loader.load(myData);
} else {
	statusLabel.text = "Must enter Title and Description!";
}
}