Webmaster Forum / Flash / Data Integration / October 2008

Hello,

You should put your test.jpg in a variable and echo that out to Flash as a URL
encoded string.  Like so...

echo "photo_out=test.jpg";

Then in Flash you assign photo_out to your startLoading function.

startLoading(_root.photo_out);

You should try getting familiar with using the LoadVars object.  With
loadVariables you can't successfully tell whether the variable has loaded into
Flash or not.  On some servers it's "hit or miss" and users could be left with
a long hangtime if variables haven't loaded.  LoadVars has an onLoad method
that takes care of that.

So if I was to use LoadVars in your code above - I'd do it like this...

// Create a LoadVars object
var lv = new LoadVars();

// Load the PHP file using the POST method
lv.load("test.php", POST);

// Test for a successfull load in Flash.  success is a boolean
// variable that returns true or false
lv.onLoad = function(success){
    if(success){
        // Access photo_out variable thru the LoadVars object (lv)
        // using dot syntax
        startLoading(lv.photo_out);
    } else {
        trace("Error loading");
    }
}

// Rest of code

Thank you so much for your effort with this. I followed your code, but I am not
uploading a photo - just name, address, phone, etc., so I followed your code to
the end of where you created the article variable and matched the dynamic text
fields to the php variables.

Below is the Flash error I get when I try to run it.

TypeError: Error #2007: Parameter text must be non-null.
    at flash.text::TextField/set text()
    at pageList/onComplete()
    at flash.events::EventDispatcher/dispatchEventFunction()
    at flash.events::EventDispatcher/dispatchEvent()
    at flash.net::URLLoader/onComplete()

Below is my onComplete function

function onComplete(event:Event):void
{
    var article:Object = event.target.data;
    first_tx.text = article.firstName;
    last_tx.text = article.lastName;
    address_tx.text = article.address;
    phone_tx.text = article.phone;
    email_tx.text = article.email;
    website_tx.text = article.website;
    occupation_tx.text = article.occupation;
    comments_tx.text = article.comments1;
}

Hello SmilingRoses,

I don't think the error is in the onComplete function.  I think it's something else.  It starts from a pageList function.  Can you post your full code here?

Thanks

I rechecked everything and reran it. Still doesn't work, but am getting
different error message. The pageList is one of the pages of the website I am
trying to put together. I will include the php code, the code on the pageList
page and the code on the main page followed by the error message in that order.
Thanks again for your time with this.

<?php
$con = mysql_connect('localhost', 'root', 'xxxxxxxxx');
 if (!$con) {die('Could not connect; ' . mysql_error($con));}
 mysql_select_db('sle',$con);

$sql = "select
firstName,lastName,address,phone,email,website,occupation,comments1 from form
where id=1";
$query = mysql_query($query);

while($row = mysql_fetch_assoc($query))
{
    $return = "firstName=".$row['firstName'];
    $return .= "&lastName=".$row['lastName'];
    $return .= "&address=".$row['address'];
    $return .= "&phone=".$row['phone'];
    $return .= "&email=".$row['email'];
    $return .= "&website=".$row['website'];
    $return .= "&occupation=".$row['occupation'];
    $return .= "&comments1=".$row['comments1'];
}
echo $return;
mysql_close($con);
?>

import flash.net.*;
import flash.display.*;
import flash.events.*;

var request:URLRequest = new
URLRequest("http://localhost/sle/listRequest.php");

var loader:URLLoader = new URLLoader();
loader.load(request);
loader.dataFormat = URLLoaderDataFormat.VARIABLES;
loader.addEventListener(Event.COMPLETE, onComplete);

function onComplete(event:Event):void
{
    var article:Object = event.target.data;
    first_tx.text = article.firstName;
    last_tx.text = article.lastName;
    address_tx.text = article.address;
    phone_tx.text = article.phone;
    email_tx.text = article.email;
    website_tx.text = article.website;
    occupation_tx.text = article.occupation;
    comments_tx.text = article.comments1;
}

// Scene 1 code /////////////////////////

import fl.transitions.Tween;
import fl.transitions.easing.*;
import flash.net.*;
import flash.media.Video;

// footer code /////

footer_mc.addEventListener(MouseEvent.MOUSE_OVER, over);
footer_mc.addEventListener(MouseEvent.MOUSE_OUT, out);

function over(e:MouseEvent):void
{
    footer_mc.gotoAndStop(2);
}

function out(e:MouseEvent):void
{
    footer_mc.gotoAndStop(1);
}

// title play button code //

play_btn.addEventListener(MouseEvent.CLICK, startAnim);
stop_btn.addEventListener(MouseEvent.CLICK, stopAnim);

function stopAnim(e:MouseEvent):void
{
    house_mc.stop();
}

function startAnim(e:MouseEvent):void
{
    house_mc.play();
}

// code for Menu Buttons //

var currentPage:MovieClip = home_mc;

