Jump to content

The option is not in dropdownlist if the check by contained data

shebbycs

By shebbycs
in PHP Coding Help

 Share
Go to solution Solved by shebbycs,

Recommended Posts

shebbycs Regular Member

shebbycs

Posted
Posted (edited) 
//countercashadminlocation.php

<?php
session_start();
if (empty($_SESSION['is_logged_in']))
{
 header("Location:login.php");
 die();     // just to make sure no scripts execute
}
?>
<?php
 	mysql_connect("localhost","root") or die(mysql_error());
    mysql_select_db("kime") or die(mysql_error());
	$a=$_SESSION['branchcodename'];
     if (isset($_POST["submit"]))
    { 
	 $place = $_POST['tempat'];
	 $_SESSION['tempat']=$place;
	 $b= $_SESSION['tempat'];
	 $sql1 = mysql_query("SELECT *,DATE_FORMAT(Form_Date, '%d/%m/%Y %H:%i %p') AS Form_Date FROM counter_cash WHERE Branch_Codename='$place' ORDER BY Form_Date") or die(mysql_error());
	 $sql2 = mysql_query("SELECT * FROM counter_cash WHERE Branch_Codename='$place'") or die(mysql_error());
     echo "<body  bgcolor='#F5D16A'>";
     echo "<center><img src ='OK.gif'></center><br>";
     echo "<center><h2>COUNTER CASH CHECKING REPORT</h2>";
	 echo "<table><tr><td><h3>LOCATION</h3></td><td><h3>:</h3></td><td><h3>".$place."</h3></td></tr></table></center>";
     echo "<center><table border = '1'>";
     echo "<tr><th rowspan='2'>ID</th><th rowspan='2'>DATE & TIME</th><th rowspan='2'>CASHIER NAME</th><th colspan='3'>COUNTER CASH</th><th colspan='3'>PETTY CASH</th><th rowspan='2'>SIGN</th><th rowspan='2'>HANDOVER      TO (NAME)</th><th rowspan='2'>SIGN</th><th rowspan='2'>CHECK BY      </th></tr>";	 
     echo "<tr><th>AMOUNT</th><th>SHORTAGE</th><th>EXCESS</th><th>AMOUNT</th><th>SHORTAGE</th><th>REMARK</th></tr>";
     while($report = mysql_fetch_array($sql1))
     {
      echo "<tr align='center'><td>".$report['ID']."</td>";
	  echo "<td>".$report['Form_Date']."</td> ";
      echo "<td>".$report['Cashier_Name']."</td> ";
      echo "<td>RM  ".$report['Counter_Amount']."</td> ";
      echo "<td>RM  ".$report['Counter_Shortage']."</td> ";
      echo "<td>RM  ".$report['Counter_Excess']."</td> ";
      echo "<td>RM  ".$report['Petty_Amount']."</td> ";
      echo "<td>RM  ".$report['Petty_Shortage']."</td> ";
      echo "<td>".$report['Petty_Remark']."</td> ";
      echo "<td>".$report['Cashier_Sign']."</td> ";
      echo "<td>".$report['Handover_Name']."</td> ";
      echo "<td>".$report['Handover_Sign']."</td> ";
	  echo "<td>".$report['Check_By']."</td> ";
	 }
	 echo"</table></center><br>";
	 echo"<center><form name='editcheckby' method='post' action='countercashadmineditcheckby.php'>";
	 echo "<table><tr><td><b>CHOOSE ID TO CHECK BY</b></td></tr><tr><td><center><select name = 'cuba'>";
	 while($checkby = mysql_fetch_array($sql2))
	{
	 echo "<option value ='".$checkby['ID']."'>".$checkby['ID']."</option>";	  
	}
	echo "</select></center></td></tr>";
	echo "<tr><td><center><input type='submit' name='submit' value='Check'></center></td></tr></table></form>"; 
	  
	  echo "<center><h3><a href='adminselect.php'>BACK</a>       <a href='logout.php'>LOG OUT</a></h3></center>";
	} 
 
    else
    { 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script type="text/javascript">
 function a()
{
  var x = document.select.branchcodename.value;

  if(x=="")
  {
   alert("Please choose branch location");
   return false;
  }
}
</script>
</head>
<body bgcolor="#F5D16A">
<center>
<img src="OK.gif" />
<table border="0" align="center">
<form name="select" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" onsubmit="return a()">
<tr><td><center><h1>CHOOSE COUNTER CASH CHECKING REPORT LOCATION</h1></center></td></tr>
<tr><td><center>Branch Codename:<select name="tempat">
                                <option value="OK01">OK</option>
                                <option value="TK02">TK</option>
                                </select></center></td></tr>
<tr><td><center><input type="submit" name="submit" value="Submit"></center></td></tr>

</form>
</table>
</center>
</body>
</html>
<?php  

 }

	// $sql3 = mysql_query("UPDATE counter_cash SET Check_By ='$a' WHERE Check_By ='' ");  
	// $sql4 = mysql_query("UPDATE counter_cash2 SET Check_By ='$a' WHERE Check_By ='' "); 

 ?>
 
 

