<?php
/* Connexion à la base de données */
$link = mysqli_connect("localhost", "username", "password");
mysqli_select_db("mydb");
/* Récupération de quelques lignes et stockage */
$query = "SELECT DINSTINCT name FROM employee ORDER BY name";
$result = mysqli_query($query) or die(mysqli_error()):
$rows = mysqli_store_result($result);
$total = mysqli_num_fields($rows);
if ($total > 0) { // il y'a au moins une ligne
/* Obtenir le dernier employé */
mysqli_data_seek($rows, mysqli_num_rows($result) -1);
$employee = mysqli_fetch_row($rows);
printf ("Nom de l'employé : %s\n", $employee[0]);
}
mysqli_free_result($rows);
?>
|