<?php

function convertToHoursMins($time, $format = '%02d:%02d') {
    if ($time < 1) {
        return;
    }
    $hours = floor($time / 60);
    $minutes = ($time % 60);
    return sprintf($format, $hours, $minutes);
}

// parametri del db

$host = "localhost";
$user = "root";
$password = "Emanuela1!";
$db = "casper";


// connessione
$mysqli = new mysqli($host, $user, $password, $db);

// errore connessione
if ($mysqli->connect_error){
	die('Errore di connessione (' . $mysqli->connect_errno . ') '
        . $mysqli->connect_error);
    }

	// $query seleziona i campi da prelevare dal db
	$query = "SELECT * FROM ivao";
		//$result contiene la restituzione del dato
		$result = $mysqli->query($query);

		//stampa il risultato in una tabella (mysqli_fetch_array preleva e salva in array )
		echo "<table>
						<tr>
							<th>Callsign</th>
								<th>Ivao Vid</th>
									<th>Nome e Cognome</th>
											<th>Minuti e Ore di volo</th>
														</tr>";

		while($row = mysqli_fetch_array ($result)) {

			$callsign = $row['Callsign'];
			$vid = $row['VID'];
			$name = $row['Name'];
			$time_minuti = convertToHoursMins($row['timeTot']);


			echo "<tr>
						<td>".$callsign."</td>
							<td>".$vid."</td>
								<td>".$name."</td>
									<td>".$time_minuti."</td>
														</tr>";
		}


// chiusura connessione
mysqli_close($mysqli);

?>