include ("connect.php");
?>
Registered participants
$n=0;$nc=0;
header('Content-Type: text/html; charset=utf-8');
$query = "SELECT * FROM registrati ORDER BY surname;";
$result = $connect->query($query);
while ($row = mysqli_fetch_array($result)) {
$cname = ucwords($row[name]);
$csurname = ucwords($row[surname]);
echo "$cname $csurname ($row[institution]) ";
$n++;
if ($row['abstract']) {
echo " (poster) ";
$nc++;
}
echo "
";
}
echo "
Number of registered participants: $n
Number of posters: $nc
";
?>