echoing text from mysql with apostrophes

Question

Hello I'm trying to echo some text that I put into mysql that contains apostrophes. However whenever I try to echo the text out the apostrophes are replaced with boxes.

if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$query = "SELECT * FROM rules";
$result = mysqli_query($link, $query);

while($row =  $result->fetch_array()) {
    echo '<article class="content grid_10 push_1">';

    echo '<h1>';
    echo $row['title'];
    echo '</h1>';

    echo '<section>';

    echo nl2br(stripslashes($row['post']));

    echo '</section>';
    echo '</article>';

}?>

You might have an encodIng issue. There is a meta tag for the head to define the encodIng type. — Meneer Venus, May 29 '14 at 19:51
The Encoding for the text is set to default latin1_swedish_ci I'll try urlencode to see if that works — user3687047, May 29 '14 at 19:56
apostrophes? do you mean diacritical marks such as é and è ? — nl-x, May 29 '14 at 19:57
cant see what you expect urlencode to do here its for url's after all — , May 29 '14 at 19:57
I just figured it out. I was using ` instead of '. However I still don't want ` outputting as boxes. Is there a fix for this — user3687047, May 29 '14 at 20:01
@user3687047 it's probably also not a `\`` , but some fancy Microsoft Word alternative. The normal `\`` should not be sensitive for the charset, IMHO — nl-x, May 29 '14 at 20:04
assuming we are correct, i would fix them befor they go in to the db: http://stackoverflow.com/questions/1262038/how-to-replace-microsoft-encoded-quotes-in-php?lq=1 — , May 29 '14 at 20:09
mysqli_set_charset() http://www.php.net/manual/en/mysqli.set-charset.php — fortune, May 29 '14 at 20:10

score 0 · Answer 1 · answered May 29 '14 at 20:01

Try this (encoding with utf-8):

if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$query = "SELECT * FROM rules";
$result = mysqli_query($link, $query);

while($row =  $result->fetch_array()) {
    echo '<article class="content grid_10 push_1">';

    echo '<h1>';
    echo utf8_encode($row['title']);
    echo '</h1>';

    echo '<section>';

    echo nl2br(stripslashes(utf8_encode($row['post'])));

    echo '</section>';
    echo '</article>';

}?>

echoing text from mysql with apostrophes

1 Answers1