Re: Displaying data from a MySLQ table
| From: | John Nichel | Date: | Fri, 30 Jun 2006 19:30:03 +0000 |
| Subject: | Re: Displaying data from a MySLQ table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-239017@lists.php.net to get a copy of this message | ||
Don wrote:
Hi Have have a varchar field in a MySQL database which contains the following 905.362.6000"l""s"'L' I am trying to display it on my web page in a <INPUT="TEXT"> field but all I see is: 905.362.6000Because it has quotes in it. I bet if you look at the source of the page, the full value is there. If your form field looks like this... <input type="text" name="foo" value="$value" /> It's going to output like this.... <input type="text" name="foo" value="905.362.6000"l""s"'L'" /> -------------------------------------------------^ So when the browser sees the first double quote in your value, it assumes that you're closing off the attribute. Try running the value thru htmlentities()
I am wondering why the trailing characters do not display even though they are present in the database when I check using PhpMyAdmin. Please help. Thanks in advance My code snippet is as follows: <tr> <td><font color="#FF0000"><b>Phone</b></font></td> <td><input type="text" name="phone" value="<?PHP echo query_database($db_account->Phone); ?>" size="25"></td> </tr> The query_database() function is my own and looks as follows: // smart function for querying a MySQL database function query_database($value) { // Stripslashes if (get_magic_quotes_gpc()) {Why are you running mysql_real_escape_string() after selecting data? -- John C. Nichel IV Programmer/System Admin (ÜberGeek) Dot Com Holdings of Buffalo 716.856.9675 jnichel@dotcomholdingsofbuffalo.com$value = stripslashes($value);} // Quote if not a number or a numeric string if (!is_numeric($value)) {$value = mysql_real_escape_string($value);} return $value; }