Re: [PHP-DB] short text strings with apostrophes and forms
[EMAIL PROTECTED] 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... 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 htmlentities($some_text, ENT_QUOTES) is more robust than htmlspecialchars (); David Thanks, David. That did the trick. And thanks to everyone else who quickly responded with intelligent advice! Jeffrey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] short text strings with apostrophes and forms
> 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... > > > > 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 htmlentities($some_text, ENT_QUOTES) is more robust than htmlspecialchars (); David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] short text strings with apostrophes and forms
Jeffry,
I suggest use htmlentities/html_entity_decode functions. For example to
update the db with values use:
$myCol = htmlentities($mycol_value);
Ej: query
$query = "update my_table set myCol='{$myCol}' where id = 'id_val'";
Now when your application restore the data from the db you can use:
$mycol_value = html_entity_decode ($myCol);
$mycol_value: is the value from html form
$myCol: is the name of your colum's table to update in your query.
Good luck,
Regards,
Luis Morales
On Thu, 2006-04-20 at 17:56 +0200, 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...
>
>
>
> 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
>
--
-
Luis Morales
Consultor de Tecnologia
Cel: +(58)416-4242091
-
"Empieza por hacer lo necesario, luego lo que es posible... y de pronto
estarás haciendo lo imposible"
-
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] short text strings with apostrophes and forms
You could try enclosing the string in the HTML line by double-quotes rather than single quotes. Ie. Regards, Richie ! _ From: Jeffrey [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 April 2006 11:56 pm To: PHP DB Subject: [PHP-DB] short text strings with apostrophes and forms 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... 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 _ avast! Antivirus <http://www.avast.com> : Inbound message clean. Virus Database (VPS): 0616-3, 20/04/2006 Tested on: 21/04/2006 12:03:14 am avast! - copyright (c) 1988-2005 ALWIL Software.
Re: [PHP-DB] short text strings with apostrophes and forms
Hi Jeffrey, try this: >>> print "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... 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
[PHP-DB] short text strings with apostrophes and forms
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... 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
