Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. u<?php
  2. $host = 'localhost:3306'; //database host
  3. $user = 'root'; // DataBase User
  4. $pass = ''; //database password
  5. $dbname = 'mydb2'; //database name
  6.  
  7. //Connection to Databse
  8. $conn = mysqli_connect($host, $user, $pass,$dbname);
  9.  
  10. // Check connection
  11. if(!$conn){
  12. die('Could not connect: '.mysqli_connect_error());
  13. }
  14. echo 'Connected successfully<br/>';
  15.  
  16. //Update the table
  17. $id=2;
  18. $sql = "delete from emp5 where id=$id";
  19.  
  20. //Checking for Deleting Table
  21. if(mysqli_query($conn, $sql)){
  22. echo "Record deleted successfully";
  23. }else{
  24. echo "Could not deleted record: ". mysqli_error($conn);
  25. }
  26.  
  27.  
  28. // Close connection
  29. mysqli_close($conn);
  30. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement