<?php $link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* Vérification de la connexion */ if (mysqli_connect_errno()) { printf("Echec de la connexion : %s\n", mysqli_connect_error()); exit(); }
$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";
if ($result = mysqli_query($link, $query)) {
/* Récupération des informations du champ pour la 2ème colonne */ mysqli_field_seek($result, 1); $finfo = mysqli_fetch_field($result);
printf("Nom : %s\n", $finfo->name); printf("Table : %s\n", $finfo->table); printf("Longueur Max. : %d\n", $finfo->max_length); printf("Flags : %d\n", $finfo->flags); printf("Type : %d\n\n", $finfo->type);
mysqli_free_result($result); }
/* Fermeture de la connexion */ mysqli_close($link); ?>
|