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 = ' mon texte 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 = ' mon nouveau texte 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); }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionvr.value = nomoccurrence_txt.htmlText;
occurrence_btn.addEventListener(MouseEvent.CLICK, saveText);
function saveText(event:MouseEvent):void { ...