Use the primary key value of the data as the index of the associative array to obtain the data-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW)

Use the primary key value of the data as the index of the associative array to obtain the data

王林 2023-07-16 17:41:35

7568

After executing the fetch query, I got an array of results:

[row_choice] => Array
  (
    [0] => Array
      (
        [id] => 277410
        [text_value] => Two Wheel
      )
    [1] => Array
      (
        [id] => 277411
        [text_value] => Three Wheel
      )
    [2] => Array
      (
        [id] => 277412
        [text_value] => Four Wheel
      )
  )

How do I get an array of results like this?

[row_choice] => Array
  (
    [277410] => Array
      (
        [id] => 277410
        [text_value] => Two Wheel
      )
    [277411] => Array
      (
        [id] => 277411
        [text_value] => Three Wheel
      )
    [277412] => Array
      (
        [id] => 277412
        [text_value] => Four Wheel
      )
  )

What should I do?

My question is

SELECT id,text_value FROM answer_choice

王林

有朋自远方来，虽远必诛！

reply all(2)

大瓶可乐@php.cn2023-07-17 10:37:08 2 floor

从SQL查询中直接实现这个功能是不可能的，但是你可以检索所有的数据，然后重新映射数组。

使用PHP 5.5的array_column()函数，你可以做类似以下的操作：

$myarray['row_choice'] = array_combine(
    array_column($myarray['row_choice'], 'id'),
    $myarray['row_choice']
);

对于较早版本的PHP，可以使用array_map()函数来代替。

$myarray['row_choice'] = array_combine(
    array_map(
        function($value) {
            return $value['id'];
        },
        $myarray['row_choice']
    ),
    $myarray['row_choice']
);

你应该按照以下方式创建一个新的数组变量。

$recArr = array();

while ($records = mysqli_fetch_array($query)) {
    $recArr[$records['id']] = $records;
}

var_dump($recArr);

Like +0

Add Reply

P粉8041844592023-08-09 18:49:59 1 floor

Hello, Mr. Wang, I very much agree with your skills and hope to have further communication opportunities with you. Can you please add us via WeChat or email?

Like +0

Add Reply