Last couple of month was working on Flash. Became familiar with Flash and started loving it… 
Then a project came they
asked for making CMS for their flash site. You can see the site http://www.zfp.com
And the game started…
Started learning AS2 and loadvars. Faced lots of difficulties and finally manged to communicate with Flash(AS2) + PHP + Mysql.
In this post I will try to give basic idea to communicate Flash(AS2) and PHP.
1. Flash(AS2)
lv_th = new LoadVars();
lv_th.onData = function(varText:String)
{
temp = varText.split(‘@@’);
photo= temp[0].split(‘|’);
photo_title = temp[1].split(‘|’);
photo_description = temp[2].split(‘|’);
};
lv_th.load(“photo_gallery.php?gallery_id=5″);
1. PHP+MySql
$gal_id = $_GET['gallery_id'];
$sql = "SELECT * FROM gallery WHERE gal_id=$gal_id ORDER BY gal_id";
$result = mysql_query($sql) or die(mysql_error());
$photo = array(); $photo_title = array(); $photo_description = array();
while($rows = mysql_fetch_object($result))
{
$photo[] = $rows->photo;
$photo_title[] = $rows->title;
$photo_description[] = $rows->description;
}
print implode('|',$photo) . '@@' . implode('|',$photo_title) . '@@' .
implode('|',$photo_description);
First one is flash AS2 Code to get the data from php. It first create a new instance LoadVars();
then onload called the photo_gallery.php?gallery_id=5 and wait for the response to come.
In php we made the query based on the gallery_id and get the data and put it in three separate
array. then we implode each array values with ‘|’ and separate each array with ‘@@’.
In flash after getting the data as a string in varText variable we split it by ‘@@’ to separate the
different array values and after that separte it in ‘|’ to get each value. Now we have all the data
in photo, photo_title and photo_description array. Use the array values as you want….
Note: In the data there should not be ‘@@’ or ‘|’. If it contains then you have to choose the separator carefully. Choose a separator which is not come as data.
Have fun with flash + php + MySql….. 
loading...
loading...
