Advertisement
Guest User

Untitled

a guest
May 19th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. <?php
  2. $myPDO = new PDO('sqlite:trying.db');
  3.  
  4. //INSERT C
  5. $sql = "INSERT INTO config (configname, value) VALUES ('Doe', 'john@example.com')";
  6. $stmt = $myPDO->query($sql);
  7.  
  8. //SELECT R
  9. $sql = "SELECT * FROM config";
  10. $stmt = $myPDO->query($sql);
  11. $return = [];
  12. while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
  13. array_push($return, $row);
  14. }
  15. echo "Select: ";
  16. print_r($return);
  17.  
  18. //UPDATE U
  19. $sql = "UPDATE config SET value='cambiado' WHERE id=14";
  20. $stmt = $myPDO->query($sql);
  21.  
  22. //DELETE D
  23. $sql = "DELETE FROM config WHERE id=13";
  24. $stmt = $myPDO->query($sql);
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement