Karl,
Maybe the full picture helps some more
I use these functions to create a xml string to return to Flash.
With use of the mysql fieldnames as key en the content as value and never
have to worry about wath the fieldnames are.
So when Flash reads a project it send a URLVariable to PHP:
///////////// Read Project /////////////
if (isset($_POST['sendRequest']) && $_POST['sendRequest'] == "read_project")
{
$currentTable = "tbl_projecten";
if ($_POST['isParticulier'] == "ja") {
$currentTable = "tbl_particulier_projecten";
}
$project_nummer = stringToMysqlFormat($_POST['project_nummer']);
header("Content-type: text/xml");
$xmlOutput ='<?xml version="1.0" encoding="UTF-8" ?>';
$xmlOutput .="\n<data>";
//-------PROJECTGEGEVENS
$sql = "SELECT * FROM $currentTable WHERE project_nummer=$project_nummer";
$result = mysql_query($sql);
$recordArray = array();
//maak assoc array om fieldnames als XML-tags te gebruiken
while ($row = mysql_fetch_assoc ($result)) {
array_push($recordArray, $row);
}
for ($i=0; $i<count($recordArray); $i++) {
//echo $recordArray[$i]['id'];
$xmlOutput .= "\t<project>\n";
// $key is de assoc fieldname en $value de inhoud
foreach ($recordArray[$i] as $key => $value) {
writeItem($key, $value);
if($key == "project_klantnummer"){
$project_klantnummer = $value;
}//end if
}//end foreach
$xmlOutput .= "\t</project>\n";
}
//------- KLANTGEGEVENS
$sql = "SELECT * FROM tbl_klanten WHERE
klant_nummer=$project_klantnummer";
$result = mysql_query($sql);
$recordArray = array();
//maak assoc array om fieldnames als XML-tags te gebruiken
while ($row = mysql_fetch_assoc ($result)) {
array_push($recordArray, $row);
}
for ($i=0; $i<count($recordArray); $i++) {
//echo $recordArray[$i]['id'];
$xmlOutput .= "\t<klant>\n";
// $key is de assoc fieldname en $value de inhoud
foreach ($recordArray[$i] as $key => $value) {
writeItem($key, $value);
}
$xmlOutput .= "\t</klant>\n";
}
//------- MATERIALENVERBRUIK
$currentTable = "tbl_materialen_verbruik";
if ($_POST['isParticulier'] == "ja") {
$currentTable = "tbl_particulier_materialen_verbruik";
}
$sql = "SELECT * FROM $currentTable WHERE
mv_projectnummer=$project_nummer";
$result = mysql_query($sql);
$recordArray = array();
//maak assoc array om fieldnames als XML-tags te gebruiken
while ($row = mysql_fetch_assoc ($result)) {
array_push($recordArray, $row);
}
$xmlOutput.='<materialen_verbruik>';
for ($i=0; $i<count($recordArray); $i++) {
//echo $recordArray[$i]['id'];
$xmlOutput .= "\t<mv>\n";
// $key is de assoc fieldname en $value de inhoud
foreach ($recordArray[$i] as $key => $value) {
writeItem($key, $value);
}
$xmlOutput .= "\t</mv>\n";
}
$xmlOutput.='</materialen_verbruik>';
//------- URENVERBRUIK
$currentTable = "tbl_uren_verbruik";
if ($_POST['isParticulier'] == "ja") {
$currentTable = "tbl_particulier_uren_verbruik";
}
$sql = "SELECT * FROM $currentTable WHERE
uv_projectnummer=$project_nummer";
$result = mysql_query($sql);
$recordArray = array();
//maak assoc array om fieldnames als XML-tags te gebruiken
while ($row = mysql_fetch_assoc ($result)) {
array_push($recordArray, $row);
}
$xmlOutput.='<uren_verbruik>';
for ($i=0; $i<count($recordArray); $i++) {
//echo $recordArray[$i]['id'];
$xmlOutput .= "\t<uv>\n";
// $key is de assoc fieldname en $value de inhoud
foreach ($recordArray[$i] as $key => $value) {
writeItem($key, $value);
}
$xmlOutput .= "\t</uv>\n";
}
$xmlOutput.='</uren_verbruik>';
//------- MATERIALEN
$sql = "SELECT * FROM tbl_materialen";
$result = mysql_query($sql);
$recordArray = array();
//maak assoc array om fieldnames als XML-tags te gebruiken
while ($row = mysql_fetch_assoc ($result)) {
array_push($recordArray, $row);
}
$xmlOutput.='<materialen>';
for ($i=0; $i<count($recordArray); $i++) {
//echo $recordArray[$i]['id'];
$xmlOutput .= "\t<mat>\n";
// $key is de assoc fieldname en $value de inhoud
foreach ($recordArray[$i] as $key => $value) {
writeItem($key, $value);
}
$xmlOutput .= "\t</mat>\n";
}
$xmlOutput.='</materialen>';
//------- USERDATA ZONDER ACCOUNT_TYPE EN WACHTWOORD !
$sql = "SELECT user_id, voorletters, tussenvoegsel, achternaam,
uurloon FROM tbl_users";
$result = mysql_query($sql);
$recordArray = array();
//maak assoc array om fieldnames als XML-tags te gebruiken
while ($row = mysql_fetch_assoc ($result)) {
array_push($recordArray, $row);
}
$xmlOutput.='<users>';
for ($i=0; $i<count($recordArray); $i++) {
//echo $recordArray[$i]['id'];
$xmlOutput .= "\t<user>\n";
// $key is de assoc fieldname en $value de inhoud
foreach ($recordArray[$i] as $key => $value) {
writeItem($key, $value);
}
$xmlOutput .= "\t</user>\n";
}
$xmlOutput.='</users>';
//sluit de root tag
$xmlOutput .= "</data>";
print "returnXML=".$xmlOutput;
}
//End READ PROJECT
//
function stringToMysqlFormat($original_input) {
//for inserting the data with special characters INTO mysql
$html_encoded =
htmlentities(mysql_real_escape_string($original_input));
return $html_encoded;
}
function mysqlToHTMLFormat($encoded) {
//for displaying the data FROM mysql
$html_decoded = html_entity_decode(stripslashes($encoded));
return $html_decoded;
}
function writeItem($k, $v) {
global $xmlOutput;
$xmlOutput .= "\t\t<" . $k . ">" . mysqlToHTMLFormat($v) . "</" . $k
. ">\n";
}
Best regards,
Cor
-----Original Message-----
From: flashcoders-boun...@chattyfig.figleaf.com
[mailto:flashcoders-boun...@chattyfig.figleaf.com] On Behalf Of Karl
DeSaulniers
Sent: woensdag 8 augustus 2012 9:02
To: Flash Coders List
Subject: Re: [Flashcoders] HTML in Datagrid component
Ooh Sry, brain fart.. :P
Try this..
function stringToMysqlFormat($original_input) {
//for inserting the data INTO mysql
$my_string =
html_entities(mysql_real_escape_string($original_input));
return $my_string;
}
function mysqlToHTMLFormat($encoded) {
//for echoing the data FROM mysql
$my_html = html_entity_decode(stripslashes($encoded));
return $my_html;
}
Not that it matters all the time, but I stay away from php variables that
are the same name as a code in any other lang. IE String or HTML.
Just forgot as I was writing last time. Damn auto-pilot. :)
HTH,
Best,
Karl
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5185 - Release Date: 08/07/12
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
