PHP从MySQL替换表情符号无法循环

Question

我的表情符号语法编码有问题。第一篇文章也可以替换，下一篇文章就不能替换了。它也没有循环。

您可以在以下位置看到图片:

http://postimg.org/image/srph22j8d/

# POPULATED EMOTICON
    $sqlEMO = "SELECT * FROM apprtcfg WHERE obj_typ = 'EMO' ORDER BY id ASC;";
    $queryEMO = mysql_query($sqlEMO);

    while ($rsltEmo=mysql_fetch_array($queryEMO)) {

        $emo_code = $rsltEmo['obj_link'];
        $emo_img = $rsltEmo['obj_source'];
    }

    echo $content = str_replace($emo_code,'<img src="image/'.$emo_img.'">', $row['content']);

Answer 1

你应该用图像代替你的情绪，在 while 内，并在 while 结束后回应它。

$sqlEMO = "SELECT * FROM apprtcfg WHERE obj_typ = 'EMO' ORDER BY id ASC;";
$queryEMO = mysql_query($sqlEMO);

$content = $row['content'];
while ($rsltEmo=mysql_fetch_array($queryEMO)) {

        $emo_code = $rsltEmo['obj_link'];
        $emo_img = $rsltEmo['obj_source'];
        $content = str_replace($emo_code,'<img src="image/'.$emo_img.'">', $content);
}

echo $content;