The text below is selected, press Ctrl+C to copy to your clipboard. (⌘+C on Mac) No line numbers will be copied.
Guest
Department_delete
By Guest on 4th March 2024 05:26:32 AM | Syntax: PYTHON | Views: 82


New Paste New paste | Download Paste Download | Toggle Line Numbers Show/Hide line no. | Copy Paste Copy text to clipboard
  1. <?php
  2. $dbhost='localhost';
  3. $dbuser='root';
  4. $dbpass='user@123';
  5. $dbname='BOOK';
  6.  
  7. $conn=mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
  8.  
  9. if($conn->connect_error)
  10. {
  11.   die("connection failed:".$conn->connect_error);
  12. }
  13. else
  14. {
  15.   echo "connected sucessfully";
  16. }
  17. echo "<br>";
  18. $sql="DELETE FROM DEPARTMENT WHERE location='mumbai'";
  19. if(mysqli_query($conn,$sql))
  20. {
  21.    echo "record deleted successfully";
  22.  }
  23.  else
  24.  {
  25.     echo "error:",mysqli_error($conn);
  26.   }
  27.   ?>





department delete