Why doesn't PDO work?

Question

PHP

If you run the query with a regular PDO query, then it works:

$char = $page->for;

foreach( $_POST as $key => $value ){
  $value = str_replace("'", "\'", $value);
  $connect->query("UPDATE `keys` SET `value` = '$value' WHERE `name` = '$key' AND `for` = '$char'");
}

And if through prepare, then it does not work:

$char = $page->for;

    $query = $connect->prepare("UPDATE keys SET value = :v WHERE name = :n AND for = :c");
    $query->bindParam(':c', $char);

    foreach( $_POST as $key => $value ){
      $query->bindParam(':v', $value);
      $query->bindParam(':n', $key);
      $query->execute();

    }

Answer 1

Because KEYS, VALUE, NAME and FOR are MySQL reserved words . If you want to use them as table or field names, use backticks.

Answer 2

You can just pass $_POST to execute()...

Answer 3

Because sql queries are different. ` are very important