magic quotes?? how does this come into place then.
terrence
Ankur Verma wrote:
> if you store the data in the MYSQL database with the slashes escaping the
> quotes, I think the complete stuff will get stored.
>
> for ex - if you have
>
> Description: I like to run and walk. I love "smelly cheese."
>
> and on posting, you get
>
> I like to run and walk. I love \"smelly cheese.\"
>
> it will store the complete string into the MYSQL database.
>
> and on retrieval you will get
>
> I like to run and walk. I love "smelly cheese."
>
> try it out
>
> best regards
>
> Ankur Verma
> HCL Technologies
> A1CD, Sec -16
> Noida, UP
> India
>
> ----- Original Message -----
> From: "Tanya Brethour" <[EMAIL PROTECTED]>
> To: "Web master" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, February 14, 2001 11:47 PM
> Subject: Re: [PHP] Qoute problem
>
> >
> >
> > Let says I strip the slashes.. so it goes back to just normal qoutes.. and
> > then do the str_replace("\"","|", $describe);
> >
> > $describe = stripslashes($describe);
> > str_replace("\"","|",$describe);
> >
> > It doesnt replace the qoutes..
> >
> > -Tanya
> >
> > On Wed, 14 Feb 2001, Web master wrote:
> >
> > > My approach towards this problem was to parse the data before inserting
> > > and before displaying.
> > > Before inserting the data entered by user, do something like
> > > str_replace($comments, "'","~") and do the same thing for " do a
> > > different character like | and then insert it into database.
> > > Do the reverse before displaying the data, it should fix your problem..
> > >
> > > Tanya Brethour wrote:
> > >
> > > > Hi! I was hoping that someone could help me out. I am not positive if
> I
> > > > understand whats going on.. so let me try to explain.
> > > >
> > > > This is a process to modify news articles in a MySQL database.
> > > >
> > > > (From the point after picking the article to modify)
> > > > PHP Script #1:
> > > > I grab everything from the database and stick it into the HTML form
> > > > (textarea, text, etc). I allow the user to modify whatever they want.
> > > >
> > > > PHP Script #2:
> > > > This script takes the new information and displays it to the user..
> it is
> > > > a preview of what it will look like with the changes.
> > > >
> > > > PHP Script #3:
> > > > Updates the news article in the database.
> > > >
> > > > Now the problem I am having.. is that the description and content
> fields
> > > > have qoutes in them. For example:
> > > > Description: I like to run and walk. I love "smelly cheese."
> > > >
> > > > So.. when it tries to update the database. It will only store this as
> the
> > > > description:
> > > > I like to run and walk. I love\\
> > > >
> > > > I know that its because the qoutes are not being escaped correctly..
> and
> > > > it seems as though it is escaping the escape.
> > > >
> > > > So my question is.. how can I keep my qoutes?
> > > >
> > > > Just FYI.. I am making the user enter in the description and content
> in
> > > > html. So i cant just change the qoutes to HTMLTags because it would
> change
> > > > my <P> and <a href=> etc.
> > > >
> > > > Below is an example of the code (shortened for an example):
> > > >
> > > > PHP Script #1: Editing description
> > > >
> > > > print'
> > > > </textarea><br>
> > > > Description:<br><textarea name=describe cols=40 rows=10>';
> > > > echo $info["description"];
> > > > print'
> > > > </textarea><br>';
> > > >
> > > > PHP Script #2: (preview changes)
> > > >
> > > > <input type=hidden name=describe value="<?php print $describe?>">
> > > > <b>Description:</b><br>
> > > > <?php print $describe?> <p>
> > > >
> > > > PHP Script #3: (update database)
> > > > $sql = "UPDATE news SET release_date='$date', title='$title',
> > > > description='$describe', contact='$contact', content='$test',
> type='$type'
> > > > WHERE news_id=$id";
> > > > $result = mysql_query($sql)
> > > >
> > > >
> > > > Thanks in advance.
> > > >
> > > > -Tanya
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