var homePage:pageHome = new pageHome();
var formPage:pageForm = new pageForm();
formPage.stop();
var listPage:pageList = new pageList();
listPage.stop();
var marketPage:pageMarket = new pageMarket();
marketPage.stop();
var loginPage:pageLogin = new pageLogin();
loginPage.stop();
var chatPage:pageChat = new pageChat();
chatPage.stop();
var adsPage:pageAds = new pageAds();
adsPage.stop();
var funPage:pageFun = new pageFun();
funPage.stop();
var videoPage:pageVideo = new pageVideo();
videoPage.stop();

homePage.x = 76;
homePage.y = 292;
formPage.x = 92;
formPage.y = 290;
listPage.x = 500;
listPage.y = 330;
marketPage.x = 500;
marketPage.y = 380;
loginPage.x = 515;
loginPage.y = 425;
chatPage.x = 500;
chatPage.y = 508;
adsPage.x = funPage.x = videoPage.x = 500;
adsPage.y = funPage.y = videoPage.y = 550;

addChild(homePage);

highlight_mc.x = home_mc.x;
underline_mc.x = home_mc.x;

home_mc.targetMC = homePage;
form_mc.targetMC = formPage;
list_mc.targetMC = listPage;
market_mc.targetMC = loginPage;
chat_mc.targetMC = chatPage;
ads_mc.targetMC = adsPage;
fun_mc.targetMC = funPage;
video_mc.targetMC = videoPage;

home_mc.buttonMode = true;
form_mc.buttonMode = true;
list_mc.buttonMode = true;
market_mc.buttonMode = true;
chat_mc.buttonMode = true;
ads_mc.buttonMode = true;
fun_mc.buttonMode = true;
video_mc.buttonMode = true;

home_mc.addEventListener(MouseEvent.MOUSE_OVER, mUnderline);
form_mc.addEventListener(MouseEvent.MOUSE_OVER, mUnderline);
list_mc.addEventListener(MouseEvent.MOUSE_OVER, mUnderline);
market_mc.addEventListener(MouseEvent.MOUSE_OVER, mUnderline);
chat_mc.addEventListener(MouseEvent.MOUSE_OVER, mUnderline);
ads_mc.addEventListener(MouseEvent.MOUSE_OVER, mUnderline);
fun_mc.addEventListener(MouseEvent.MOUSE_OVER, mUnderline);
video_mc.addEventListener(MouseEvent.MOUSE_OVER, mUnderline);

function mUnderline(e:MouseEvent):void
{
    new
Tween(underline_mc,"x",Strong.easeInOut,underline_mc.x,e.currentTarget.x,.5,true
);
}

home_mc.addEventListener(MouseEvent.MOUSE_OUT, mUnderlineBack);
form_mc.addEventListener(MouseEvent.MOUSE_OUT, mUnderlineBack);
list_mc.addEventListener(MouseEvent.MOUSE_OUT, mUnderlineBack);
market_mc.addEventListener(MouseEvent.MOUSE_OUT, mUnderlineBack);
chat_mc.addEventListener(MouseEvent.MOUSE_OUT, mUnderlineBack);
ads_mc.addEventListener(MouseEvent.MOUSE_OUT, mUnderlineBack);
fun_mc.addEventListener(MouseEvent.MOUSE_OUT, mUnderlineBack);
video_mc.addEventListener(MouseEvent.MOUSE_OUT, mUnderlineBack);

function mUnderlineBack(e:MouseEvent):void
{
    new
Tween(underline_mc,"x",Strong.easeInOut,e.currentTarget.x,currentPage.x,.5,true)
;
}

home_mc.addEventListener(MouseEvent.CLICK, newPage);
form_mc.addEventListener(MouseEvent.CLICK, newPage);
list_mc.addEventListener(MouseEvent.CLICK, newPage);
market_mc.addEventListener(MouseEvent.CLICK, newPage);
chat_mc.addEventListener(MouseEvent.CLICK, newPage);
ads_mc.addEventListener(MouseEvent.CLICK, newPage);
fun_mc.addEventListener(MouseEvent.CLICK, newPage);
video_mc.addEventListener(MouseEvent.CLICK, newPage);

function newPage(e:MouseEvent):void
{
    new
Tween(highlight_mc,"x",Strong.easeInOut,highlight_mc.x,e.currentTarget.x,.5,true
);
    removeChild(currentPage.targetMC);
    currentPage = MovieClip(e.currentTarget);
    addChild(currentPage.targetMC);
}

///////// Flash Error /////////////////////////

Error: Error #2101: The String passed to URLVariables.decode() must be a
URL-encoded query string containing name/value pairs.
    at Error$/throwError()
    at flash.net::URLVariables/decode()
    at flash.net::URLVariables()
    at flash.net::URLLoader/onComplete()

I tried. It doesn't work.

Thanks for the code, very nice and useful