I have created a page where employees submits their daily status report at every end of the day so on admin page I have created 3 drop down menus first one is Select User Select Month Select Year
So a bit confused about the code to be intended I tried to create this code shown below Kindly suggest me what would be the concept I'll have to use??
<form name="form1" method="post" action="reportstat.php?show=1&uid=<?php echo $uid?>">
<label>
<p>Select User</p>
<p>
<select name="select3">
<?php
$recordset6 = mysql_query("select * from users");
while($record6 = mysql_fetch_array($recordset6)) {
echo"<option value=",$record6["uid"],">",$record6["ulogin"],"</option>";
}
?>
</select>
</P>
</label>
<label>
<p>Select Month</p>
<p>
<select name="select1">
<option value="1">January</option>
<option value="2">February</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">August</option>
<option value="9">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
</p>
</label>
<label>
<p>Select Year</p>
<p>
<select name="select2">
<option value="2004">2004</option><option value="2005">2005</option>
<option value="2006">2006</option><option value="2007">2007</option>
<option value="2008">2008</option><option value="2009">2009</option>
<option value="2010">2010</option><option value="2011">2011</option>
<option value="2012">2012</option><option value="2013">2013</option>
<option value="2014">2014</option><option value="2015">2015</option>
<option value="2016">2016</option><option value="2017">2017</option>
<option value="2018">2018</option><option value="2019">2019</option>
<option value="2020">2020</option><option value="2021">2021</option>
<option value="2022">2022</option><option value="2023">2023</option>
<option value="2024">2024</option><option value="2025">2025</option>
<option value="2026">2026</option><option value="2027">2027</option>
<option value="2028">2028</option><option value="2029">2029</option>
<option value="2030">2030</option><option value="2031">2031</option>
</select>
</p>
</label>
<label>
<input type="submit" value="Show" name="button" class="button" style="float:left;margin-left:25%;">
</label>
and here is my php code
<?php
$month = $_POST["select1"];
if($_GET["show"]==1) {
$month = $_POST["select1"];
$year = $_POST["select2"];
$user = $_POST["select3"];
}else {
$month = date("m");
$year = date("Y");
$user = $uid;
}
if($_GET["can"]==1) { $user = $_GET["cuser"]; }
$startday = 1;
if($month==1||$month==3||$month==5||$month==7||$month==8||$month==10||$month==12) {
$endday = 31;
}
if($month==4||$month==6||$month==9||$month==11) {
$endday = 30;
}
if($month==2){
if($year%4==0){
$endday = 29;
}else {
$endday = 28;
}
}
echo "<script language = 'javascript'>
form1.select1.options[",$month-1,"].selected = true;
form1.select2.options[",$year-2004,"].selected = true;
</script>";
$result3 = mysql_query("SELECT * FROM dailyreport WHERE uid='" . intval($_POST['select3']) . "'");
$row3 = mysql_fetch_array($result3);
$uname = $row3['uname'];
$uid = $row3['uid'];
$totalleads = $row3['tleads'];
$totalcomp = $row3['tcomp'];
$sales = $row3['salespd'];
$result4 = mysql_query("SELECT uname, (
select SUM(total_sales) \ SUM(total_dialed_leads) * 100
from dailyreport
) as 'sales performance', date FROM dailyreport WHERE sales_status = "approved"
");
echo $date;
echo $uname;
echo $uid;
echo $totalleads;
echo $totalcomp;
echo $sales;
$total = $result4 * $month;
echo"</table>";
echo"<label><p style='width:55%;margin-left:20%;'>Total sales in this Month</p><p>",$total,"</p><label>";
$recordset3 = mysql_query("select * from users where uid=".$user);
while($record3 = mysql_fetch_array($recordset3)){
echo"<script>
for(k=0; k< form1.select3.length; k++) {
if(form1.select3.options[k].text =='".$record3["ulogin"]."') {
form1.select3.options[k].selected = true;
}
}
</script>";
}
?>
