am connecting flash with mysql database
but not able to get proper variable value.
i want output "connected"
by defining
var s = evt.target.data.server;
also can someone explain me more about these two i.e.
//loader.dataFormat = URLLoaderDataFormat.VARIABLES;
//loader.dataFormat = URLLoaderDataFormat.TEXT;
am getting sometime value i.e.
connected <br> etc .........why am getting html code in it? any idea
Thanks
---------------------------
php connection i.e.
PHP Code:
<?php
/** MySQL database username */
define('DB_NAME', 'nippers');
define('DB_USER', 'root');
define('DB_PASSWORD', 'admin');
define('DB_HOST', 'localhost');
$output .="<loginserver>";
$connect = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die(mysql_error());
if (!$connect)
{
$output .= "Not Connected";
//die('Could not connect: ' . mysql_error());
}
else
{
$output .= "Connected";
//echo "Connected to MySQL<br />";
}
// some code
//mysql_close($con);
$returnVars .="server = connected ";
$output .= "</loginserver>";
// print ($output);
print ($returnVars);
//Selecting database
$select_db = mysql_select_db(DB_NAME, $connect);
if(!$select_db){
die(mysql_error());
}
?>
AS3 code i.e.
Actionscript Code:
import flash.display.MovieClip;
import flash.events.Event;
import flash.net.URLLoader;
import flash.net.URLRequest;
import flash.net.URLRequestMethod;
import flash.text.TextField;
import flash.events.IOErrorEvent;
import flash.net.URLLoaderDataFormat;
function Main() {
//var myXML:XML = new XML();
var myXML_URL:String;
var url:String = "http://localhost/score/add/database.php";
var _var:URLVariables = new URLVariables();
var request_url:URLRequest = new URLRequest(url);
var loader:URLLoader = new URLLoader(request_url);
//loader.dataFormat = URLLoaderDataFormat.VARIABLES;
//loader.dataFormat = URLLoaderDataFormat.TEXT;
//request_url.data = myXML.toXMLString();
request_url.method = URLRequestMethod.GET;
//request_url.data = _var;
//request_url.contentType = "text/xml";
loader.addEventListener(Event.COMPLETE, completeHandler);
loader.addEventListener(IOErrorEvent.IO_ERROR, onIOError);
loader.addEventListener(SecurityErrorEvent.SECURITY_ERROR, secerror);
_var.server = server.text;
loader.load(request_url);
function completeHandler(evt:Event) {
//var data:URLVariables = new URLVariables( loader.data );
//trace( data.filesize );
//var _loader:URLLoader = URLLoader(evt.target);
//trace ("value: "+_loader.data.output);
//myXML = XML(loader.data);
//trace ("value: "+ myXML);
var s = evt.target.data.server;
trace ("value: "+ s);
nowstatus.text = s;
}
function onIOError(event:IOErrorEvent):void {
trace("Error loading URL.");
}
function secerror(event:SecurityError) {
nowstatus.text = event.message;
}
try {
loader.load(request_url);
}
catch (error:IOError) {
nowstatus.text = "error: " + error.message;
}
catch (error:Error) {
nowstatus.text = "error: " + error.message;
}
}
Main();