Access MySql array by column name

Question

My query looks like this:

SELECT * FROM tblName WHERE btn_group_id = 1;

Also I have array of languages $langs = array(5,7,19) the same in btn_lang_id

$btn = Array
(
    [0] => Array
        (
            [btn_id] => 1
            [btn_group_id] => 1
            [btn_lang_id] => 5
            [btn_text] => aaa1
        )

    [1] => Array
        (
            [btn_id] => 2
            [btn_group_id] => 1
            [btn_lang_id] => 7
            [btn_text] => bbb2
        )

    [2] => Array
        (
            [btn_id] => 3
            [btn_group_id] => 1
            [btn_lang_id] => 19
            [btn_text] => ccc3
        )
)

My question is how I can use this array to echo data by using btn_lang_id

foreach ($langs as $lang){
echo $btn[$lang['lang_id']]['btn_text'];
}

I want the above 3 arrays of $btn accessed by language id not by index 0,1,2. I there any way?

You can store the array serialized or in json format, and then retrieve it from the DB and unserialize or json decode. That way you can store the data and preserve the array structure. — Salvador P.
– Salvador P., Commented Sep 12, 2016 at 8:17

AddWeb Solution Pvt Ltd · Accepted Answer · 2016-09-12 13:00:34Z

1

You can create an array with the "btn_lang_id" as a key using the following code:

<?php
$langs = array(5,7,19);

$btn = array(
    '0' => array(
            'btn_id' => 1,
            'btn_group_id' => 1,
            'btn_lang_id' => 5,
            'btn_text' => 'aaa1',
        ),
    '1' => array(
            'btn_id' => 2,
            'btn_group_id' => 1,
            'btn_lang_id' => 7,
            'btn_text' => 'bbb2',
        ),
    '2' => array(
            'btn_id' => 3,
            'btn_group_id' => 1,
            'btn_lang_id' => 19,
            'btn_text' => 'ccc3',
        ),
);

$customArr = array();   
foreach($langs as $key=>$value){
  $customArr[$value] = $btn[$key];
}
print_R($customArr);
?>

answered Sep 12, 2016 at 13:00

AddWeb Solution Pvt Ltd

21.8k5 gold badges30 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Access MySql array by column name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related