Groups | Blog | Home
all groups > flash data integration > march 2006 >

flash data integration : Display an SQL column in flash


Raj_Sol
3/1/2006 12:00:00 AM
Hi,

Im having a bit of difficulty displaying an entire column from an SQL table in
flash.
I have a dynamic text field and a php script which runs a particular select
query. It is the result of this select query that i wish to display within the
dynamic text field.
If anyone can give me a pointer or a tip on how to do this, it would be very
much appreciated.

Thanks

Raj S
Motion Maker
3/1/2006 11:32:05 AM
Use XML or LoadVars in Flash to receive the data from PHP. Their onLoad
methods provide the data from the PHP script and you can update any object
in your Flash movie.

The examples in the Flash help are great. You just have to change to use a
PHP script. PHP you use echo to return values using the formatting for
either LoadVars (URL Vars) or XML.

For LoadVars look at:
http://livedocs.macromedia.com/flash/8/main/00002336.html

For XML look at: http://livedocs.macromedia.com/flash/8/main/00002879.html

If want here are some basic examples I provide to students in my Flash
seminars and programs:
Basic LoadVars and PHP
http://www.hosfordusa.com/ClickSystems/courses/flash/examples/LoadVars/LoadVarsEx01.php
LoadVars PHP and MySQL and DataGrid component
http://www.hosfordusa.com/ClickSystems/courses/flash/examples/XMLPHPMySql/Ex01/XMLPHPMySQLEx01_Doc.php
Basic XML and PHP
http://www.hosfordusa.com/ClickSystems/courses/flash/examples/XMLPHP/EX01/XMLPHPEchoEx01_Doc.php
XML PHP and MySQL and DataGrid component
http://www.hosfordusa.com/ClickSystems/courses/flash/examples/XMLPHPMySql/Ex01/XMLPHPMySQLEx01_Doc.php
--
Lon Hosford
www.lonhosford.com
May many happy bits flow your way!
[quoted text, click to view]
Hi,

Im having a bit of difficulty displaying an entire column from an SQL table
in
flash.
I have a dynamic text field and a php script which runs a particular select
query. It is the result of this select query that i wish to display within
the
dynamic text field.
If anyone can give me a pointer or a tip on how to do this, it would be
very
much appreciated.

Thanks

Raj S

AddThis Social Bookmark Button