Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $myPDO = new PDO('sqlite:trying.db');
- //INSERT C
- $sql = "INSERT INTO config (configname, value) VALUES ('Doe', 'john@example.com')";
- $stmt = $myPDO->query($sql);
- //SELECT R
- $sql = "SELECT * FROM config";
- $stmt = $myPDO->query($sql);
- $return = [];
- while ($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
- array_push($return, $row);
- }
- echo "Select: ";
- print_r($return);
- //UPDATE U
- $sql = "UPDATE config SET value='cambiado' WHERE id=14";
- $stmt = $myPDO->query($sql);
- //DELETE D
- $sql = "DELETE FROM config WHERE id=13";
- $stmt = $myPDO->query($sql);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement