php-db | 2001011

Re: [PHP-DB] another dumb newbie question - backslash before single quote From: Kevin McCarthy (kevin <email protected>)
Date: 01/15/01

store the value in a named variable, then call the variable with the
stripslashes() function before inserting it into the DB.
a la:

$event = "St. Patrick's Day";
$event = stripslashes($event);

insert table values('$event'); ....

At 02:13 PM 1/15/2001 -0500, Timothy Wright wrote:
>Hello -
>
>I have set up a calendar database with MySQL and PHP that uses simple text
>and tinytext fields for events and event descriptions. The problem is,
>whenever I enter an event that uses an apostrophe ( St. Patrick's Day) or a
>description (4 o'clock) it stores and returns ( St. Patrick\'s Day) from the
>database. Any suggestions?
>
>Thanks in advance,
>
>Tim Wright
>
>:::::::::::::::::::::::::::::::::::::::::::
>::: :::
>::: Timothy Wright :::
>::: mailto:tim.wright <email protected> :::
>::: Digital Network Enterprises :::
>::: http://www.01network.com :::
>::: :::
>::: secure e-mail by request :::
>::: (PGP signature and/or encryption) :::
>:::::::::::::::::::::::::::::::::::::::::::
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: php-db-unsubscribe <email protected>
>For additional commands, e-mail: php-db-help <email protected>
>To contact the list administrators, e-mail: php-list-admin <email protected>

Kevin McCarthy Body & Soul
http://www.bodynsoul.com 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>