Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

PHP MySQL Delete


PHP mysql_query() function is used to delete record in a table. Since PHP 5.5, mysql_query() function is deprecated. Now it is recommended to use one of the 2 alternatives.

  • mysqli_query()
  • PDO::__query()

PHP MySQLi Delete Record Example

Example

  1. <?php
  2. $host = ‘localhost:3306’;
  3. $user = ;
  4. $pass = ;
  5. $dbname = ‘test’;
  6. $conn = mysqli_connect($host$user$pass,$dbname);
  7. if(!$conn){
  8.   die(‘Could not connect: ‘.mysqli_connect_error());
  9. }
  10. echo ‘Connected successfully<br/>’;
  11. $id=2;
  12. $sql = “delete from emp4 where id=$id”;
  13. if(mysqli_query($conn$sql)){
  14.  echo “Record deleted successfully”;
  15. }else{
  16. echo “Could not deleted record: “. mysqli_error($conn);
  17. }
  18. mysqli_close($conn);
  19. ?>

Output:

Connected successfully
Record deleted successfully

Comments

comments