problem deleting

amylou · August 24, 2007

i finally got the program to show what i want but now the delete does not work, it will tell the user that what they have selected to delete has been deleted but does not take it out of the database. I know that I am over looking something but not sure what. I will post the codes that i am useing.

checkdates.php- allows the user to enter their first and last name hit submit and it will show them the results for there name with check box next to each result and then a delete link to delete.

  <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<?php
/*this program was designed to eliminate paper work for the sift supervisors and the csps that work at Sitel here at loring.
  this program was written and developed by Amy Coppola on July 2007	
*/	
?>
<?php 
include'mysqlconnectsitel.inc.php'; 
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Check The Dates</title>
<link href= "links.css" rel="stylesheet" type="text/css"/>
<link href= "general.css" rel="stylesheet" type="text/css"/>

<?php 
function getmonth($m=0) {
return (($m==0 ) ? date('F') : date('F', mktime(0,0,0,$m)));
}
?>

</head>
<body>
<br>

<img src="33720001.jpg" alt="sitel" width="300" height="100" />

<?php
if(isset($_POST['action'])){$action=$_POST['action'];}else{$action="";}
if( $action == 'updated' )
{
  extract ($_POST);
  $todaysDate = date("Y-m-d",time());
  
        

//	Need to query database to see if this request is valid


echo "<p><strong>These are the dates that you have requested off!!!!</strong></p>";


$sql ="SELECT first, last, requestedDate FROM timeoff WHERE last = '$last' AND first = '$first'";
$query=mysql_query($sql) or die("Query failed : " . mysql_error());
while($row = mysql_fetch_assoc($query)) {
echo "<p>";
echo $row['first'] ." ". $row['last']. " ". "  ". $row['requestedDate'];	
echo "<td><input type=\"checkbox\" name=\"deleted_items[]\" "; 
echo "</p>";
}
        
$action="";
$_html ="<tr> 
    <td>$_rw->requestId</td>
    <td>$_rw->first</td>
<td>$_rw->last</td>
<td>$_rw->requestedDate</td>
     <td>
   <a href=\"index.php?id=$_rw->requestId&m=del\">DELETE </a></td>

    </tr>";
echo $_html;
echo "<p><strong>To start at the begining page.<a href='members.php'>Click here</a></strong></p>";
}
else

{
  
  
?>

  <form name='checkdate' method='post' action='checkdates.php'> 
<table width="500" border="0">
    <tr>   
    <td>First Name </td>
    <td><input name="first" type="text" size="20" maxlength="20"></td>
  </tr>
  <tr>
    <td>Last Name </td>
    <td><input name="last" type="text" size="30" maxlength="30"></td>
  </tr>
    
  <tr><td><b>Todays Date:</b></td>
  <td>
   <?php
$todaysDate = date("m-d-Y",time());
echo "$todaysDate";	
?> 
  </td>
</tr> 
          
<tr><td colspan="2" align="center">
<input type= 'hidden' name= 'action' value= 'updated'>					
  		<input type = "submit" name = "submit" value= "Submit">
  </td></tr></table>
  
</form>
<?php
}
?>
</body>
</html>

index.php has the delete code .

<?php
/*this program was designed to eliminate paper work for the sift supervisors and the csps that work at Sitel here at loring.
  this program was written and developed by Amy Coppola on July 2007	
*/	
?>

<?PHP

include 'mysqlconnectsitel.inc.php';// this has my database connection stuff
if($_GET['m'] == 'del' )
{
$requestId = $_GET['id'];
   $query ="DELETE  FROM timeoff WHERE requestId = '$requestId'";
  $result= mysql_query($query) or die(mysql_error());
   echo" <center><font color=\"#00CC00\">Your Info Was Deleted!</font></center> "; 
}

echo "<p><strong>To start at the begining page.<a href='members.php'>Click here</a></strong></p>";
echo "<p><strong>To check your dates again.<a href ='checkdates.php'>Click here</a></strong></p>";
?>


</body>
</html>

if this can be done easier like on one page (which i have tried but then the form does not work) let me know or show me how to do it. any help will be appreciated

teng84 · August 25, 2007

what is the datatype of requestId if this is an int then

$query ="DELETE FROM timeoff WHERE requestId = ".$requestId."";

hope it works

Sign In

problem deleting

Recommended Posts

amylou

Link to comment

Share on other sites

teng84

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information