as3.0 mysql_AS3.0+PHP写入mySQL

php中$_POST变量是一个数组，用于收集来自method="post"的值，内容是有HTTP POST方法发送的变量名称和值。

从带有POST方法的表单发送的信息，对任何人都是不可见的，并且发送的信息也没有限制。

feiruo

name:age:

echo "Your name is '$_POST['name']', you are '$_POST['age']'.";

?>

$_REQUEST变量包含了$_GET，$_POST方法以及$_COOKIE内容，因此可以使用$_REQUEST变量来获取通过$_GET和$_POST方法发送的数据结果。

其实学PHP有好些时间了，但是还没有好好练习过，今天使用AS3.0调用PHP文件将数据写入到mySQL数据库。

下面是PHP文件register.php:

$con=@mysql_connect(DB_USER,DB_ROOT,DB_PWD)or die('连接错误');//选择数据库

mysql_select_db(DB_NAME,$con)or die('Occured error');mysql_query('SET NAMES UTF8') or die('显示错误');$query="INSERT INTO excise01 (user_name,user_pswd) VALUES ('$getName','$getPswd')";$row=@mysql_query($query) or die('cuowu');//关闭数据库

mysql_close();?>

AS3.0文件：

package {

import flash.display.Sprite;

import flash.events.MouseEvent;

import flash.net.URLRequest;

import flash.net.URLLoader;

import flash.net.URLRequestMethod;

import flash.events.Event;

import flash.net.URLVariables;

public class register_mc extends Sprite{

private const _URL="http://localhost/feiruo/register.php";

private var _VERIFY:_VerifyCode;//验证码

private var _Request:URLRequest;

private var _Loader:URLLoader;

private var _code:String="";

public function register_mc() {

//设定字符区间

nickName.restrict = "a-zA-Z\u4e00-\u9fa5";

verifyCode.restrict = "a-zA-z0-9";

_VERIFY=new _VerifyCode();

this.addChild(_VERIFY);

_VERIFY.x=verifyCode.x-_VERIFY.width/2;

_VERIFY.y=verifyCode.y;

registerBtn.addEventListener(MouseEvent.MOUSE_DOWN,registerFunc);

cancelBtn.addEventListener(MouseEvent.MOUSE_DOWN,cancelFunc);

this.addEventListener(Event.ENTER_FRAME,

function(e:Event):void

{

((nickName.text).replace(/([ ]{1})/g,"")=="" || passWord.text.length<4)?registerBtn.enabled=false:registerBtn.enabled=true;

});

}

private function registerFunc(e:MouseEvent):void

{

if(cancelBtn.hasEventListener(MouseEvent.MOUSE_DOWN))

cancelBtn.removeEventListener(MouseEvent.MOUSE_DOWN,cancelFunc);

if(registerBtn.enabled)

{

verifyCode.text.toLowerCase()==_VERIFY.scode.toLocaleLowerCase() ? register() : verifyCode.text="错误" ;

_VERIFY.refreshCode(e);

cancelFunc(e);

}

}

private function register():void

{

var _var:URLVariables=new URLVariables();

_Request=new URLRequest(_URL);

_Request.method=URLRequestMethod.POST;

_var._name=nickName.text;

_var._pswd=passWord.text;

_Request.data=_var;

_Loader=new URLLoader(_Request);

}

private function cancelFunc(e:MouseEvent):void

{

nickName.text="";

passWord.text="";

verifyCode.text="";

}

}

}

AS3.0验证码：

package

{

/*

*@ClassName:package::verifyCode

*

*@Intro:使用ActionScript3.0绘制常见的简单验证码

*

*@Author:非若

*@E-mail:jdk.feiruo@qq.com

*@Date:2015.07.12

*

*/

import flash.display.Sprite;

import flash.display.Shape;

import flash.text.TextField;

import flash.text.TextFormat;

public class verifyCode extends Sprite

{

private var tt:Sprite=new Sprite();

private var TT:Sprite=new Sprite();

private var bg:Shape;

private var word:Shape;

private var blurW:Shape;

private var randsum:uint=(Math.random()*78)%26;

public function verifyCode(arr:Array)

{

init_imageBG();

init_imageBlur();

init_imageW(arr);

init_imageX();

init_mask();

this.addChild(tt);

this.addChild(TT);

TT.addChild(init_mask());

tt.mask=TT;

}

private function init_mask():Sprite{

var d:Sprite=new Sprite();

d.graphics.clear();

d.graphics.beginFill(setColor(),1);

d.graphics.drawRect(0,0,65,32);

d.graphics.endFill();

return d;

}

private function init_imageBG():void

{

bg=new Shape();

bg.graphics.clear();

bg.graphics.beginFill(0xFFFFFF,0);

bg.graphics.drawRect(0,0,65,32);

bg.graphics.endFill();

tt.addChild(bg);

}

private function init_imageW(codes:Array):void

{

word=new Shape();

for (var i:uint=0; i

{

var t:TextField=new TextField();

var f:TextFormat=new TextFormat();

f.size = 12 * Math.random() + 12;

f.color = setColor()+0x666666;

f.bold=true;

t.text = codes[i];

t.x = i * 16 + 1;

t.selectable = false;

t.y = Math.random() * 5 - 1;

tt.addChild(t);

t.setTextFormat(f);

}

}

private function init_imageBlur():void

{

blurW=new Shape();

for (var r:uint=0; r<=3; r++)

{

blurW.graphics.lineStyle(3*Math.random()*1,setColor());

blurW.graphics.lineTo(65*Math.random()+5,35*Math.random()+4);

blurW.graphics.moveTo(65*Math.random()-10,35*Math.random()-5);

blurW.alpha=.8;

tt.addChild(blurW);

}

}

private function init_imageX():void{

init_imageW([".",".",".","."]);

}

private function setColor():uint

{

var _color:uint = 0xCCCCCC * Math.random() + 0x222200;

return _color;

}

}

}

package

{

/*

*@ClassName:package::verifyCode

*

*@Intro:向verifyCode传送绘制的字符

*

*@Author:非若

*@E-mail:jdk.feiruo@qq.com

*@Date:2015.07.12

*

*/

import flash.display.Sprite;

import flash.display.Shape;

import flash.events.MouseEvent;

public class _VerifyCode extends Sprite

{

public var scode:String="";

public var code:Array = [];

private var words:String = "QYhg123UBNMw0erty89LKJPuXCVioplOHGFkj45fIDSAZdsaz67xcWERTvbnm";

private var vcode:verifyCode;

public function _VerifyCode()

{

vcode=new verifyCode(getString());

addChild(vcode);

vcode.buttonMode=true;

this.addEventListener(MouseEvent.MOUSE_DOWN,refreshCode);

}

public function refreshCode(e:MouseEvent):void

{

removeChild(vcode);

vcode=new verifyCode(getString());

addChild(vcode);

}

private function getString():Array

{

code=[];

scode="";

for (var a:uint=0; a<=3; a++)

{

scode+=words.charAt((Math.random()*words.length*3)%words.length);

code.push(scode.charAt(a));

}

return code;

}

}

}