editeur de texte et back office flash

CREATE TABLE `textes` ( `id` INT NOT NULL AUTO_INCREMENT, `value` TEXT NOT NULL, PRIMARY KEY ( `id` ) ) ENGINE = MYISAM ;

<?php
header ("Content-type: text/plain; charset=utf-8");

$conn = mysql_connect('HOST','USER','PASS');
if (!$conn) die ("connexion au serveur MySQL impossible");
mysql_select_db('DATABASE');

if (!empty($_POST['action'])) {
	if ($_POST['action'] == 'load') {
		$qry = "SELECT value FROM textes WHERE id=".$_POST['id']." LIMIT 0,1";
		$rs  = mysql_query($qry);
		if (!$rs) echo mysql_error();
		if (mysql_num_rows($rs) != 1) echo "Aucun enregistrement";
		$rw  = mysql_fetch_assoc($rs);
		echo utf8_encode($rw['value']);
	} else if ($_POST['action'] == 'create' || $_POST['action'] == 'save') {
		$qry = $_POST['action'] == 'create' ? "INSERT INTO " : "UPDATE ";
		$qry .= " textes SET value='".addslashes(utf8_decode($_POST['value']))."'";
		if ($_POST['action'] == 'save') $qry .= " WHERE id=".$_POST['id'];
		$rs  = mysql_query($qry);
		if (!$rs) echo mysql_error();
		else echo "success";
	}
}
?>

import flash.net.URLRequest;
import flash.net.URLRequestMethod;
import flash.net.URLVariables;
import flash.net.URLLoader;
import flash.events.Event;

function createText():void {
	var vr:URLVariables = new URLVariables();
	vr.action = 'create';
	vr.value = '<b>mon texte</b> en html ... donc riche texte';
	var rq:URLRequest = new URLRequest("url.de.ton.php");
	rq.method = URLRequestMethod.POST;
	rq.data = vr;
	var ld:URLLoader = new URLLoader();
	ld.addEventListener(Event.COMPLETE, onCreateText);
	ld.load(rq);
}
function onCreateText(event:Event):void {
	var ld:URLLoader = event.currentTarget as URLLoader;
	ld.removeEventListener(Event.COMPLETE, onCreateText);
	trace ("texte créé");
}

function saveText():void {
	var vr:URLVariables = new URLVariables();
	vr.action = 'save';
	vr.value = '<b>mon <i>nouveau</i> texte</b> en html ... donc riche texte';
	var rq:URLRequest = new URLRequest("url.de.ton.php");
	rq.method = URLRequestMethod.POST;
	rq.data = vr;
	var ld:URLLoader = new URLLoader();
	ld.addEventListener(Event.COMPLETE, onSaveText);
	ld.load(rq);
}
function onCreateText(event:Event):void {
	var ld:URLLoader = event.currentTarget as URLLoader;
	ld.removeEventListener(Event.COMPLETE, onSaveText);
	trace ("texte mis à jour");
}

function loadText():void {
	var vr:URLVariables = new URLVariables();
	vr.action = 'load';
	vr.id = 1;
	var rq:URLRequest = new URLRequest("url.de.ton.php");
	rq.method = URLRequestMethod.POST;
	rq.data = vr;
	var ld:URLLoader = new URLLoader();
	ld.addEventListener(Event.COMPLETE, onLoadText);
	ld.load(rq);
}
function onLoadText(event:Event):void {
	var ld:URLLoader = event.currentTarget as URLLoader;
	ld.removeEventListener(Event.COMPLETE, onLoadText);
	ocurrence_txt.htmlText = String(ld.data);
}