By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,897 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

Problem displaying a mysql database field

P: n/a
Hi,

I have a varchar field in a MySQL database that contains a line of text
like so:

"This is a line if text"

The double quotes are included in the database field.

I cannot seem to display it on my HTML page, it always shows as blank.
I have tried using both the stripslashes() and the html_entity_decode()
but it still shows as blank.

An code example I am trying is as follows:
<?php
echo
stripslashes(html_entity_decode($my_variable_from_ a_mysql_database));
?>

How can I display this please???

Tks,
Don

Jun 20 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
donpro wrote:
Hi,

I have a varchar field in a MySQL database that contains a line of text
like so:

"This is a line if text"

The double quotes are included in the database field.

I cannot seem to display it on my HTML page, it always shows as blank.
I have tried using both the stripslashes() and the html_entity_decode()
but it still shows as blank.

An code example I am trying is as follows:
<?php
echo
stripslashes(html_entity_decode($my_variable_from_ a_mysql_database));
?>

How can I display this please???

Tks,
Don

Hmm.. my first intuition is to ask: are you sure the quotes are in the
database ? (i.e. they haven't been removed when inserting)
Have you looked at the database through phpMyAdmin or any such tool ?

Test what you *really* get back from the database query to make sure you
actually get the string properly from the database by doing a:
print_r($query_result);

If the quotes are there, try this for displaying:
print htmlentities(stripslashes($my_variable_from_a_mysq l_database),
ENT_QUOTES);

Good luck,
Juliette
Jun 21 '06 #2

P: n/a
On or about 6/20/2006 8:54 PM, it came to pass that Juliette wrote:
donpro wrote:
Hi,

I have a varchar field in a MySQL database that contains a line of text
like so:

"This is a line if text"

The double quotes are included in the database field.

I cannot seem to display it on my HTML page, it always shows as blank.
I have tried using both the stripslashes() and the html_entity_decode()
but it still shows as blank.

An code example I am trying is as follows:
<?php
echo
stripslashes(html_entity_decode($my_variable_from_ a_mysql_database));
?>

How can I display this please???

Tks,
Don

Hmm.. my first intuition is to ask: are you sure the quotes are in the
database ? (i.e. they haven't been removed when inserting)
Have you looked at the database through phpMyAdmin or any such tool ?

Test what you *really* get back from the database query to make sure you
actually get the string properly from the database by doing a:
print_r($query_result);

If the quotes are there, try this for displaying:
print htmlentities(stripslashes($my_variable_from_a_mysq l_database),
ENT_QUOTES);

Good luck,
Juliette

Suggest checking if magic quotes is on before doing a stripslashes
Here's how I handle comments on my site. It allows for the preservation
of both quote characters(single and double) and honors newlines
converting them to <br />

When storing the data:
if (get_magic_quotes_gpc())
{
$a = stripslashes ($_POST[Pre_Comments]);
$a = htmlspecialchars($a, ENT_QUOTES);
}
else
$a = htmlspecialchars($a, ENT_QUOTES);

On the HTML text generation after getting info from the database
nl2br($i[Pre_Comments])
Jun 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.