JM wrote:
Hi all,
Ok here is what I need help with:
$var = i like fi'sh;
I'm able to addslashes(gather the data from a form), submit into the
database, stripslashes(retrieve it).
My problem is when I display it in a input type=text form the single
quote is causing a truncation.
JM wrote:
Hi all,
Ok here is what I need help with:
$var = i like fi'sh;
I'm able to addslashes(gather the data from a form), submit into the
database, stripslashes(retrieve it).
My problem is when I display it in a input type=text form the single
quote is causing a truncation.
input
Will wrote:
I'm a little confused with these functions. How I here you ask. Well I
thought I understood what they were for:
Escaping characters that might cause a problem when you enter your data
into a database query. i.e. \ '
Anyway what is confusing me is, say I have a string which
Hello Will,
On 28 Jan 2004 at 12:31, Will wrote:
However recently I encrypted some data which I stored in the database.
The string contained a \ which I added slashes to when entered in to
the database. But as the database appears to strips the first slash
off the double slash automatically.
On 28 January 2004 12:31, Will wrote:
I'm a little confused with these functions. How I here you
ask. Well I thought I understood what they were for:
Escaping characters that might cause a problem when you enter
your data into a database query. i.e. \ '
Anyway what is confusing me is, say
thanks guys, got it working now. Removed Addslashes and it works fine.
1lt John W. Holmes wrote:
I am trying to develop a search for my database.
I used addslashes when entering the data, and then use addslashes with
the search but nothing comes up:
Select * from tblContacts,
Don't know which database you're using but in Oracle you would use:
Select * from tblContacts, tblCountries WHERE
(tblContacts.CountryCode=tblCountries.CountryID) AND (Organization LIKE
'%o''mallies%' )
Escape(\) is only used in PHP syntax, not SQL.
Regards
-Original Message-
From:
what happens when you type:
Select * from tblContacts, tblCountries WHERE
(tblContacts.CountryCode=tblCountries.CountryID) AND (Organization LIKE
'%o\'mallies%' )
at the mysql command line?
- Original Message -
From: Paul Dionne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday,
I am trying to develop a search for my database.
I used addslashes when entering the data, and then use addslashes with the
search but nothing comes up:
Select * from tblContacts, tblCountries WHERE
(tblContacts.CountryCode=tblCountries.CountryID) AND (Organization LIKE
'%o\'mallies%' )
--On Monday, November 26, 2001 04:47:35 PM -0800 Scott Aikin
[EMAIL PROTECTED] wrote:
I've come across a strange problem working backwards with stripslashes
after running addslashes. I take a string like:
\t\4
and run it through addslashes, the result is:
\\t\\4
After grabbing this
10 matches
Mail list logo