Wednesday, 11 July 2018

Delete Data In from table usin php mysqli

Delete Data In from table usin php mysqli

Look at the following "Persons" table:
FirstNameLastNameAge
PeterGriffin35
GlennQuagmire33


The following example deletes all the records in the "Persons" table where LastName='Griffin':
<?php
$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

mysqli_query($con,"DELETE FROM Persons WHERE LastName='Griffin'");

mysqli_close($con);
?>


After the deletion, the table will look like this:
FirstNameLastNameAge
GlennQuagmire

0 comments:

Post a Comment