CODE EXAMPLE FOR SQL

$nbreLivres= mysqli_num_rows($result); $all = mysqli_fetch_all($result,MYSQLI_ASSOC); mysqli_free_result($result) mysqli_close($conn);

 $nbreLivres= mysqli_num_rows($result);
      $all = mysqli_fetch_all($result,MYSQLI_ASSOC);
      mysqli_free_result($result)
      mysqli_close($conn);