0

I am looking for the result of the queries contained in this table: `

$queries = array_map(static function ($odd_task) use ($id_oeuvre): string{
    return <<<SQL
    SELECT 
        PK_ASSOC_OVRUSRTCH,
        FK_OUT_REF_USR
    FROM sc_t_assoc_ovr_usr_tch
    WHERE 
        FK_OUT_REF_TCH = {$odd_task}
    AND FK_OUT_REF_OVR = {$id_oeuvre};
    SQL;
    }, $odd_tasks);

Basically, we should be able to make an array of these loops and get the results:

$oRecordset = mysqli_query($queries[0], $oConnexion);
while($fetch = mysqli_fetch_object($oRecordset)){
    $pk_usr_tch_missing1 = $fetch->PK_ASSOC_OVRUSRTCH;
    $user_missing1 = $fetch->FK_OUT_REF_USR;
}
$oRecordset = mysqli_query($queries[1], $oConnexion);
while($fetch = mysqli_fetch_object($oRecordset)){
    $pk_usr_tch_missing2 = $fetch->PK_ASSOC_OVRUSRTCH;
    $user_missing2 = $fetch->FK_OUT_REF_USR;
}

`

I would like to iterate over that future table and get the results of the requests that are contained within it as strings.

Your Common Sense
  • 156,878
  • 40
  • 214
  • 345
Eferra83
  • 1
  • 2

0 Answers0