函数只返回一个值多次

Question

I have this function:

function get_content($text_to_match) {
    $query  = "SELECT * ";
    $query .= "FROM table_name ";
    $query .= "WHERE one_column_name LIKE '%{$text_to_match}%' OR another_column_name LIKE '%{$text_to_match}%'";
    $cont = mysqli_query($connection, $query);
    if($content = mysqli_fetch_assoc($cont)) {
        return $content;
    } else {
        return null;
    }
}

But when I call it like:

  <div>
      <?php
        for ($i = 1; $i < count(get_content("text_to_match")); $i++) {
          echo '<article>' .
                 '<h3>' . get_content("text_to_match")["string1"] . '</h3>'.
                 '<p>' . get_content("text_to_match")["string2"] . '</p>' .
               '</article>';
        }
      ?>
  </div>

I only get the first match in the DB repeated as many times as the number of found items.

Where have I gone wrong?

Answer 1

With a few modifications in combination with tips from @Anant and @Unix One's answer, I arrived at this working solution:

Function definition

  function get_content($text_to_match, $multiple=false) {
        $query  = "SELECT * ";
        $query .= "FROM table_name ";
        $query .= "WHERE one_column_name LIKE '%{$text_to_match}%' OR another_column_name LIKE '%{$text_to_match}%'";
        $cont = mysqli_query($connection, $query);
        if ($multiple) {
          $content_array = [];
          while($content = mysqli_fetch_array($cont)) {
            $content_array[] = $content;
          }
          return $content_array;
        } else {
          if($content = mysqli_fetch_assoc($cont)) {
            return $content;
          } else {
            return null;
          }
        }
   }

Function calls

<?php
  /* multiple items */
  foreach(get_content("text_to_match", true) as $content) {
    echo '<article>' .
           '<h3>' . $content["string1"] . '</h3>' .
           '<p>' . $content["string2"] . '</p>' .
         '</article>';
  }
?>

<?php
  /* one item */
  echo get_content("text_to_match")["string"];
?>