Jordan Savant # Software Engineer

Doing IN statements in PDO is annoying. Do it like this:

/**
 * Put this result into your SQL such as:
 * $in = Mysql::getInStatement([1, 2, 4]);
 * "WHERE ID IN ($in)"
 * And execute in pdo with passing the list as the params
 */
public static function getInStatement($list)
{
    $in = str_repeat('?,', count($list) - 1) . '?';
    return $in;
}
$in = str_repeat('?,', count( $args ) - 1) . '?';
$res = PDOWrapper::executeSelect("SELECT contentId, contentAlias from LB_Content WHERE contentId IN ($in)", $args);