Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #17758

Re: solved: Problems with accents

Show all headers | View raw

Le 18/05/2018 19:36, Jerry Stuckle a écrit :
> On 5/18/2018 11:13 AM, andre wrote:
>> Le 17/05/2018 10:01, andre a écrit :
>>> This is working well:
>>> print "L'homme\n";
>>> Buts this
>>> print "<P>INPUT NAME='titre' VALUE='l\'homme'>\n";
>>> Print only upto the appostrophe! :  l\
>>> Any idea??
>>> Many thanks
>>> André
>> As the data comes from a database, I have made the change in the entry
>> procees to the db.
>> $TT = htmlspecialchars($Titre, ENT_QUOTES);
>> and oups OK.
>> I have a few records to update will not be too difficult.
>> Many thanks again
>> André
>
> HTML is a scripting language for displaying data, not storing it.  You
> really don't want to store the HTML equivalents in your database.  That
> will make searching the database more complicated.  You should store the
> characters in their natural form in the database then use
> htmlspecialchars() or htmlentities() to display the characters.
>
Here the problem is limited to a character you never use for searching 
the database (full text) so in my case it's a limited problem, but you 
are right better no HTML in the database.
Many thanks

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Problems with accents andre <ahr@blabla.be> - 2018-05-17 10:01 +0200
  Re: Problems with accents Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2018-05-17 12:32 +0200
    Re: Problems with accents andre <pasmoi@pasici.be> - 2018-05-17 13:36 +0200
      Re: Problems with accents Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2018-05-17 14:31 +0200
        Re: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-18 08:50 -0400
      Re: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-18 08:55 -0400
    Re: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-18 08:47 -0400
  Re: Problems with accents Richard Yates <richard@yatesguitar.com> - 2018-05-17 05:58 -0700
  Re: solved: Problems with accents andre <pasmoi@pasici.be> - 2018-05-18 17:13 +0200
    Re: solved: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-18 13:36 -0400
      Re: solved: Problems with accents andre <pasmoi@pasici.be> - 2018-05-19 10:09 +0200
        Re: solved: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-19 08:48 -0400
        Re: solved: Problems with accents Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2018-05-19 20:18 +0200
          Re: solved: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-19 18:33 -0400
            Re: solved: Problems with accents "Peter H. Coffin" <hellsop@ninehells.com> - 2018-05-20 10:44 -0500

csiph-web