package { import flash.display.MovieClip;
import flash.events.Event;
import flash.net.URLVariables;
import flash.net.URLRequest;
import flash.net.URLRequestMethod;
import flash.net.URLLoader;
import flash.net.URLLoaderDataFormat;
public class register extends MovieClip {
public function register() {
register_button.buttonMode = true;
register_button.addEventListener("click", check_form);
username_text.text = "";
password_text.text = "";
userbio_text.text = "";
}
private function check_form(e:Event):void {
if (username_text.text != "" && password_text.text != "" && userbio_text.text != "") {
send_form();
} else {
result_text.text = "please fill in all fields"
}
}
private function send_form():void {
var phpVars:URLVariables = new URLVariables();
phpVars.username = username_text.text;
phpVars.password = password_text.text;
phpVars.userbio = userbio_text.text;
var req:URLRequest = new URLRequest("php/register.php");
req.method = URLRequestMethod.POST;
req.data = phpVars;
var loader:URLLoader = new URLLoader();
loader.dataFormat = URLLoaderDataFormat.VARIABLES;
loader.addEventListener(Event.COMPLETE, show_result);
loader.load(req);
}
private function show_result(e:Event):void {
result_text.text = "" + e.target.data.result_message;
}
}
}
<?php$db_name = "my_db";
$db_username = "root";
$db_password = "";
$db_host = "localhost";
mysql_connect($db_host, $db_username, $db_password, $db_name);
mysql_select_db($db_name) or die (mysql_error());
?>
<?php
include_once("connect.php");
$username = $_POST['username'];
$password = $_POST['password'];
$userbio = $_POST['userbio'];
$sql = "INSERT INTO users (username, password, user_bio) VALUES ('$username', '$password', '$userbio')";
mysql_query($sql) or exit("result_message=Error");
exit("result_message=Success");
?>