php - Mysqli 选择列名但跳过第一列

Question

我正在尝试显示与以下代码一起使用的表中的列名列表，但我希望它跳过第一列(ID 号)。如何实现？

$forms_colums = array();
$get_table_colums = mysqli_query($capital_db, "SHOW COLUMNS FROM tbl_customers ");
while ($found_table_colums = mysqli_fetch_array($get_table_colums)) {
    $forms_colums[] = $found_table_colums['Field'];
}

Answer 1

您可以将 array_shift($forms_columns) 添加到末尾，从而从数组中删除第一个元素:

$forms_colums = array();    
$get_table_colums = mysqli_query($capital_db,"SHOW COLUMNS FROM tbl_customers ");
while($found_table_colums = mysqli_fetch_array($get_table_colums))
{
    $forms_colums[] = $found_table_colums['Field'];     
}
array_shift($forms_colums);