# Pulling data from mysql db in AS3

**URL:** <https://forum.kirupa.com/t/pulling-data-from-mysql-db-in-as3/261789>\
**Category:** flash\
**Created:** [May 30, 2008, 8:44pm UTC](https://forum.kirupa.com/t/pulling-data-from-mysql-db-in-as3/261789 "2008-05-30T20:44:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sharkb8](https://avatars.discourse-cdn.com/v4/letter/s/977dab/32.png) [@sharkb8](https://forum.kirupa.com/u/sharkb8)\
**Post date:** [May 30, 2008, 8:44pm UTC](https://forum.kirupa.com/t/pulling-data-from-mysql-db-in-as3/261789/1 "2008-05-30T20:44:22Z")

</div>

How do you pull data from a mysql database in AS3?

---

<div class="post-metadata">

**Author:** ![rbnzdave](https://avatars.discourse-cdn.com/v4/letter/r/a587f6/32.png) [@rbnzdave](https://forum.kirupa.com/u/rbnzdave)\
**Post date:** [May 30, 2008, 11:09pm UTC](https://forum.kirupa.com/t/pulling-data-from-mysql-db-in-as3/261789/2 "2008-05-30T23:09:09Z")

</div>

I’d suggest using an xml file made by php. are you okay with php ?

---

<div class="post-metadata">

**Author:** ![dail](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@dail](https://forum.kirupa.com/u/dail)\
**Post date:** [May 31, 2008, 12:55am UTC](https://forum.kirupa.com/t/pulling-data-from-mysql-db-in-as3/261789/3 "2008-05-31T00:55:14Z")

</div>

You would use something like this to reference a php file;

```auto
package {
	import flash.display.*;
	import flash.net.URLVariables;
	import flash.net.URLLoader;
	import flash.net.URLLoaderDataFormat;
	import flash.net.URLRequest;
	import flash.net.URLRequestMethod;
	import flash.net.URLRequest;
	import flash.events.*;

	public class QueryDataBase extends Sprite {
		
		public static const DATA_ACCESSED:String = "dataaccesed";

		public function QueryDataBase() {

			var myData:URLRequest = new URLRequest("get.php");
			myData.method = URLRequestMethod.GET;
			var variables:URLVariables = new URLVariables();
			myData.data = variables;
			var loader:URLLoader = new URLLoader();
			loader.dataFormat = URLLoaderDataFormat.VARIABLES;
			loader.addEventListener(Event.COMPLETE, dataOnLoad);
			loader.load(myData);
		}
		private function dataOnLoad(event:Event):void {
			trace(event.target.data)
                        dispatchEvent(new Event(QueryDataBase.DATA_ACCESSED, true));
		}
	}
}

```

Then, of course you need a php file, that will parse your database, and return something. Depending on your needs, you could just use a string, or get PHP to return an XML doc. You can probably change the class to extend something other than sprite. That was a snippet of some other larger, class.

---

<div class="post-metadata">

**Author:** ![sharkb8](https://avatars.discourse-cdn.com/v4/letter/s/977dab/32.png) [@sharkb8](https://forum.kirupa.com/u/sharkb8)\
**Post date:** [May 31, 2008, 5:46am UTC](https://forum.kirupa.com/t/pulling-data-from-mysql-db-in-as3/261789/4 "2008-05-31T05:46:00Z")

</div>

Thank you Dail. I’ll give this a try. I’m fairly new to php but I love learning it and was wondering how to pull data from mysql. AS3 has change dramatically the last time I dove into it. Now I can try to bridge the 2. I was trying to pass the info via JS.

So ideally I should be processing a xml file. would this method work if I wanted to process a xml file?

---

<div class="post-metadata">

**Author:** ![Alex\_Lexcuk](https://avatars.discourse-cdn.com/v4/letter/a/919ad9/32.png) [@Alex\_Lexcuk](https://forum.kirupa.com/u/Alex_Lexcuk)\
**Post date:** [May 31, 2008, 6:56am UTC](https://forum.kirupa.com/t/pulling-data-from-mysql-db-in-as3/261789/5 "2008-05-31T06:56:25Z")

</div>

[http://www.google.ru/search?q=AS3+MySQL](http://www.google.ru/search?q=AS3+MySQL)