Code: Select all
$query = "INSERT INTO admin (firstname, lastname, phone, postcode, email, password, hintquestion, hintanswer, usertype, status) VALUES (:firstname, :lastname, :phone, :postcode, :email, :password, :hintquestion, :hintanswer, :usertype, :status)";
$usertype = "customer";
$status = "live";
$stmt = $pdo->prepare($query);
$stmt->execute(array(':firstname' => $firstname, ':lastname' => $lastname, ':phone' => $phone, ':postcode' => $postcode, ':email' => $email, ':password' => $password, ':hintquestion' => $hintquestion, ':hintanswer' => $hintanswer, ':usertype' => $usertype, ':status' => $status));
$newid = $stmt->lastInsertId();What have I missed?