Position actuelle: Accueil> Derniers articles> [Comment extraire les informations de colonne dans les résultats de la requête de la base de données à l'aide de mysqli_result :: fetch_fields?

[Comment extraire les informations de colonne dans les résultats de la requête de la base de données à l'aide de mysqli_result :: fetch_fields?

gitbox 2025-09-16 
<span><span><span class="hljs-meta">&lt;?php</span></span><span>
</span><span><span class="hljs-comment">// Rien à voir avec le contenu de l&#39;articlePHPExemple de code</span></span><span>
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"Bienvenue à la miennePHPPage de tutoriel！"</span></span><span>;
</span><span><span class="hljs-meta">?&gt;</span></span><span>

&lt;hr&gt;

</span><span><span class="hljs-meta">&lt;?php</span></span><span>
<span class="hljs-comment">/*
titre: utiliser mysqli_result::fetch_fields Comment extraire les informations de colonne des résultats de la requête de base de données？
*/</span>

</span><span><span class="hljs-comment">// 在utiliser PHP fonctionner MySQL Lorsque la base de données，Vous devez souvent obtenir des informations sur la colonne dans les résultats de la requête，Par exemple, noms de colonnes、Type de données、Longueur, etc.。mysqli Fourni fetch_fields Méthodes pour extraire facilement ces informations。</span></span><span>

</span><span><span class="hljs-comment">// 1. Connectez-vous à la base de données</span></span><span>
</span><span><span class="hljs-variable">$servername</span></span><span> = </span><span><span class="hljs-string">"localhost"</span></span><span>;
</span><span><span class="hljs-variable">$username</span></span><span> = </span><span><span class="hljs-string">"root"</span></span><span>;
</span><span><span class="hljs-variable">$password</span></span><span> = </span><span><span class="hljs-string">""</span></span><span>;
</span><span><span class="hljs-variable">$database</span></span><span> = </span><span><span class="hljs-string">"test_db"</span></span><span>;

</span><span><span class="hljs-variable">$mysqli</span></span><span> = </span><span><span class="hljs-keyword">new</span></span><span> </span><span><span class="hljs-title function_ invoke__">mysqli</span></span><span>(</span><span><span class="hljs-variable">$servername</span></span><span>, </span><span><span class="hljs-variable">$username</span></span><span>, </span><span><span class="hljs-variable">$password</span></span><span>, </span><span><span class="hljs-variable">$database</span></span><span>);

</span><span><span class="hljs-keyword">if</span></span><span> (</span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;connect_error) {
    </span><span><span class="hljs-keyword">die</span></span><span>(</span><span><span class="hljs-string">"Échec de la connexion: "</span></span><span> . </span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;connect_error);
}

</span><span><span class="hljs-comment">// 2. Exécuter une requête</span></span><span>
</span><span><span class="hljs-variable">$sql</span></span><span> = </span><span><span class="hljs-string">"SELECT id, name, email FROM users"</span></span><span>;
</span><span><span class="hljs-variable">$result</span></span><span> = </span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">query</span></span><span>(</span><span><span class="hljs-variable">$sql</span></span><span>);

</span><span><span class="hljs-keyword">if</span></span><span> (</span><span><span class="hljs-variable">$result</span></span><span>) {
    </span><span><span class="hljs-comment">// 3. utiliser fetch_fields Extraire les informations sur la colonne</span></span><span>
    </span><span><span class="hljs-variable">$fields</span></span><span> = </span><span><span class="hljs-variable">$result</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">fetch_fields</span></span><span>();

    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;h2&gt;Informations sur la colonne des résultats de requête：&lt;/h2&gt;"</span></span><span>;
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;ul&gt;"</span></span><span>;
    </span><span><span class="hljs-keyword">foreach</span></span><span> (</span><span><span class="hljs-variable">$fields</span></span><span> </span><span><span class="hljs-keyword">as</span></span><span> </span><span><span class="hljs-variable">$field</span></span><span>) {
        </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;li&gt;"</span></span><span>;
        </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"Nom de liste: "</span></span><span> . </span><span><span class="hljs-variable">$field</span></span><span>-&gt;name . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
        </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"Nom de table: "</span></span><span> . </span><span><span class="hljs-variable">$field</span></span><span>-&gt;table . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
        </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"Type de données: "</span></span><span> . </span><span><span class="hljs-variable">$field</span></span><span>-&gt;type . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
        </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"longueur: "</span></span><span> . </span><span><span class="hljs-variable">$field</span></span><span>-&gt;length . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
        </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"最大longueur: "</span></span><span> . </span><span><span class="hljs-variable">$field</span></span><span>-&gt;max_length . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
        </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;/li&gt;&lt;br&gt;"</span></span><span>;
    }
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;/ul&gt;"</span></span><span>;

    </span><span><span class="hljs-comment">// 4. Itérer sur l&#39;ensemble de résultats</span></span><span>
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;h2&gt;Données de résultat de requête：&lt;/h2&gt;"</span></span><span>;
    </span><span><span class="hljs-keyword">while</span></span><span> (</span><span><span class="hljs-variable">$row</span></span><span> = </span><span><span class="hljs-variable">$result</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">fetch_assoc</span></span><span>()) {
        </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"ID: "</span></span><span> . </span><span><span class="hljs-variable">$row</span></span><span>[</span><span><span class="hljs-string">'id'</span></span><span>] . </span><span><span class="hljs-string">", Name: "</span></span><span> . </span><span><span class="hljs-variable">$row</span></span><span>[</span><span><span class="hljs-string">'name'</span></span><span>] . </span><span><span class="hljs-string">", Email: "</span></span><span> . </span><span><span class="hljs-variable">$row</span></span><span>[</span><span><span class="hljs-string">'email'</span></span><span>] . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
    }

    </span><span><span class="hljs-variable">$result</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">free</span></span><span>();
} </span><span><span class="hljs-keyword">else</span></span><span> {
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"La requête a échoué: "</span></span><span> . </span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;error;
}

</span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;</span><span><span class="hljs-title function_ invoke__">close</span></span><span>();

<span class="hljs-comment">/*
Résumer：
- mysqli_result::fetch_fields() Peut renvoyer un tableau contenant toutes les informations de colonne。
- Chaque élément de tableau est un objet，包含Nom de liste(name)、Nom de table(table)、Type de données(type)、longueur(length)etc.。
- Ceci génère dynamiquement des tables、Très utile lors de l&#39;exportation de données ou des structures de base de données de débogage。
*/</span>
</span><span><span class="hljs-meta">?&gt;</span></span><span>
</span></span>
Connexe
Derniers articles