'Edit A Survey','pagename'=>'survey_admin_edit_survey'));
if (!session_loggedin() || !user_ismember($group_id,'A')) {
echo "
Permission Denied
";
survey_footer(array());
exit;
}
if ($post_changes) {
if (!isset($survey_title) || $survey_title == "")
{
$feedback .= ' UPDATE FAILED: Survey Title Required';
}
elseif (!isset($survey_questions) || $survey_questions == "")
{
$feedback .= ' UPDATE FAILED: Survey Questions Required';
}
if (!isset($survey_id) || !isset($group_id) || $survey_id == "" || $group_id == "")
{
$feedback .= ' UPDATE FAILED: Missing Data';
}
else
{
if ($is_active) {
$is_active = 1;
} else {
$is_active = 0;
}
$sql="UPDATE surveys SET survey_title='$survey_title', survey_questions='$survey_questions', is_active='$is_active' ".
"WHERE survey_id='$survey_id' AND group_id='$group_id'";
$result=db_query($sql);
if (db_affected_rows($result) < 1) {
$feedback .= ' UPDATE FAILED ';
echo db_error();
} else {
$feedback .= ' UPDATE SUCCESSFUL ';
}
}
}
/*
Get this survey out of the DB
*/
if ($survey_id) {
$sql="SELECT * FROM surveys WHERE survey_id='$survey_id' AND group_id='$group_id'";
$result=db_query($sql);
$survey_title=db_result($result, 0, "survey_title");
$survey_questions=db_result($result, 0, "survey_questions");
$is_active=db_result($result, 0, "is_active");
}
?>
WARNING! It is a bad idea to edit a survey after responses have been posted
If you change a survey after you already have responses, your results pages could be misleading or messed up.
$rows Found";
echo /*"*/ "\n";
/* Create the headers */
echo "\n";
for ($i = 0; $i < $cols; $i++) {
printf( "%s | \n", db_fieldname($result,$i));
}
echo " ";
for ($j=0; $j<$rows; $j++) {
if ($j%2==0) {
$row_bg="white";
} else {
$row_bg="$GLOBALS[COLOR_LTBACK1]";
}
echo "\n";
echo "".db_result($result,$j,0)." | ";
for ($i = 1; $i < $cols; $i++) {
printf("%s | \n",db_result($result,$j,$i));
}
echo " ";
}
echo " "; // |
";
}
/*
Select all surveys from the database
*/
$sql="SELECT * FROM surveys WHERE group_id='$group_id'";
$result=db_query($sql);
?>
Existing Surveys