PROTECTED]
Sent: Wednesday, January 09, 2002 11:59 AM
Subject: RE: apostrophe's in PHP MySQL
Hi Tim,
You can get around that proble using AddSlashes() function in PHP. So is
you
have a text box where the users enter their inputs, say assigned to the
variable $feedback then , before entering
Sherwin Ang writes:
another approach is using the str_replace() function, just replace the
single quote ' with two single quotes '' and database inserts should be
fine.
Very funny. Let's say you're making this query:
DELETE FROM t1 WHERE str_field = '$value'
with your way of doing things,
to this or
that.
- Jonathan
-Original Message-
From: Tim Thorburn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 7:11 PM
To: [EMAIL PROTECTED]
Subject: apostrophe's in PHP MySQL
Hi,
I've been experiencing some sporadic problems with a few web forms written
in PHP 3.0.16
* Jonathan Hilgeman
So something like Joe's Farm will look like Joe#039;s Farm. It gets
inserted into the database without any addslashes, and when you
retrieve it from the database, it should work fine without any
converting to this or that.
...and when you search the database, you must do
Hi,
I've been experiencing some sporadic problems with a few web forms written
in PHP 3.0.16 and MySQL 3.23.31 with text fields (both single lines and
rows). Generally if any of the text in these forms contains an apostrophe
- either nothing is entered into the database, or nothing after the
08, 2002 10:11 PM
Subject: apostrophe's in PHP MySQL
Hi,
I've been experiencing some sporadic problems with a few web forms written
in PHP 3.0.16 and MySQL 3.23.31 with text fields (both single lines and
rows). Generally if any of the text in these forms contains an apostrophe
- either
Thorburn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 10:11 PM
To: [EMAIL PROTECTED]
Subject: apostrophe's in PHP MySQL
Hi,
I've been experiencing some sporadic problems with a few web forms written
in PHP 3.0.16 and MySQL 3.23.31 with text fields (both single lines and
rows