How to fetch mysql data with speacial characters in PHP?

Subash Chandran 23rd November 2021 Leave a Comment

$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