Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dsn = 'mysql:host=db;dbname=pdo';
- $user = 'root';
- $password = 'secret';
- $options = [
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- ];
- try {
- $pdo = new PDO($dsn, $user, $password, $options);
- } catch (Exception $e) {
- throw new PDOException($e->getMessage());
- }
- // Query database with prepare & execute to avoid sql injection
- $stmt = $pdo->prepare('select * from users where email = :email');
- $stmt->execute([
- 'email' => 'marcin@yasiu.pl',
- ]);
- $user = $stmt->fetch();
- var_dump($user);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement