update table with array

Slowie · February 1, 2012

hey guys im really stuck and need help with this. im trying to update a mysql table from an array.

basically i have 12 records what are pulled using a query. each record has its own ID to distinguish it from the rest. i then have 2 tick boxes for the user to select one for accept and one for deny. what i need is for the query to look at each record on the table and insert the selection boxes value if ticked.

my code is below but i have altered it to the hilt and cannot get it to work so please help :D :D

<?php 
$path = $_SERVER['DOCUMENT_ROOT'];
$path .= "/Apollo/dbc.php";
include_once($path);



$rs_results = mysql_query("SELECT * FROM off WHERE IsItAuthorised='0' and isitsick='0' ORDER BY DayOff");

?>
<html>
<head>
<title>Administration Main Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<?php



if (isset($_POST['submit'])) {
//Assign each array to a variable
$id = $_POST['id'];
$approve = $_POST['approve'];
$deny = $_POST['deny'];


$limit = count($id);




$values = array(); // initialize an empty array to hold the values
for($k=0;$k<$limit;$k++){
$msg[] = "$limit Holidays Updated";
$id[k] = $id;
$approve[k] = $approve;
$deny[k] = $deny;

$id = implode($id);
$approve = implode( $approve);
$deny = implode( $deny);

	  $query = "UPDATE off SET Authorised = $approve , Deny = $deny
	  WHERE OffID =  $id " ;
}



$Event = "INSERT INTO events (UserName, Event ) VALUES ('$_SESSION[user_name]', 'Entered New KPI' )";	
								  



	echo $query;
if (!mysql_query($query,$link)){
	die('Error: ' . mysql_error());
} else {

	mysql_query($Event);
	echo "<div class=\"msg\">" . $msg[0] . "</div>";
}




}							  
?>


</head>

<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="14%" valign="top"><?php

?>

</td>
    <td width="74%" valign="top" style="padding: 10px;">
      
      <p><?php 
  if(!empty($msg)) {
  echo $msg[0];
  }
  ?></p>

      <p>
        <?php 
  $cond = '';



  


  $sql = "select * from off ";
  

  
  $rs_total = mysql_query($sql) or die(mysql_error());
  $total = mysql_num_rows($rs_total);
  
  	  
  ?>
       
      <p>
     
	<form name "searchform" action="/Apollo/Admin/HolidayRequests.php" method="post">
        <table width="100%" border="0" align="center" cellpadding="2" cellspacing="0">
          <tr class="mytables"> 
            <td width="4%"><font color="white"><strong>ID</font></strong></td>
            <td width="4%"> <font color="white"><strong>Staff Member</font></strong></td>
            <td width="10%"><font color="white"><strong>Day Off</font></strong></div></td>
		 <td width="10%"><font color="white"><strong>Is It Authorized</font></strong></div></td>
            <td width="15%"> </td>
          </tr>
	  
	  
          <tr> 
            <td> </td>
            <td width="10%"> </td>
            <td width="17%"><div align="center"></div></td>
            <td> </td>
          </tr>
          <?php while ($rrows = mysql_fetch_array($rs_results)) {?>
          <tr> 
            <td><input name="id[]" id="id[]" size="4" value="<?php echo $rrows['OffID'];?>" /></td>
            <td><?php echo $rrows['StaffMember']; ?></td>
            <td><?php echo date('d/m/Y', strtotime($rrows['DayOff']));?></div></td>
            
            <td> <span id="approve<?php echo $rrows['id']; ?>"> 
              <?php if(!$rrows['IsItAuthorised']) { echo "Pending"; } else {echo "Authorized"; }?>
              </span> </td>
		  
		  <td>
		  
      
		<input type="hidden" name="approve[]" id="approve[]" value="0">
		<input type="checkbox" name="approve[]" id="approve[]" value="1"> Approve
		<input type="hidden" name="deny[]" id="deny[]" value="0">
		<input type="checkbox" name="deny[]" id="deny[]" value="1"> Deny


	 </td>
          </tr>
     
          <?php } ?>
        </table>
      <input name="submit" type="submit" id="submit" value="Submit">
      </form>
  

       </p>
  <?php


  ?>
  

      <p> </p>
      <p> </p>
      <p> </p>
      <p> </p></td>
    <td width="12%"> </td>
  </tr>
</table>
</body>
</html>

Slowie · February 1, 2012

Can anyone help me ???? its really making me :'( now

Sign In

update table with array

Recommended Posts

Slowie

Link to comment

Share on other sites

Slowie

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information