Posted by Jerry Stuckle on 10/13/06 12:28

mantrid wrote:
> Hello
>
> I have been getting strange behaviour when using ' in by textboxes.
>
> eg inputting the following
> this is some test text ' and so is this
>
> is saved to the mysql database ok as
>
> this is some test text /' and so is this (with add slashes)
> or
> this is some test text ' and so is this (without add slashes)
>
> mysql field is VARCHAR(255)
>
> but when I retreive the data and display in textboxes on my web page, text
> area type (below) is ok
> <textarea class='BodyText' style='WIDTH: 85%' name="textarea"><?php echo
> $opta; ?></textarea>
>
> but input type (below) cuts everything off after the ' character. However
> this does not happen with other characters such as " or /
> <input type='text' class='BodyText' style='WIDTH: 85%' name='test'
> value='<?php echo $opta; ?>'>
>
> can anyone explain this behaviour and have a solution so that text with any
> ' characters in it is fully displayed?
>
>
> Ian
>
>

What's it look like when you view the source?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]