我正在尝试使用 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
}