Final Study

Question 1

What does the syntax of a prepared statement look like?

Answer 1

$id = filter_input(INPUT_POST, “id”, FILTER_SANITIZE_SPECIAL_CHARS); $command=”DELETE FROM polls WHERE ID=?”;
$stmt = $dbh->prepare($command);
$userParams = [$deleteid];
$stmt->execute($userParams);

Question 2

How does the dbo try catch block look?

Answer 2

Try {
$dbh = new Dbo(....);
} catch ($e) {
    die(“Could not connect”);
}

Question 3

How do you check if a prepared statement was properly executed or not?

Answer 3

If (!execute([$1, $2, $3...]){
      Echo “error not executed”;
} else {
      Echo “execution successful”;
}