PHP坏词替换注释系统


PHP bad word replacement comment system

我正在尝试使用 php 创建一个注释系统,用 **** 替换注释者的坏词。我正在使用sql,并且有一个包含两列的数据库,一列是坏词,另一列是替换词(即****)。到目前为止,我能够识别用户何时输入确定的坏词并检索它的替换词,但是我无法用替换词替换该坏词。我试图在 $goodWord = $row['replaceWord'] 之后做 $element = $goodWord 说应该替换新识别的坏词,但它什么也没做。我不完全确定如何在 php 中将数组中的元素设置为新值。有什么建议吗?

法典:

if(!empty($_GET["field1_name"])) {
    $field1_name = mysqli_real_escape_string($link, $_GET["field1_name"]);
    $field1_name_array = explode(" ",$field1_name);
    foreach($field1_name_array as $element){
        $query = "SELECT replaceWord FROM changeWord WHERE badWord = '$element' ";
        $query_link = mysqli_query($link,$query);
        if(mysqli_num_rows($query_link)>0){
            $row = mysqli_fetch_assoc($query_link);
            $goodWord = $row['replaceWord'];
            $element = $goodWord
        }
    }
}
if(!empty($_GET["field1_name"])) {
$field1_name = mysqli_real_escape_string($link, $_GET["field1_name"]);
$field1_name_array = explode(" ",$field1_name);
$newComment = '';
foreach($field1_name_array as $element){
    $query = "SELECT replaceWord FROM changeWord WHERE badWord = '$element' ";
    $query_link = mysqli_query($link,$query);
    if(mysqli_num_rows($query_link)>0){
        $row = mysqli_fetch_assoc($query_link);
        $goodWord = $row['replaceWord'];
        $element = $goodWord
    }
    $newComment = $newComment." ".$element; // append $element back to back to create modified comment
    }
   // now update the $newComment back to your comment Table
}