Yes and no.
That is your SQL insert statement, which is good to know,
but I was referring to the value of $original_input.
Or is that statement the value of $original_input?
What has the html special characters in it?
Best,
Karl
On Aug 6, 2012, at 3:39 PM, Cor wrote:
Does this hel:
INSERT INTO `tbl_projecten` (`project_nummer`, `project_werk`,
`project_betreft`, `project_datum`, `project_klantnummer`,
`project_ordernummer_klant`, `project_contactpersoon`,
`project_opdracht`,
`project_aanneemsom`, `project_conform`, `project_besteldatum`,
`project_BTW`, `project_betaling_binnen`, `project_kleuren`,
`project_rekeningtekst`) VALUES
(1, 'Entree', 'Aanbrengen van glasweefsel en het sausen daarvan',
'19-11-2011', 24, '0005873-0016178', '', 'order', '5.953,44',
'bestelling',
'11 november 2011', '19', '14', '', '');
-----Original Message-----
From: flashcoders-boun...@chattyfig.figleaf.com
[mailto:flashcoders-boun...@chattyfig.figleaf.com] On Behalf Of Karl
DeSaulniers
Sent: maandag 6 augustus 2012 22:02
To: Flash Coders List
Subject: Re: [Flashcoders] HTML in Datagrid component
Can you post what some data looks like before you put it into mysql?
On Aug 6, 2012, at 8:52 AM, Cor wrote:
Hi All,
I am having a problem with loading data correctly in my Datagrid.
User input data is stored in MySQL through PHP with these functions:
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;
}
It works OK in all the textfields, but not in my Datagrid.
Then it shows like the HTML formatted way: Ã etc.
How to solve this?
Best regards,
Cor van Dooren
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Karl DeSaulniers
Design Drumm
http://designdrumm.com
_______________________________________________
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/5181 - Release Date:
08/06/12
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Karl DeSaulniers
Design Drumm
http://designdrumm.com
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
