Re: [PHP-DB] short text strings with apostrophes and forms
by Charlie van de Kerkhof other posts by this author
Apr 20 2006 9:07AM messages near this date
RE: [PHP-DB] short text strings with apostrophes and forms
|
[PHP-DB] issue with MySQL stored procedure and result set
Hi Jeffrey,
try this:
> >>
print "<input type='text' name='some_variable'
value='".htmlspecialchars($some_text)."'> \n";
<<<
Regards,
- Charlie
On 20 Apr 2006, at 17:56, Jeffrey wrote:
> I have an application which calls up some data from a MySQL table
> and puts it into a web form for users to modify.
> One of the cells holds a text string which is put into a text input
> field. However, if that text string includes an apostrophe, all
> text after the apostrophe disappears.
> For example, if the test string from a database cell reads...
> Fix the managers' cars by Tuesday
> and that is saved in the variable $some_text, which is called up in
> a form...
> <input type='text' name='some_variable' value='$some_text'>
> The text field on the web page will only contain...
> Fix the managers
> How can I get the text field to show the entire string?
> Many thanks,
> Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thread:
Jeffrey
Luis Morales
dpgirago
Richard Leclair
Charlie van de Kerkhof
|