如何在数组中选择db next next？

Question

I need an array have 6 index ,
How to select row and check if not in an array push into? if in array then select next row till the array have 6 index

$data = array();

  for ($ii=0; $ii < 6; $ii++) { 
    $sql = "SELECT * FROM article_category WHERE category_id = :category_id ORDER BY id DESC";
    $stmt = $connect_db_article->prepare($sql);
    $stmt->bindValue(':category_id', $category_id_array[$i]);
    $stmt->execute();
    $article_category_row = $stmt->fetch(PDO::FETCH_ASSOC);
    if (!in_array($article_category_row['article_id'], $data)) {
      array_push($data, $article_category_row['article_id']);

    }
  }

Answer 1

You can just loop until sizeof($data)==6, something like;

$data = array();

$sql = "SELECT * FROM article_category WHERE category_id = :category_id ORDER BY id DESC";
$stmt = $connect_db_article->prepare($sql);
$stmt->bindValue(':category_id', $category_id_array[$i]);
$stmt->execute();
while(sizeof($data) < 6 && $article_category_row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  if (!in_array($article_category_row['article_id'], $data))
    array_push($data, $article_category_row['article_id']);
}