如何从基于密钥数组的数据库中检索数据每个都有价值？

Question

I have an array like this

Array ( 
    [14] => 0.46902846738366
    [16] => 0.40289063077504
    [17] => 0.54903658244928 
) 

14, 16, 17 are at the same array key id of my tables that are in the database. how do I can access my information from a database table based on the key array (14, 16, 17)?

we assume that in the table there is a lot of data that is stored but I just wanted to take the data with id 14, 16, 17. The selected later from the id that I will perform mathematical operations to find the value of the highest of the three.?

Answer 1

$arry = array(14 => 0.46902846738366,16 => 0.40289063077504,17 =>0.54903658244928 );
$idarray=array_keys($arry);

"SELECT data FROM table WHERE id IN (".implode(',',$idarray).")";