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
有朋自遠(yuǎn)方來,雖遠(yuǎn)必誅!
從SQL查詢中直接實(shí)現(xiàn)這個(gè)功能是不可能的,但是你可以檢索所有的數(shù)據(jù),然后重新映射數(shù)組。
使用PHP 5.5的array_column()函數(shù),你可以做類似以下的操作:
$myarray['row_choice'] = array_combine( array_column($myarray['row_choice'], 'id'), $myarray['row_choice'] );
對(duì)于較早版本的PHP,可以使用array_map()函數(shù)來代替。
$myarray['row_choice'] = array_combine( array_map( function($value) { return $value['id']; }, $myarray['row_choice'] ), $myarray['row_choice'] );
你應(yīng)該按照以下方式創(chuàng)建一個(gè)新的數(shù)組變量。
$recArr = array(); while ($records = mysqli_fetch_array($query)) { $recArr[$records['id']] = $records; } var_dump($recArr);
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?