// Create a CVS text area echo "<tr><td colspan='" . count($all_field_names) . "'>"; echo implodeintotextarea($all_field_names); echo "</td></tr>"; } else { if (isset($_POST['rm_table'])) { // Create a Table (which needs to be saved) echo explodeintotexttable($all_field_names); echo "<tr><td colspan='" . count($all_field_names) . "'><span id='invalid'>Table is not saved</span><td></tr>"; } else { // Create a table based on SQL query $error_messages = updatetextinputs($table_name, 'lvef', '/^\\d+$/', false, 'study_id', $session_id, $error_messages, "Must be an integer"); $error_messages = updatetextinputs($table_name, 'end_diastolic_frame_number', '/^\\d+$/', false, 'study_id', $session_id, $error_messages, "Must be an integer"); $error_messages = updatetextinputs($table_name, 'end_systolic_frame_number', '/^\\d+$/', false, 'study_id', $session_id, $error_messages, "Must be an integer"); $error_messages = updatetextinputs($table_name, 'time_per_frame_ms', '/^\\d+$/', false, 'study_id', $session_id, $error_messages, "Must be an integer"); $error_messages = updatetextinputs($table_name, 'first_point_on_lv_curve', '/^\\d+$/', false, 'study_id', $session_id, $error_messages, "Must be an integer"); $query = sprintf('SELECT study_id, lvef, end_diastolic_frame_number, end_systolic_frame_number, time_per_frame_ms, first_point_on_lv_curve FROM muga_data WHERE session_id=%d', $session_id); $select_result = my_query($query); echo explodeintotextinputs($field_names, $hidden_field_names, $select_result, $error_messages); $count_errors = count($error_messages); if ($count_errors == 0) { $query = sprintf('UPDATE ' . $table_name . ' SET is_valid=1 WHERE session_id=%d', $session_id); } else { $query = sprintf('UPDATE ' . $table_name . ' SET is_valid=0 WHERE session_id=%d', $session_id); } $result = my_query($query); } } ?> </table>
$hidden_field_names = array('study_id'); $all_field_names = array_merge($hidden_field_names, $field_names); if (isset($_POST['rm_csv'])) { // Create a CVS text area echo "<tr><td colspan='" . count($all_field_names) . "'>"; echo implodeintotextarea($all_field_names); echo "</td></tr>"; } else { if (isset($_POST['rm_table'])) { // Create a Table (which needs to be saved) echo explodeintotexttable($all_field_names); echo "<tr><td colspan='" . count($all_field_names) . "'><span id='invalid'>Table is not saved</span><td></tr>"; } else { // Create a table based on SQL query $error_messages = updatetextinputs($table_name, 'uptake_right', '/^\\d+$/', false, 'study_id', $session_id, $error_messages, "Must be an integer"); $error_messages = updatetextinputs($table_name, 'uptake_left', '/^\\d+$/', false, 'study_id', $session_id, $error_messages, "Must be an integer"); $query = sprintf('SELECT study_id, uptake_left, uptake_right FROM wwsf_data WHERE session_id=%d', $session_id); $select_result = my_query($query); echo explodeintotextinputs($field_names, $hidden_field_names, $select_result, $error_messages); $count_errors = count($error_messages); if ($count_errors == 0) { $query = sprintf('UPDATE ' . $table_name . ' SET is_valid=1 WHERE session_id=%d', $session_id); } else { $query = sprintf('UPDATE ' . $table_name . ' SET is_valid=0 WHERE session_id=%d', $session_id); } $result = my_query($query); } } ?> </table>