Группировка по 4, 10 и 20
Как я могу сгруппировать их по 16, потому что он просто бросает мне весь список ничего другого.
<?php
$connect = new mysqli(
"localhost",
"healtha2_syste26",
"*********",
"healtha2_iyf"
) or die (mysqli_error());
$query=$connect->query(
"SELECT Nombre, Edad, Sexo, Grupo, Hospedaje
FROM registros
WHERE edad BETWEEN 11 AND 17
AND Sexo = 'FEMENINO'
AND Hospedaje = 'Si'
ORDER BY Hospedaje "
);
$first_fetch=$query->fetch_array(MYSQLI_ASSOC);
//echo $first_fetch['Nombre']."===>".$first_fetch['Grupo']."\n--------------------\n";
while($row=$query->fetch_array(MYSQLI_ASSOC)){
echo $row['Nombre'] . " " . $row['Edad'] . " " .
$row['Sexo'] . " " . $row['Grupo'] . " " .
$row['Hospedaje'] . "<br/>";
for ($row = 1; $row <= 16; $row++){
}
}
2
Author: alo Malbarez, 2019-07-23
1 answers
Оператор модуль %
может быть полезно:
$idx = 0;
while( $row = $query->fetch_array( MYSQLI_ASSOC ) ){
$idx++;
echo $idx . ") ".
$row['Nombre'] . " " . $row['Edad'] . " " .
$row['Sexo'] . " " . $row['Grupo'] . " " .
$row['Hospedaje'] . "<br/>".PHP_EOL;
if ( 0 == $idx % 4 ) {
echo PHP_EOL.'<hr/>'.PHP_EOL;
}
}
0
Author: alo Malbarez, 2019-07-24 00:05:25