Advertisement
Guest User

Untitled

a guest
Aug 24th, 2016
252
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 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. // prepare sql and bind parameters
  13. $sql = 'SELECT * FROM table WHERE id = :id';
  14.  
  15. $sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR =>PDO::CURSOR_FWDONLY));
  16.  
  17. $sth->execute(array(':id' => 150));
  18.  
  19.  
  20.  
  21. echo "New records created successfully";
  22. }
  23. catch(PDOException $e)
  24. {
  25. echo "Error: " . $e->getMessage();
  26. }
  27. $conn = null;
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement