Home  >  Article  >  Backend Development  >  Use mysqli_num_fields() in php to query the number of fields

Use mysqli_num_fields() in php to query the number of fields

autoload
autoloadOriginal
2021-04-29 12:37:162198browse

Use mysqli_num_fields() in php to query the number of fields

php requires frequent connection to the database. mysqli is a way to connect to the database in php. Sometimes we need to query the number of fields in the table in the database. This article will take you to take a look at the mysqli_num_fields() method.

1.Connect to the database

<?php
$servername="localhost";
$username="root";
$password="root123456";
$dbname="my_database";
$link = mysqli_connect($servername, $username, $password, $dbname);
if (mysqli_connect_errno()) {
    printf("连接失败: %s\n", mysqli_connect_error());
    exit();
}

2.Query the number of fields

$sql="select * from fate";
if ($result = mysqli_query($link,$sql)) {
    $row = mysqli_num_fields($result);
    printf("数据库中的字段.%d\n", $row);
    mysqli_free_result($result);
}
mysqli_close($link);
输出:数据库中的字段.3

The above is the detailed content of Use mysqli_num_fields() in php to query the number of fields. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn