PHPize Online / SQLize Online  /  SQLtest Online

<?php function saveEmail($contactId, $email){ global $pdo; try { $stmt = $pdo->prepare(" INSERT INTO emails(contact_id, email) VALUES (:contact_id, :email)"); $stmt-> bindValue(':contact_id', $contactId); $stmt-> bindValue(':email', $email); return $stmt-> execute(); } catch (PDOException $Exception ) { print_r($Exception); return false; } } saveEmail(166, 'no@mail.com'); $query = "SELECT * FROM emails;"; $stmt = $pdo->prepare($query); $stmt->execute(); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); var_export($rows);