//countercashadmineditcheckby.php

<?php
session_start();
if (empty($_SESSION['is_logged_in']))
{
 header("Location:login.php");
 die();     // just to make sure no scripts execute
}
?>
<?php
 	mysql_connect("localhost","root") or die(mysql_error());
    mysql_select_db("kime") or die(mysql_error());
	$a=$_SESSION['branchcodename'];
	$b=$_SESSION['tempat'];
	if (isset($_POST["submit"]))
    { 
	 $b=$_SESSION['tempat'];
     $checkby=$_POST['cuba'];
	 $sql1 = mysql_query("UPDATE counter_cash SET Check_By = '$a' WHERE ID = '$checkby'") or die(mysql_error());
	 $_SESSION['is_logged_in'] = 1;
	 if($_SESSION['is_logged_in'] == 1)
	 {
	   header("Location: countercashadminviewedit.php");	 
	 }
	}
?>


//countercashadminviewedit.php

<?php
session_start();
if (empty($_SESSION['is_logged_in']))
{
 header("Location:login.php");
 die();     // just to make sure no scripts execute
}
?>
<?php
 	mysql_connect("localhost","root") or die(mysql_error());
    mysql_select_db("kime") or die(mysql_error());
	$a=$_SESSION['branchcodename'];
	$b=$_SESSION['tempat'];
		
	$sql1 = mysql_query("SELECT *,DATE_FORMAT(Form_Date, '%d/%m/%Y %l:%i %p') AS Form_Date FROM counter_cash WHERE Branch_Codename='$b' ORDER BY Form_Date") or die(mysql_error());
	$sql2 = mysql_query("SELECT * FROM counter_cash WHERE Branch_Codename='$b'") or die(mysql_error());
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body bgcolor='#F5D16A'>
<center><img src ='OK.gif'></center><br>
<center><h2>COUNTER CASH CHECKING REPORT</h2><table><tr><td><h3>LOCATION</h3></td><td><h3>:</h3></td><td><h3><?php echo $b; ?></h3></td></tr></table></center>
<center><table border = '1'>
<tr><th rowspan='2'>ID</th><th rowspan='2'>DATE & TIME</th><th rowspan='2'>CASHIER NAME</th><th colspan='3'>COUNTER CASH</th><th colspan='3'>PETTY CASH</th><th rowspan='2'>SIGN</th><th rowspan='2'>HANDOVER TO (NAME)</th><th rowspan='2'>SIGN</th><th rowspan='2'>CHECK BY</th></tr><tr><th>AMOUNT</th><th>SHORTAGE</th><th>EXCESS</th><th>AMOUNT</th><th>SHORTAGE</th><th>REMARK</th></tr><?php while($report = mysql_fetch_array($sql1))
	{ ?><tr align='center'><td><?php echo $report['ID'];?></td><td><?php echo $report['Form_Date'];?></td><td><?php echo $report['Cashier_Name'];?></td><td>RM  <?php echo $report['Counter_Amount'];?></td><td>RM  <?php echo $report['Counter_Shortage'];?></td><td>RM  <?php echo $report['Counter_Excess'];?></td><td>RM  <?php echo $report['Petty_Amount'];?></td><td><?php echo $report['Petty_Shortage'];?></td><td><?php echo $report['Petty_Remark'];?></td><td><?php echo $report['Cashier_Sign'];?></td><td><?php echo $report['Handover_Name'];?></td><td><?php echo $report['Handover_Sign'];?></td><td><?php echo $report['Check_By'];?></td></tr><?php } ?>
</table></center><br /><center><form name='editcheckby' method='post' action='countercashadmineditcheckby.php'><table><tr><td><b>CHOOSE ID TO CHECK BY</b></td></tr><tr><td><center><select name = 'cuba'><?php  while($checkby = mysql_fetch_array($sql2))
	{ ?><option value = <?php echo $checkby['ID'];?>><?php echo $checkby['ID'];?></option><?php } ?></select></center></td></tr>
<tr><td><center><input type='submit' name='submit' value='Check'></center></td></tr></table></form>
<center><h3><a href='adminselect.php'>BACK</a>       <a href='logout.php'>LOG OUT</a></h3></center>
</body>
</html>

This 3 pages is just to make the "Check_By" field contained data but my problem was once I updated "Check_By" field according to the ID, I want the dropdownlist to contain ID where the Check By was not filled with data because now it still listing all the ID and not listing ID where check_by still not being filled

 

That ID dropdownlist code was

 

 

countercashadminlocation.php

echo "<table><tr><td><b>CHOOSE ID TO CHECK BY</b></td></tr><tr><td><center><select name = 'cuba'>";
	 while($checkby = mysql_fetch_array($sql2))
	{
	 echo "<option value ='".$checkby['ID']."'>".$checkby['ID']."</option>";	  
	}
	echo "</select></center></td></tr>";
	echo "<tr><td><center><input type='submit' name='submit' value='Check'></center></td></tr></table></form>";

Any suggestion or solution

Edited by shebbycs
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.

×
 Share
Go to topic listing
×
×
  • 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.