How to fetch mysql data with speacial characters in PHP?
$sql2 = "SELECT name,email,contact FROM tbl_leadads"; $result = mysqli_query($conn, $sql2); //print_r($result);die; if (mysqli_num_rows($result) > 0) { echo "<table><thead><tr><th>NAME</th><th>EMAIL</th><th>CONTACT</th></tr></thead>"; // output data of each row while($row = mysqli_fetch_assoc($result)) { //echo htmlspecialchars($row["name"]); echo "<tr><td>".htmlentities($row["name"])."</td><td>".$row["email"]."</td><td> ".htmlentities($row["contact"])."</td></tr>"; } echo "</table>"; } else { echo "0 results"; } mysqli_close($conn); #try this echo htmlspecialchars($string); or echo htmlentities($string); //https://www.geeksforgeeks.org/htmlentities-vs-htmlspecialchars-function-in-php/#:~:text=htmlspecialchars()%20function%20convert%20the,applicable%20characters%20to%20HTML%20entities