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.
will disp
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 truncat
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 i
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 automatical
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 contai
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,
> 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
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: Tuesda
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: P
--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 gr
10 matches
Mail list logo
