$qclause[] = ' ' . $c . ' = :' . $c . ' '; } echo '<TR><TD colspan="' . $num_cols . '"><B>' . implode(", ", $mvals) . '</B></TD></TR>'; $query = "SELECT * FROM " . table('participants') . "\n WHERE " . implode(" AND ", $qclause) . "\n ORDER BY creation_time"; $result = or_query($query, $pars); $shade = false; while ($p = pdo_fetch_assoc($result)) { echo '<tr class="small"'; if ($shade) { echo ' bgcolor="' . $color['list_shade1'] . '"'; } else { echo 'bgcolor="' . $color['list_shade2'] . '"'; } echo '>'; echo '<TD bgcolor="' . $color['content_background_color'] . '"></TD>'; echo participant__get_result_table_row($cols, $p); echo '</tr>'; if ($shade) { $shade = false; } else { $shade = true; } } } echo '</tbody></TABLE>'; } } else { $pform_fields = participantform__load(); $field_names = array(); foreach ($pform_fields as $f) { $field_names[$f['mysql_column_name']] = lang($f['name_lang']);
function query_show_query_result($query_arr, $type = "participants_search_active", $allow_sort = true) { global $lang, $color, $settings; $allow_edit = check_allow('participants_edit'); // prepare edit popup if (($type == 'participants_search_active' || $type == 'participants_search_all' || $type == 'participants_unconfirmed') && $allow_edit) { echo javascript__edit_popup(); } $result = or_query($query_arr['query'], $query_arr['pars']); $count_results = pdo_num_rows($result); echo '<B>' . $count_results . ' ' . lang('xxx_participants_in_result_set') . '</B>'; if ($type == 'assign') { echo '<BR>' . lang('only_ny_assigned_part_showed'); } elseif ($type == 'deassign') { echo '<BR>' . lang('only_assigned_part_ny_reg_shownup_part_showed'); } echo '<BR><BR>'; if ($type == 'participants_search_active' || $type == 'participants_search_all') { query__resulthead_participantsearch(); } elseif ($type == 'assign' || $type == 'deassign') { query__resulthead_assign($type); } if ($type == 'participants_search_active') { $cols = participant__get_result_table_columns('result_table_search_active'); } elseif ($type == 'participants_search_all') { $cols = participant__get_result_table_columns('result_table_search_all'); } elseif ($type == 'participants_unconfirmed') { $cols = participant__get_result_table_columns('result_table_search_unconfirmed'); } else { $cols = participant__get_result_table_columns('result_table_assign'); } echo '<table class="or_listtable" style="width: 95%;">'; echo '<thead>'; echo '<TR style="background: ' . $color['list_header_background'] . '; color: ' . $color['list_header_textcolor'] . ';">'; echo participant__get_result_table_headcells($cols, $allow_sort); echo '</TR>'; echo '</thead><tbody>'; $shade = false; $assign_ids = array(); while ($p = pdo_fetch_assoc($result)) { if ($type == 'participants_unconfirmed') { $assign_ids[] = $p['email']; } else { $assign_ids[] = $p['participant_id']; } echo '<tr class="small"'; if ($shade) { echo ' bgcolor="' . $color['list_shade1'] . '"'; } else { echo 'bgcolor="' . $color['list_shade2'] . '"'; } echo '>'; echo participant__get_result_table_row($cols, $p); echo '</tr>'; if ($shade) { $shade = false; } else { $shade = true; } } echo '</tbody></table>'; return $assign_ids; }