<?php $dsn = 'mysql:host=localhost;dbname=dbpdo'; $user = 'gean'; $pass = '123456'; $conexao = new PDO($dsn, $user, $pass); $conexao->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); var_dump($conexao); echo '<hr>'; /* Inserção de registro */ // $valores = "('Alice', 'alice@exemplo.org', '123456'),('Bob', 'bob@exemplo.org', '123456')"; // $insert = "INSERT INTO usuarios(nome, email, senha) VALUES(?, ?, ?)"; // $execInsert = $conexao->prepare($insert); // $valores = [ // 'Alice', // 'alice@exemplo.org', // '321456' // ]; // $execInsert->execute($valores); // var_dump($execInsert); $insert = "INSERT INTO usuarios(nome, email, senha) VALUES(?, ?, ?)"; $execInsert = $conexao->prepare($insert); for ($x = 0; $x <= 3; $x ++) { $valores = [ "Alice $x", "alice_$x@exemplo.org", "321456" ]; $execInsert->execute($valores); } var_dump($execInsert); echo '<hr>'; $select = "SELECT * FROM usuarios WHERE id = ?"; $pdoSt = $conexao->prepare($select); $pdoSt->execute([1]); $result = $pdoSt->fetch(PDO::FETCH_ASSOC); echo '<pre>'; print_r($result); echo '</pre>'; echo '<hr>'; $select = "SELECT * FROM usuarios WHERE id > ?"; $pdoSt = $conexao->prepare($select); $pdoSt->execute([10]); $result = $pdoSt->fetchAll(PDO::FETCH_ASSOC); echo '<pre>'; print_r($result); echo '</pre>';