Re: [PHP-DB] characters problem
I finally used the str_replace and now it works! :-)
Thank you all for your help
Panos
Jochem Maas [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Bastien Koert wrote:
Two years and you haven't heard of:
addslashes?
mysql_reaL_escape_string?
or even something as simple as
$comments = str_replace(','',$comments);
to replace the one quote with two single quotes (don't forget to remove
them on the display...)
I thount that the first single-quote escapes the second and only 1 is
stored. so I took 2 seconds to type 'mysql.com single quote' into
google and ...
well check out: http://dev.mysql.com/doc/mysql/en/String_syntax.html
(personally I think the style CS on the site makes some of the
information hard to digest)
good luck.
bastien
From: Panos Yahoo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] characters problem
Date: Fri, 17 Dec 2004 09:38:15 +0200
Dear All,
I am using php and mysql the last two years, and I still cannot find the
way
to update a field on mysql from php that containts the single quotes ( `
and
' )
Examples
Here is an example of my index.php file. I have to type something on
Comments field
-
?
include(../configs/dates.inc);
include(../configs/config.inc);
echo
br
body bgcolor=#FFF8E1 text=#2003CF link=#2003CF vlink=#2003CF
alink=#2003CF
center
form method=post action=add.php
font face=\Comic Sans MS\Commentsbrtextarea rows=3 cols=40
name=mycomments tabind
ex=22/textarea
input type=submit name=Submit value=\Add Ticket\
input type=reset name=Reset value=\Clear Form\
;
mysql_close($myconn);
?
-
In the html text area, I am typing the following text : Hello My name is
Panos and I'm from Greece
The add.php file looks like this :
-
?
include(../configs/dates.inc);
include(../configs/config.inc);
$myquery=INSERT INTO `$table` (`comments`) VALUES ('$mycomments');
$myresult=mysql_db_query($db,$myquery);
mysql_close($myconn);
echo done;
?
-
ANd when i'm trying to see what was added on mysql, i have the following
result :
Hello My name is Panos and I\
-
The field on mysql is TEXT
Does anyone knows how can i resolve this problem?
Thanks
Panos
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] characters problem
Two years and you haven't heard of:
addslashes?
mysql_reaL_escape_string?
or even something as simple as
$comments = str_replace(','',$comments);
to replace the one quote with two single quotes (don't forget to remove them
on the display...)
bastien
From: Panos Yahoo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] characters problem
Date: Fri, 17 Dec 2004 09:38:15 +0200
Dear All,
I am using php and mysql the last two years, and I still cannot find the
way
to update a field on mysql from php that containts the single quotes ( `
and
' )
Examples
Here is an example of my index.php file. I have to type something on
Comments field
-
?
include(../configs/dates.inc);
include(../configs/config.inc);
echo
br
body bgcolor=#FFF8E1 text=#2003CF link=#2003CF vlink=#2003CF
alink=#2003CF
center
form method=post action=add.php
font face=\Comic Sans MS\Commentsbrtextarea rows=3 cols=40
name=mycomments tabind
ex=22/textarea
input type=submit name=Submit value=\Add Ticket\
input type=reset name=Reset value=\Clear Form\
;
mysql_close($myconn);
?
-
In the html text area, I am typing the following text : Hello My name is
Panos and I'm from Greece
The add.php file looks like this :
-
?
include(../configs/dates.inc);
include(../configs/config.inc);
$myquery=INSERT INTO `$table` (`comments`) VALUES ('$mycomments');
$myresult=mysql_db_query($db,$myquery);
mysql_close($myconn);
echo done;
?
-
ANd when i'm trying to see what was added on mysql, i have the following
result :
Hello My name is Panos and I\
-
The field on mysql is TEXT
Does anyone knows how can i resolve this problem?
Thanks
Panos
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] characters problem
Bastien Koert wrote:
Two years and you haven't heard of:
addslashes?
mysql_reaL_escape_string?
or even something as simple as
$comments = str_replace(','',$comments);
to replace the one quote with two single quotes (don't forget to remove
them on the display...)
I thount that the first single-quote escapes the second and only 1 is
stored. so I took 2 seconds to type 'mysql.com single quote' into
google and ...
well check out: http://dev.mysql.com/doc/mysql/en/String_syntax.html
(personally I think the style CS on the site makes some of the
information hard to digest)
good luck.
bastien
From: Panos Yahoo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] characters problem
Date: Fri, 17 Dec 2004 09:38:15 +0200
Dear All,
I am using php and mysql the last two years, and I still cannot find
the way
to update a field on mysql from php that containts the single quotes (
` and
' )
Examples
Here is an example of my index.php file. I have to type something on
Comments field
-
?
include(../configs/dates.inc);
include(../configs/config.inc);
echo
br
body bgcolor=#FFF8E1 text=#2003CF link=#2003CF vlink=#2003CF
alink=#2003CF
center
form method=post action=add.php
font face=\Comic Sans MS\Commentsbrtextarea rows=3 cols=40
name=mycomments tabind
ex=22/textarea
input type=submit name=Submit value=\Add Ticket\
input type=reset name=Reset value=\Clear Form\
;
mysql_close($myconn);
?
-
In the html text area, I am typing the following text : Hello My name is
Panos and I'm from Greece
The add.php file looks like this :
-
?
include(../configs/dates.inc);
include(../configs/config.inc);
$myquery=INSERT INTO `$table` (`comments`) VALUES ('$mycomments');
$myresult=mysql_db_query($db,$myquery);
mysql_close($myconn);
echo done;
?
-
ANd when i'm trying to see what was added on mysql, i have the following
result :
Hello My name is Panos and I\
-
The field on mysql is TEXT
Does anyone knows how can i resolve this problem?
Thanks
Panos
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
