RE: [PHP-DB] addslashes()

At 9:53 -0600 2/8/02, Todd Williamsen wrote:

Paul.. Going into the database Coming out of the database Please read the whole post.. 8)

I did. It's not clear, at least to me, what you're trying to do. You say "print" at one point and "insert into database" at another point. I'm pretty sure I know the solution. What's not clear to me is the *problem*. Where are the data coming from? Are you generating it within the script? Are you receiving it as the contents of a web form? What are you doing with that data? Printing it? Storing it into the database? Storing it into the database so that you can print it as a Web page later?

-----Original Message----- From: Paul DuBois [mailto:paul@snake.net] Sent: Friday, February 08, 2002 9:40 AM To: Todd Williamsen; php-db@lists.php.net Subject: Re: [PHP-DB] addslashes() At 9:14 -0600 2/8/02, Todd Williamsen wrote:

So if I: Going in $Notes = addslashes($Notes); Going Out: $Notes = stripslashes($Notes); wouldn't that kill the html? or no?

I have no idea. What do you mean by "in" and "out"? What exactly are you trying to do? Are you generating HTML for a Web page, storing data in a database, or are you trying to store HTML in your database?

"Joe Van Meer" <vanmeer@accesscable.net> wrote in message news:20020208004317.841.qmail@pb1.pair.com...

Hi. addslashes() going in to db, stripslashes() coming out :) HTH Joe :) Todd Williamsen <todd@williamsen.net> wrote in message news:002601c1b033$382a4700$f6b2d83f@goofy1...

Paul, It is being inserted into a database -----Original Message----- From: Paul DuBois [mailto:paul@snake.net] Sent: Thursday, February 07, 2002 5:41 PM To: Todd Williamsen; php-db@lists.php.net Subject: Re: [PHP-DB] addslashes() At 16:54 -0600 2/7/02, Todd Williamsen wrote:

Ok.. i tried it out... and it almost works like I want it... weird

though

1. when I put in <p><font color="blue">this is BLUE</p></font> it prints it in like a bright green. but if i use the RGB # then

its fine.

weird.... 2. if there is an apostrophe in the notes, then it will add

slashes it to

that as well so if I type blah blah blah I am going over to my friend's

website later on

and here is the address... <a href="http://friends.com>Friends</a> it will look like friend\\\'s Friends(link)

addslashes() is for escaping values that you're going to insert into a database. If you're generating HTML, use htmlspecialchars() instead.

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php