$value) {
if(preg_match("/exp_delete_id_([[:digit:]]+)/",$key,$matches)) {
$delete_expid = $matches[1];
/*$sql_experiment_form = sprintf("select * from experiment join experiment_x_form on (experiment.experiment_id = experiment_x_form.experiment_id) where experiment.experiment_id = %d",$delete_expid);
$experiment_form = mysql_query($sql_experiment_form) or die(mysql_error());
$associated_forms = false;
while(!$associated_forms && $check_form = mysql_fetch_assoc($experiment_form))
if(!in_array($check_form['form_id'],$required_form_ids))
$associated_forms = true;
if($associated_forms) {
$result_experiment_form = mysql_fetch_assoc($experiment_form);
printf("Forms are still associated with experiment \"%s.\" Remove these forms from the experiment using Experiment Editor before deleting the experiment.
",$result_experiment_form['experiment_title']);
$abort_deletion = true;
}*/
$sql_experiment_info = sprintf("select * from experiment where experiment_id = %d ",$delete_expid);
$result_experiment_info = mysql_select($sql_experiment_info);
$sql_get_responses = sprintf("select * from session where experiment_id=%d",$result_experiment_info['response_table']);
$get_responses = mysql_query($sql_get_responses) or die(mysql_error());
if(mysql_num_rows($get_responses) > 0) {
printf("Responses are still in the response table for experiment \"%s.\" Remove these responses using the Ensemble Cleaner before deleting the experiment.
",$result_experiment_info['experiment_title']);
$abort_deletion = true;
}
if(!$abort_deletion) {
printf("Peforming Queries:
");
$sql_drop_response_table = sprintf("drop table %s",$result_experiment_info['response_table']);
echo $sql_drop_response_table."
";
$drop_success = false;
$drop_success = mysql_query($sql_drop_response_table);
if($drop_success)
echo "Drop table succeeded.
";
else
echo "Drop table failed.
";
$sql_remove_required_forms = sprintf("delete from experiment_x_form where experiment_id = %d",$delete_expid);
echo $sql_remove_required_forms."
";
mysql_query($sql_remove_required_forms) or die(mysql_error());
echo mysql_affected_rows()." rows affected.
";
$sql_delete_experiment_record = sprintf("delete from experiment where experiment_id = %d",$delete_expid);
echo $sql_delete_experiment_record."
";
mysql_query($sql_delete_experiment_record) or die(mysql_error());
echo mysql_affected_rows()." rows affected.
";
$sql_delete_experiment_tickets = sprintf("delete from ticket where experiment_id = %d",$delete_expid);
echo $sql_delete_experiment_tickets."
";
mysql_query($sql_delete_experiment_tickets) or die(mysql_error());
echo mysql_affected_rows()." rows affected.
";
printf("Experiment %s successfully deleted
",$result_experiment_info['experiment_title']);
}
printf("Go to Ensemble Cleaner
",$questionnaire_location);
printf("Go to Experiment Editor
",$questionnaire_location);
}
}
?>