Advertisement
callmewhateverUwant

Delete Data From DB PDO

Jun 5th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.61 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "username";
  4. $password = "password";
  5. $dbname = "myDBPDO";
  6.  
  7. try {
  8.     $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  9.     // set the PDO error mode to exception
  10.     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  11.  
  12.     // sql to delete a record
  13.     $sql = "DELETE FROM MyGuests WHERE id=3";
  14.  
  15.     // use exec() because no results are returned
  16.     $conn->exec($sql);
  17.     echo "Record deleted successfully";
  18.     }
  19. catch(PDOException $e)
  20.     {
  21.     echo $sql . "<br>" . $e->getMessage();
  22.     }
  23.  
  24. $conn = null;
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement