hi... this is my first post ...
this is the code that i'm trying to build but error is there.
the flash is can't execute, so what should i do??
i need help.... please
package communication2{
import flash.display.MovieClip;
import flash.events.*;
import flash.text.TextField;
import flash.net.navigateToURL;
import fl.data.DataProvider;
// classes for server script connection
import flash.net.URLVariables;
import flash.net.URLRequest;
import flash.net.URLRequestMethod;
import flash.net.URLLoader;
import flash.net.URLLoaderDataFormat;
import flash.events.IOErrorEvent;
public class Communication2 extends MovieClip {
private var myRequest:URLRequest;
private var myVars:URLVariables;
private var myLoader:URLLoader;
// to keep things a little simpler, there is only traced error messages
// you may want to show the errors to the users...
// This code uses URLVariables for connection with a server
// in particular we connect through VARIABLES to PHP and MySQL as a database
// you can use the code to connect to TEXT and BINARY data too
public function Communication2() {
// set up the objects to send and receive data
myVars = new URLVariables();// this holds variables to send (as dynamic properties)
myRequest = new URLRequest();// this prepares the request for the loader
myRequest.url='http://www.yourserver.com/communication2.php';
myRequest.method=URLRequestMethod.POST;
myRequest.data=myVars;
myLoader = new URLLoader();// this is the loader that will send and receive
myLoader.dataFormat = URLLoaderDataFormat.VARIABLES;// could also be be TEXT or BINARY
myLoader.addEventListener(Event.COMPLETE, showGrid);
myLoader.addEventListener(IOErrorEvent.IO_ERROR, showError);
// get the initial data from PHP which gets the data from a database
getData();
// event on button to send submissions to the database
mySubmit.addEventListener(MouseEvent.CLICK, submitData);
}
function submitData(e:MouseEvent) {
if (firstName.text == "" || lastName.text == "" || fear.text == "") {
navigateToURL(new URLRequest("javascript:alert('Please enter all fields');"), "_self");
} else {
getData(firstName.text, lastName.text, fear.text);
firstName.text = lastName.text = fear.text = "";
}
}
function getData(myFirstName:String="", myLastName:String="", myFear:String="") {
myVars.firstName = myFirstName;
myVars.lastName = myLastName;
myVars.fear = myFear;
myLoader.load(myRequest);// this sends the variables and loads new data from php
}
private function showGrid(e:Event) {
// the data comes into the e.target.data property
// if the data is of the format URLLoaderDataFormat.TEXT then just use the data
// if the data is VARIABLES then convert the data into variable form like so:
var newVars:URLVariables = new URLVariables(e.target.data);
trace(newVars.simpleVariable);
if (newVars.error == 0) {
var myDataProvider:Array = [];
for (var i:uint=1; i<=newVars.total; i++) {
myDataProvider.push({firstName:newVars["firstName"+i], lastName:newVars["lastName"+i], fear:newVars["fear"+i]});
}
myGrid.columns = ["firstName", "lastName", "fear"];
myGrid.dataProvider = new DataProvider(myDataProvider);
myGrid.getColumnAt(0).headerText = "First Name";
myGrid.getColumnAt(0).width = 100;
myGrid.getColumnAt(1).headerText = "Last Name";
myGrid.getColumnAt(1).width = 100;
myGrid.getColumnAt(2).headerText = "Greatest Fear";
} else {
trace("There was an error in PHP");
}
}
private function showError(e:IOErrorEvent) {
trace("There was an error!");
}
}
}
#
# MySQL Table structure for table `fears`
# put this in the SQL box to quickly create the table
#
CREATE TABLE fears (
id int(11) NOT NULL auto_increment,
firstName text NOT NULL,
lastName text NOT NULL,
fear text NOT NULL,
date date NOT NULL default '0000-00-00',
PRIMARY KEY (id)
) TYPE=MyISAM;
<?php
$firstName = isset($_POST['firstName']) ? $_POST['firstName'] : "";
$lastName = isset($_POST['lastName']) ? $_POST['lastName'] : "";
$fear = isset($_POST['fear']) ? $_POST['fear'] : "";
$date = date("Y-m-d");
$error = 0;
// PRE-MAKE DATABASE
// go to phpmyadmin
// in a database called "database" - or whatever...
// login and make a table called "fears" with 5 fields
// id - make it an INT and autoincrementing and the key
// firstName - make TEXT
// lastName - make TEXT
// fear - make TEXT
// date - male Date
// OPEN DATABASE
// use your username and password
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("database",$db);
if ($firstName != "") {
// INPUT TO MYSQL
// create SQL query to insert any names and fears into the "fears" table
$query = "INSERT INTO fears (id, firstName, lastName, fear, date) VALUES ('', '$firstName', '$lastName', '$fear', '$date')";
// use PHP function to execute query. We use this function every time we
// want to access the database - for instance to add, delete or change something
$result = mysql_query($query,$db);
if (!$result) {
$error = "Sorry could not record fear";
}
}
// SERVER SCRIPT OUTPUT TO FLASH
// if we do not have to go to a database we can just send a variable to flash like so
echo "simpleVariable=simple value";
// OUTPUT TO FLASH
// this is how we handle sending variables back to Flash
// note that all name=value pairs are separated by &
$query = "SELECT * FROM fears";
$result = mysql_query($query,$db);
$total = mysql_num_rows($result);
$output = "";
if ($result) {
$i=0;
while ($myrow = mysql_fetch_array($result)) {
$i++;
$output .= "&firstName".$i."=".urlencode($myrow['firstName']).
"&lastName".$i."=".urlencode($myrow['lastName']).
"&fear".$i."=".urlencode($myrow['fear']);
}
} else {
$error = "Sorry could not access fears";
}
// send the data to Flash using the URL encoded format
echo "&total=".urlencode($total)."&error=".urlencode($error).$output;
?>
http://livedocs.adobe.com/flash/9.0/ActionScriptLangRefV3/fl/controls/DataGrid.html#DataGrid()
http://livedocs.adobe.com/flash/9.0/ActionScriptLangRefV3/
