Accessing MySQL

programming
1

Hello Everybody :]

Could you please help me ? (-:

this is what I have in my flash script >

package {

    import flash.events.EventDispatcher;
    import flash.events.HTTPStatusEvent;
    import flash.events.Event;
    import flash.net.*;

    public class Score extends EventDispatcher {

        public var output:String;
        private var object:* = this;

        public function submit(val:Array , url:URLRequest):void {

            url.method = URLRequestMethod.POST;

            var loader:URLLoader = new URLLoader();
            var vars:URLVariables = new URLVariables();
            for (var i:uint = 0; i < val.length; i++) {
                vars[val*[0]] = val*[1];
            }
            loader.data = vars;
            loader.dataFormat = URLLoaderDataFormat.VARIABLES;
            loader.addEventListener(HTTPStatusEvent.HTTP_STATUS, handler);
            loader.load(url);
        }
        private function handler(evt:HTTPStatusEvent):void {

            var loader:URLLoader = URLLoader(evt.target);
            if (loader.data.par == undefined && loader.data.msg == undefined) {
                output = "nothing yet";
            } else if (loader.data.msg == undefined) {
                output = loader.data.par;
            } else {
                output = loader.data.par +" - "+ loader.data.msg;
            }
            trace("Par: " + loader.data.par);
            trace("Message: " + loader.data.msg);
            object.dispatchEvent(new Event(Event.COMPLETE));
        }

    }
}

and this is php code

<?

$Name=$_POST['Name'];
$Score=$_POST['Score'];

//////////////////////////////////////

require ('dbLoginData.php');

//////////////////////////////////////

function makeConnection() {
// Connect to server and select databse.
$mysqli = new mysqli($GLOBALS[host], $GLOBALS[username], $GLOBALS[password], $GLOBALS[dbName]);
if (mysqli_connect_errno()) {
      printOutput(0, "Failed to login.");
 }else{
      printOutput(1, "Login successful.");
      $mysqli->query("INSERT INTO score (Name, Score) VALUES ($GLOBALS[Name], $GLOBALS[Score]) ");

//////////////////////////////////////


function printOutput($code, $msg){
print par=$code&msg=$msg;
}

makeConnection();
?>

in dbLoginData are placed my login details.

I think there is a problem in processing this php script, because when I include it into root script … it works. :puzzled:

Many thanks for eventually responses. :-]