# PHP output from MYSQL to populate Flash dynamic text field

**URL:** <https://forum.kirupa.com/t/php-output-from-mysql-to-populate-flash-dynamic-text-field/322832>\
**Category:** random\
**Created:** [June 5, 2011, 4:19am UTC](https://forum.kirupa.com/t/php-output-from-mysql-to-populate-flash-dynamic-text-field/322832 "2011-06-05T04:19:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![TheWayWeWere](https://avatars.discourse-cdn.com/v4/letter/t/e495f1/32.png) [@TheWayWeWere](https://forum.kirupa.com/u/TheWayWeWere)\
**Post date:** [June 5, 2011, 4:19am UTC](https://forum.kirupa.com/t/php-output-from-mysql-to-populate-flash-dynamic-text-field/322832/1 "2011-06-05T04:19:20Z")

</div>

[COLOR=black][SIZE=3][FONT=Calibri]Hello,[/FONT][/SIZE][/COLOR]  
[COLOR=black][FONT=Calibri][SIZE=3]I need help populating my flash form with data from mySQL via PHP.[/SIZE][/FONT][/COLOR]  
[COLOR=black][FONT=Calibri][SIZE=3][/SIZE][/FONT][/COLOR]  
[COLOR=black][SIZE=3][FONT=Calibri]I connect to the database okay. I am having a problem populating my flash fields. It’s a flash form with 7 dynamic text fields. I want to connect to the mysql database and bring to the flash form those fields from the database. There are over 100 rows so I want to be able to show one record on the form, then click a next button to show the next record.[/FONT][/SIZE][/COLOR]  
[SIZE=3][FONT=Calibri][COLOR=black]The[/COLOR] print “$Facct=$desiredContent[AccountNumber]”; gives me one account number displayed on the browser. But how do I get the “AccountNumber” to display on my dynamic text field variable named “Facct”? [/FONT][/SIZE]  
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3]Please keep in mind that I will need to do this for several dynamic fields on the form. The table has 100 records that I want to push to the flash form with a control button called “next” to see the next record. Currently when I run my flash swf that reads the PHP file on my server, the form opens blank. Please help.[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]  
[COLOR=black][FONT=Calibri][SIZE=3] [/SIZE][/FONT][/COLOR]  
[COLOR=black][SIZE=3][FONT=Calibri]In my movie clip I have:[/FONT][/SIZE][/COLOR]  
[COLOR=black][FONT=Calibri][SIZE=3] [/SIZE][/FONT][/COLOR]  
[COLOR=black][SIZE=3][FONT=Calibri]onClipEvent (load) {[/FONT][/SIZE][/COLOR]  
[COLOR=black][FONT=Calibri][SIZE=3]loadVariables("[/SIZE][/FONT][[FONT=Calibri][SIZE=3][COLOR=#0000ff]http://www.xyz.org/testdata.php[/COLOR][/SIZE][/FONT]](http://www.xyz.org/testdata.php)[SIZE=3][FONT=Calibri]", this, “GET”);[/FONT][/SIZE][/COLOR]  
[COLOR=black][SIZE=3][FONT=Calibri]}[/FONT][/SIZE][/COLOR]  
[COLOR=black][FONT=Calibri][SIZE=3] [/SIZE][/FONT][/COLOR]  
[COLOR=black][SIZE=3][FONT=Calibri]In my php file on my server I have:[/FONT][/SIZE][/COLOR]  
[COLOR=black][FONT=Calibri][SIZE=3] [/SIZE][/FONT][/COLOR]  
[FONT=Calibri][SIZE=3]\<?php[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3]//Make a MySQL Connection[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3]$connection = mysql\_connect(“localhost”, “xyz”, “pswd”) or die(mysql\_error());[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3]mysql\_select\_db(“xyz\_database”) or die(mysql\_error());[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] echo “Connected to Database\<br /\>”; [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3]//$query = ‘SELECT \* FROM account’;[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3]//$results = mysql\_query($query);[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3]////test to get accountnumber from the database[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] $query = “SELECT AccoutNumber FROM account”;[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] $result = mysql\_query($query) [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] or die("\<b\>error\</b\>: failed to execute query \<i\>$query\</i\>");[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] $desiredContent = mysql\_fetch\_array($result, MYSQL\_ASSOC);[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] mysql\_free\_result($result);[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3]//facct is the name of my dynamic text field [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] print “$Facct=$desiredContent[AccountNumber]”;[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3]//close connection[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] mysql\_close($connection);[/SIZE][/FONT]  
[FONT=Calibri][SIZE=3] [/SIZE][/FONT]  
[FONT=Calibri][SIZE=3]?\>[/SIZE][/FONT]