为什么数组返回值与数组索引值


Why array return value with array index value?

Array
(
    [0] => Array
        (
            [0] => 1
            [id] => 1
            [1] => 1
            [candi_id] => 1
            [2] => 
            [title] => 
            [3] => Lakshmanan
            [firstname] => Lakshmanan
            [4] => P
            [lastname] => P
            [5] => Male
            [gender] => Male
            [6] => Tamil
            [mothertongue] => Tamil
            [7] => 31-01-1990
            [dob] => 31-01-1990
            [8] => Hindu
            [religion] => Hindu
            [9] => O+
            [bloodgroup] => O+
            [10] => Single
            [marital_status] => Single
            [11] => Mettupalayam
            [native] => Mettupalayam
            [12] => Indian
            [nationality] => Indian
            [13] => Active
            [status] => Active
            [14] => 2016-11-04
            [cdate] => 2016-11-04
        )
)

我只想得到列值。但为什么我得到数组索引值?

首先我想说的是,mysql函数是不赞成的。因此,现在继续使用mysqliPDOmysql databse功能更好。

不带参数的mysql_fetch_array函数将输出indexcolumn-name格式的DB记录。

要获得column-name数据,您应该在mysql_fetch_array函数中传递第二个参数"MYSQL_ASSOC",或者您也可以使用mysql_fetch_assoc函数。

$result = mysql_fetch_assoc($mysql_query);