php7中没有mysql_field_name，请问如何获得mysql结果集中指定的属性名呢？

Question

mysqli_field_name($result,2); //email
我没有找到php7中mysql_field_name的代替函数，请问怎么实现相同的效果呢？
谢谢~

Answer 1

php7 canceled support for mysql extension

If you use mysqli, you can write like this

<?php
    $link = mysqli_connect('localhost', 'root', '', 'test');
    $result = $link->query('select * from jobs');

    echo $result->fetch_field_direct(0)->name;

Answer 2

The mysql_ extension has been abandoned since php5.5. It has been removed since php7 and can be replaced with MySQLi or PDO_MySQL extension.