php - mysqli_result 值到 php 中的变量

Question

facultyname 的 Echo 显示了一个值，但 fid 没有获取值。我想将 fid 的值分配给变量。

$facultyname=$_POST['facultyname'];
echo $facultyname;

$query="SELECT fid FROM faculty WHERE fname='$facultyname'";
$fid_result=mysqli_query ($link,$query);
$finfo = mysqli_fetch_field($fid_result);
 printf("FacultyID :- %d     ",$finfo->fid);

Answer 1

将字段更改为关联

 $finfo = mysqli_fetch_field($fid_result);

至

$finfo = mysqli_fetch_assoc($fid_result);

阅读 - 供引用

Fetch field

Fetch Assoc