Created
August 19, 2025 22:58
-
-
Save uchoamaster/ab7b34be70ec829c74f971cbbf56661b to your computer and use it in GitHub Desktop.
3. Usando PDO Exemplo completo com exceções para erros.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // Parâmetros de conexão | |
| $dsn = 'mysql:host=localhost;dbname=exemplo_db'; | |
| $usuario = 'root'; | |
| $senha = ''; | |
| try { | |
| $pdo = new PDO($dsn, $usuario, $senha); | |
| $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); | |
| // INSERT | |
| $stmt = $pdo->prepare("INSERT INTO usuarios (nome, email) VALUES (:nome, :email)"); | |
| $stmt->execute([':nome' => 'Pedro Santos', ':email' => '[email protected]']); | |
| echo "Inserido ID: " . $pdo->lastInsertId() . "<br>"; | |
| // SELECT | |
| $stmt = $pdo->prepare("SELECT * FROM usuarios WHERE nome = :nome"); | |
| $stmt->execute([':nome' => 'Pedro Santos']); | |
| while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { | |
| echo "ID: " . $row['id'] . ", Nome: " . $row['nome'] . ", Email: " . $row['email'] . "<br>"; | |
| } | |
| // UPDATE | |
| $stmt = $pdo->prepare("UPDATE usuarios SET email = :email WHERE nome = :nome"); | |
| $stmt->execute([':email' => '[email protected]', ':nome' => 'Pedro Santos']); | |
| echo "Atualizado: " . $stmt->rowCount() . " registro(s)<br>"; | |
| // DELETE | |
| $stmt = $pdo->prepare("DELETE FROM usuarios WHERE nome = :nome"); | |
| $stmt->execute([':nome' => 'Pedro Santos']); | |
| echo "Deletado: " . $stmt->rowCount() . " registro(s)<br>"; | |
| } catch (PDOException $e) { | |
| echo "Erro: " . $e->getMessage(); | |
| } | |
| // Fecha (PDO fecha automaticamente no fim do script, mas pode setar null) | |
| $pdo = null; | |
| ?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment