$db = get_PDO();

for ($i = 0; $i < count($names); $i++) {
  $sql = "INSERT INTO presidents(name, year, vice_president) "
         . "VALUES (:name, :year, :vice_president);";
  $stmt = $db->prepare($sql);
  $params = array("name" => $names[$i],
                  "year" => $year[$i],
                  "vice_president" => $vice_president[$i],);
  $stmt->execute($params);
}

CREATE TABLE presidents(
   id INT NOT NULL AUTO_INCREMENT,
   name VARCHAR(255),
   year INT,
   vice_president VARCHAR(255),
   PRIMARY KEY(id)
);