php mysql获取字段名

<?php
// 创建数据库连接
$mysqli = new mysqli("localhost", "username", "password", "database");

// 检查连接
if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect_error);
}

// 执行查询
$sql = "SELECT * FROM your_table";
$result = $mysqli->query($sql);

// 获取字段名
if ($result) {
    $fields = $result->fetch_fields();
    foreach ($fields as $field) {
        echo "字段名: " . $field->name . "\n";
    }
    $result->free();
}

// 关闭连接
$mysqli->close();
?>

<?php
try {
    // 创建PDO连接
    $pdo = new PDO("mysql:host=localhost;dbname=database", "username", "password");

    // 执行查询
    $stmt = $pdo->query("SELECT * FROM your_table");

    // 获取字段名
    for ($i = 0; $i < $stmt->columnCount(); $i++) {
        echo "字段名: " . $stmt->getColumnMeta($i)['name'] . "\n";
    }
} catch (PDOException $e) {
    echo "数据库连接失败: " . $e->getMessage();
}
?>