PHP准备的语句将多个变量绑定到一个数组 - PHP prepared statement bind multiples variables to one array

PHP prepared statement bind multiples variables to one array

我正试图将变量绑定到一个数组中。目前，我有他们自己的阵列。我可能需要做些什么才能将它们绑定到一个数组中？

$catSelect = $db->prepare("SELECT... WHERE jos_categories.alias = ?");
$catSelect->bind_param('s', $category);
$catSelect->execute();
$catSelect->bind_result($contentAlias, $contentCatID, $contentTitle, $contentID);
$contentAliasArray = array();
$contentCatIDArray = array();
$contentTitleArray = array();
$contentIDArrray   = array();
while ($catSelect->fetch()) {
    $contentAliasArray[]=$contentAlias;
    $contentCatIDArray[] = $contentCatID;
    $contentTitleArray[] = $contentTitle;
    $contentIDArrray[] = $contentID;
}
$catSelect->close();

$stmt = $db->prepare("SELECT... WHERE jos_categories.alias = ?");
$stmt->bind_param('s', $category);
$stmt->execute();
$res = $stmt->get_result();
$array = $res->fetch_all();

另一种方法是将mysqli换成PDO

$stmt = $pdo->prepare("SELECT... WHERE jos_categories.alias = ?");
$stmt->execute([$category]);
$array = $res->fetchAll();