从MySQL数据库中的css标记中删除智能引号

Question

I've imported a Word document into a MySQL database, [utf8_general_ci]. One column has html code:

<p class=“hangi”><b>Robert ALGAR</b>, b. 1435.</p>

These smart quotes do not work in internet browsers. The PHP code that I tried to change them to block quotes is not working, i.e. not detecting the curly quotes and changing them to block quotes:

    $sql =  "UPDATE  `lwadb`.`ancestorIndex` SET  `descendants`='".$this->convert_smart_quotes($desc)."' WHERE `ancestorIndex`.`surname` ='".$entry."';";
$result = $conn->query($sql);
if($result) {echo "</br>ENTRY UPDATEED";}
else{echo "Error updating record: ";  print_r($this->mysqli->error_list);}
}

function convert_smart_quotes($string) { 
    $search = array(chr(145), chr(146), chr(147), chr(148), chr(151)); 
    $replace = array("'", "'", '"', '"', '-'); 
    return str_replace($search, $replace, $string); 
} 

Answer 1

I do not see a problem here. Just replace those two quote characters:

<?php
$input = '<p class=“hangi”><b>Robert ALGAR</b>, b. 1435.</p>';
$output = str_replace(['“','”'], '"', $input);
echo $output;