execute mysql pdo in_php – 带有IN子句的MySQL PDO

你可以像这样解决这个问题：

$nba = array();

$nba[0] = "Boston Celtics";

$nba[1] = "New York Knicks";

$nba[2] = "Houston Rockets";

$params = array(':date_int' => $limit, ':team' => $team);

$nba_teams = array();

for($i=0;$i

$nba_teams[] = ':list' . $i;

$params[':list' . $i] = $nba[$i];

}

$query = "SELECT game_id

FROM table

WHERE date_int >= :date_int

AND (home_team = :team OR away_team = :team)

AND home_team IN(".implode(',', $nba_teams).")

AND away_team IN(".implode(',', $nba_teams).")

ORDER BY game_date_int ASC

LIMIT 1";

$stmt = $db->prepare($query, $params);

$stmt->execute();

尚未测试过,但我想你知道我在尝试什么