Jump to content

status update form EDIT functionality


powpow

Recommended Posts

Hello Freaks,

 

I am currently working on a status report web application.  A user inputs what they are planning on accomplishing that week.  Afterwords realizes that they made a mistake and need to correct it.  The way I want to go about this is sql the database and return * where the username and report date are current.

 

With the results of this query I insert them into the form as the value.  This yields a populated form.  From here I want the user to be able to change any line and submit the whole form.  However, the post array is only populated with one row of data.  I thought this might have to do with the names of the inputs all being the same so i tried to index those through the while loop with no luck.

 

Any help would be appreciated!

 

here's the code

 

 

<?
// renaming sess var
$UAID = $_SESSION['UAID'];
$WEND = $_SESSION['WEEK_ENDING2'];

//have we submitted our changes?
if($EDIT == TRUE){

//how many task are there this week
$results = mysql_query("Select COUNT(UAID) FROM `WPFTW` where UAID ='$UAID' and Rend = '$WEND'");
$row = mysql_fetch_row($results);

//clean $_POST 
print_r($_POST);
unset($_POST['Report']);
echo "<br>";
print_r($_POST);

}
//what do we plan on editing
$results = mysql_query("Select * FROM `WPFTW` where UAID ='$UAID' and Rend = '$WEND'");

//while there are results
while($row = mysql_fetch_array($results)){

//increment for input name
$k = 1;

//date formatting
list($year,$month,$day) = explode("-",$row['Target']);
$row['Target'] = $month."-".$day."-".$year;

//empty string to uncheck checkboxes
$checked = "";

//populate checkboxes
if($row['MS'] == "on"){
$checked = "yes";
}

//select the correct drop down menu option
if(isset($row['Status'])){
        if($row['Status'] == " "){
        $selected = "selected";
        $selected1 = "";
        $selected2 = "";
        $selected3 = "";
        }

        elseif($row['Status'] == "P"){

        $selected = "";
        $selected1 = "selected";
        $selected2 = "";
        $selected3 = "";
        }

        elseif($row['Status'] == "C"){

        $selected = "";
        $selected1 = "";
  	$selected2 = "selected";
        $selected3 = "";
        }

        elseif($row['Status'] == "CL"){

        $selected = "";
        $selected1 = "";
        $selected2 = "";
        $selected3 = "selected";
        }
}

//select the correct drop down menu option
if(isset($row['OT'])){
        if($row['OT'] == "Y"){
        $selected4 = "selected";
        $selected5 = "";
        }

        elseif($row['OT'] == "N"){

        $selected4 = "";
        $selected5 = "selected";
        }
}

//var to send form to self
$cani = htmlentities($_SERVER['PHP_SELF']);

//concatenate html & php for form
$test =  "<form id =\"2bigform\" action=$cani method = \"post\">" . "<tr>" .
        "<td><input id=\"hidden\" name=\"UAID$k\" type=\"hidden\" value=" . $_SESSION['UAID'] ."></td>".
        "<td width=\"7%\"> <input id=\"SR\#$k\" name=\"SR#\" type=\"text\" size=\"10%\" maxlength=\"10\" value=" . $row['SRNUM'] . "></td>" .
        "<td width=\"63%\"> <input id=\"Task$k\" name=\"Task\" type=\"textarea\" size=\"63%\"  value=" . $row['Task'] . "></td>" .
        "<td width=\"7%\"> <select id=\"Status$k\" name=\"Status\">".
                                                        " <option value=\" \" $selected></option>".
                                                        " <option value=\"P\" $selected1>P</option>".
                                                        " <option value=\"C\" $selected2>C</option>".
                                                        " <option value=\"CL\" $selected3>CL</option>".
                                                        "</select></td>".

        "<td width=\"7%\"> <input id=\"MS$k\" name=\"MS\" type=\"checkbox\" size=\"7%\"  value=" . $row['MS'] . " checked = $checked></td>".
        "<td width=\"7%\"> <select id=\"OT$k\" name=\"OT\">".
                                                        " <option value=\"Y\" $selected4>Y</option>".
                                                        " <option value=\"N\" $selected5>N</option>".
                                                        "</select></td>".

     "<td width=\"9%\"> <input id=\"Target$k\" name=\"Target\" type=\"text\" size=\"9%\"  value=" . $row['Target'] . "></td>".
        "<input id=\"hidden\" name=\"RDate$k\" type=\"hidden\" value=" . $_SESSION['WEEK_ENDING'] ."></td></tr>";
echo $test;
$k++;
echo $k;
}
echo "</table>".
     "<input id=\"Sub\" type= \"Submit\" name=\"Report\" value= \"Submit\"/>".
     "</form>".
     "</body>".
     "</html>";

//<td width="7%"> <input id="SR#" name="SR#" type="text" size="10%" maxlength="10"/></td>
//<td width="63%"> <input id="Task" name="Task"  type="textarea" size= "63%"/></td>






}
?>

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.