Rapide Advanced Adulte
 
 Web|Image|Shop|Video|News|Wmx|Mobile|Wiki|Ajouter ce moteur

     Manuel PHP     
Partager
 
 
Partager
Partager

 

Table :

.mysqli affected rows
.mysqli autocommit
.mysqli bind param
.mysqli stmt bind param()
.mysqli bind result
.mysqli stmt bind result()
.mysqli change user
.mysqli character set name
.mysqli client encoding
.mysqli character set name()
.mysqli close
.mysqli commit
.mysqli connect errno
.mysqli connect error
.mysqli connect
.mysqli data seek
.mysqli debug
.mysqli disable reads from master
.mysqli disable rpl parse
.mysqli dump debug info
.mysqli embedded server end
.mysqli embedded server start
.mysqli enable reads from master
.mysqli enable rpl parse
.mysqli errno
.mysqli error
.mysqli escape string
.mysqli real escape string()
.mysqli execute
.mysqli stmt execute()
.mysqli fetch array
.mysqli fetch assoc
.mysqli fetch field direct
.mysqli fetch field
.mysqli fetch fields
.mysqli fetch lengths
.mysqli fetch object
.mysqli fetch row
.mysqli fetch
.mysqli stmt fetch()
.mysqli field count
.mysqli field seek
.mysqli field tell
.mysqli free result
.mysqli get charset
.mysqli get client info
.mysqli get client version
.mysqli get host info
.mysqli get metadata
.mysqli stmt result metadata()
.mysqli get proto info
.mysqli get server info
.mysqli get server version
.mysqli get warnings
.mysqli info
.mysqli init
.mysqli insert id
.mysqli kill
.mysqli master query
.mysqli more results
.mysqli multi query
.mysqli next result
.mysqli num fields
.mysqli num rows
.mysqli options
.mysqli param count
.mysqli stmt param count()
.mysqli ping
.mysqli prepare
.mysqli query
.mysqli real connect
.mysqli real escape string
.mysqli real query
.mysqli report
.mysqli rollback
.mysqli rpl parse enabled
.mysqli rpl probe
.mysqli rpl query type
.mysqli select db
.mysqli send long data
.mysqli stmt send long data()
.mysqli send query
.mysqli server end
.mysqli server init
.mysqli set charset
.mysqli set local infile default
.mysqli set local infile handler
.mysqli set opt
.mysqli options()
.mysqli slave query
.mysqli sqlstate
.mysqli ssl set
.mysqli stat
.mysqli stmt affected rows
.mysqli stmt attr get
.mysqli stmt attr set
.mysqli stmt bind param
.mysqli stmt bind result
.mysqli stmt close
.mysqli stmt data seek
.mysqli stmt errno
.mysqli stmt error
.mysqli stmt execute
.mysqli stmt fetch
.mysqli stmt field count
.mysqli stmt free result
.mysqli stmt get warnings
.mysqli stmt init
.mysqli stmt insert id
.mysqli stmt num rows
.mysqli stmt param count
.mysqli stmt prepare
.mysqli stmt reset
.mysqli stmt result metadata
.mysqli stmt send long data
.mysqli stmt sqlstate
.mysqli stmt store result
.mysqli store result
.mysqli thread id
.mysqli thread safe
.mysqli use result
.mysqli warning count
 
   

  mysqli_stmt_result_metadata  


mysqli_stmt_result_metadata

(PHP 5)

mysqli_stmt_result_metadata -- Retourne les méta-données de préparation de requête MySQL

Description

Style procédural

mysqli_result mysqli_stmt_result_metadata ( mysqli_stmt stmt )

Style orienté objet (méthode)

class mysqli_stmt {

mysqli_result result_metadata ( void )

}

Si une commande a été préparée par mysqli_prepare(), et qu'elle produira un résultat, mysqli_stmt_result_metadata() retourne l'objet de résultat qui sera utilisé pour lire les méta-données, comme le nombre de champs et les informations de colonnes.

Note : Ce résultat peut être passé comme argument à toutes les fonctions qui demandent un champ, pour y lire les méta-données :

Il est recommandé de libérer la ressource de résultat lorsque vous avez terminé de l'utiliser, en la passant à la fonction mysqli_free_result()

Note : Le jeu de résultat retourné par mysqli_stmt_result_metadata() ne contient que des méta-données. Il ne contient aucune ligne de résultat. Ces lignes sont obtenues en utilisant la fonction mysqli_stmt_fetch().

Valeurs de retour

mysqli_stmt_result_metadata() retourne un objet de résultat, ou FALSE si une erreur survient.

Exemples

Exemple 1. Style orienté objet

<?php
$mysqli
= new mysqli("localhost", "utilisateur", "mot_de_passe", "base");

$mysqli->query("DROP TABLE IF EXISTS Amis");
$mysqli->query("CREATE TABLE Amis (id int, nom varchar(20))");

$mysqli->query("INSERT INTO Amis VALUES (1,'Gui'), (2, 'Yannick')");

$stmt = $mysqli->prepare("SELECT id, nom FROM Amis");
$stmt->execute();

/* Lit les méta-données de résultat */
$result = $stmt->result_metadata();

/* Lit les informations d'un champ, depuis les méta-données */
$field = $result->fetch_field();

printf("Nom du champ : %s\n", $field->nom);

/* Libération du résultat */
$result->close();

/* Fermeture de la connexion */
$mysqli->close();
?>

Exemple 2. Style procédural

<?php
$link
= mysqli_connect("localhost", "utilisateur", "mot_de_passe", "base");

mysqli_query($link, "DROP TABLE IF EXISTS Amis");
mysqli_query($link, "CREATE TABLE Amis (id int, nom varchar(20))");

mysqli_query($link, "INSERT INTO Amis VALUES (1,'Gui'), (2, 'Yannick')");

$stmt = mysqli_prepare($link, "SELECT id, nom FROM Amis");
mysqli_stmt_execute($stmt);

/* Lit les méta-données de résultat */
$result = mysqli_stmt_result_metadata($stmt);

/* Lit les informations d'un champ, depuis les méta-données */
$field = mysqli_fetch_field($result);

printf("Nom du champ : %s\n", $field->nom);

/* Libération du résultat */
mysqli_free_result($result);

/* Fermeture de la connexion */
mysqli_close($link);
?>


    Annonces       
 

 Retour au chapitre Php

 

Top
 

Ajouter JungleKey.fr à votre Explorateur

 
 

About Us | © 2007 JungleKey




iBlack | Mobile | Wiki | Ajouter ce moteur
.