1. <?php
  2. $con=mysqli_connect("example.com","peter","abc123","my_db");
  3. // Check connection
  4. if (mysqli_connect_errno())
  5. {
  6. echo "Failed to connect to MySQL: " . mysqli_connect_error();
  7. }
  8.  
  9. mysqli_query($con,"DELETE FROM Persons WHERE LastName='Griffin'");
  10.  
  11. mysqli_close($con);
  12. ?>
  13.  
  14. UPDATE Persons
  15. set LastName = ''
  16. WHERE
  17. id = ?