Create an array in php with custom data

Navigation
1

Hi, I'm trying to create an array to save me recursive queries to mysql.

The idea is to associate the id of a record in mysql to its name and so instead of doing queries to mysql what I can do is traverse the array to show the data.

In principle, the way I thought of doing it would be with this syntax idcosa => nombre

The fact is that to do it I have to go through a loop with the query in question. But everything I find to build arrays I self generates the value of the array (the first value) and of course that data is what I need to locate the name. the code that I am using (which does not go because I do not have a dad how to do it but well, I put it in case it's worth something). 

$tallas = [];
foreach($CAtallas as $DAtallas) { $tallas = $DAtallas["id"].'=>'.$DAtallas["Conf1"]; }
  print_r($tallas);

Anyway, if someone thinks that to avoid being consulted by mysql the internal codes for the user to understand it, there is another way better than an array I am open to change the operation.

I'm trying this with flowen's answer, but it does not give me results 

$tallas = array();
foreach($tallas as $DAtallas){ 
   $tallas[$DAtallas["id"]]  = $DAtallas["Conf1"];
}

  print_r($tallas);

using the gdp code gives me these results: 

Array ( [0] => Array ( [Conf_id] => 241 [Conf_que] => Talla [Conf1] => 24 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [1] => Array ( [Conf_id] => 240 [Conf_que] => Talla [Conf1] => 25 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [2] => Array ( [Conf_id] => 239 [Conf_que] => Talla [Conf1] => 26 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [3] => Array ( [Conf_id] => 238 [Conf_que] => Talla [Conf1] => 27 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [4] => Array ( [Conf_id] => 237 [Conf_que] => Talla [Conf1] => 28 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [5] => Array ( [Conf_id] => 236 [Conf_que] => Talla [Conf1] => 29 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [6] => Array ( [Conf_id] => 235 [Conf_que] => Talla [Conf1] => 30 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [7] => Array ( [Conf_id] => 234 [Conf_que] => Talla [Conf1] => 31 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [8] => Array ( [Conf_id] => 233 [Conf_que] => Talla [Conf1] => 32 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [9] => Array ( [Conf_id] => 232 [Conf_que] => Talla [Conf1] => 33 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [10] => Array ( [Conf_id] => 129 [Conf_que] => Talla [Conf1] => 34 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [11] => Array ( [Conf_id] => 36 [Conf_que] => Talla [Conf1] => 35 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [12] => Array ( [Conf_id] => 38 [Conf_que] => Talla [Conf1] => 36 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [13] => Array ( [Conf_id] => 39 [Conf_que] => Talla [Conf1] => 37 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [14] => Array ( [Conf_id] => 59 [Conf_que] => Talla [Conf1] => 38 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [15] => Array ( [Conf_id] => 60 [Conf_que] => Talla [Conf1] => 39 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [16] => Array ( [Conf_id] => 61 [Conf_que] => Talla [Conf1] => 40 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [17] => Array ( [Conf_id] => 62 [Conf_que] => Talla [Conf1] => 41 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [18] => Array ( [Conf_id] => 63 [Conf_que] => Talla [Conf1] => 42 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [19] => Array ( [Conf_id] => 64 [Conf_que] => Talla [Conf1] => 43 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [20] => Array ( [Conf_id] => 65 [Conf_que] => Talla [Conf1] => 44 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [21] => Array ( [Conf_id] => 66 [Conf_que] => Talla [Conf1] => 45 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [22] => Array ( [Conf_id] => 67 [Conf_que] => Talla [Conf1] => 46 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [23] => Array ( [Conf_id] => 128 [Conf_que] => Talla [Conf1] => 47 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [24] => Array ( [Conf_id] => 244 [Conf_que] => Talla [Conf1] => 48 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) [25] => Array ( [Conf_id] => 243 [Conf_que] => Talla [Conf1] => 49 [Conf2] => [Conf3] => [Conf4] => [Conf5] => [Conf6] => [Conf7] => [Conf8] => [Conf9] => [Conf10] => [Conf11] => [Conf12] => [Conf13] => [Conf14] => [Conf15] => [Conf16] => [Conf17] => [Conf18] => [Conf19] => [Conf20] => [Conf21] => ) )

but it's not the format I'm trying to get ... I try to put only [Conf_id] = > [Conf1] which are the id and the name of the size.

    
asked by Killpe 28.11.2017 в 13:36
source

2 answers

3

Simply go through the array containing the records and you will assign the "id" to the key and the "Conf1" (assuming it is the name) to the value . 

$tallas = array();
foreach($CAtallas as $DAtallas){ 
   $tallas[$DAtallas["id"]]  = $DAtallas["Conf1"] ;
}
    
answered by 28.11.2017 / 13:48
source
2

I think you have already answered "Flowen", although you have not put the variable name of the array index well. The following code should work. 

$tallas = [];
foreach($CAtallas as $DAtallas) {
   $tallas[$DAtallas["Conf_id"]] = $DAtallas["Conf1"];
}
    
answered by 28.11.2017 в 14:41
How can I execute actions of a program by putting a '-' [closed] Problem when getting an Item from the List view, when the Adapter is filled by a Cursor