help deleting a record

theres nothing happen everytime i click delete.

here's my code
admin.php

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("reservation", $con);

$result = mysql_query("SELECT * FROM guest order by code asc");

mysql_close($con);

<script>
	del=function(code){
		m = confirm("Are you sure you want to delete this Applicants?");
		if(m){
			document.location="deleteApplication.php?id=<?php echo $_GET['code']; ?>";	
		}
	}
	grant=function(code){
		m = confirm("Are you sure you want to Grant this Applicants?");
		if(m){
			document.location="grantApplication.php?id="+code+"&page=<?php echo $_GET['code']; ?>";	
		}
	}
</script>

<table border='1' cellspacing='0' width='613'>
<tr>
<th bgcolor='green'><font color='white'>Customer Code</font></th>
<th bgcolor='green'><font color='white'>First Name</font></th>
<th bgcolor='green'><font color='white'>Middle Name</font></th>
<th bgcolor='green'><font color='white'>Last Name</font></th>
<th bgcolor='green'><font color='white'>Address</font></th>
<th bgcolor='green'><font color='white'>Email Adress</font></th>
<th bgcolor='green'><font color='white'>Contact No</font></th>
<th bgcolor='green'><font color='white'>Remove</font></th>
</tr>
<?php


$i = 0; 

$number = 0;
while($row = mysql_fetch_array($result)){

$number++;
 ?>

  
 <?php
$i++;

if($i%2)
{
$bg_color = "#EEEEEE";
}
else {
$bg_color = "#E0E0E0";
}
?> 

   <tr bgcolor='". $bg_color ."'>
  <td><font color='red'><?php echo $row['code']; ?></font></td>
  <td><?php echo $row['fname']; ?></td>
  <td><?php echo $row['mname'];  ?></td>
  <td><?php echo $row['lname'];  ?></td>
  <td><?php echo $row['address'];  ?></td>
  <td><?php echo $row['emailadd'];  ?></td>
  <td><?php echo $row['contactno'];  ?></td>
   <td><a href='javascript:del(<?php echo $row['cno']; ?>);void(0); '><font color="blue">Delete</font></a></td>
   </tr>
 <?php } ?>
</table> 

?>

deleteApplication.php

<?php
	$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("reservation", $con);

$result = mysql_query("SELECT * FROM guest order by code asc");

if (isset($_GET['code']) && is_numeric($_GET['code']))
    {
        // get id value
        $code = $_GET['code'];
        
        // delete the entry
        $result = mysql_query("DELETE FROM guest WHERE code=$code")
            or die(mysql_error()); 
            
        // redirect back to the view page
        header("Location: admin.php");
    }
    else
    // if id isn't set, or isn't valid, redirect back to view page
    {
        header("Location: admin.php");
    }

    
?>

after clicking delete theres ma message box prompt "Are you sure u want to delete this application?" Yes or No, if i click yes there's nothing happen. i want to delete the row where i select the delete button help please.

ryan311

Posting Whiz in Training

254 posts since Jul 2008

Reputation Points: 3

Solved Threads: 5

2 Years Ago

without using forms i don't know how to det value. i think you must use form to get value in table.

rajabhaskar525

Junior Poster

179 posts since Nov 2009

Reputation Points: 12

Solved Threads: 27

2 Years Ago

theres nothing happen everytime i click delete.

here's my code admin.php

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("reservation", $con);

$result = mysql_query("SELECT * FROM guest order by code asc");

mysql_close($con);

<script>
	del=function(code){
		m = confirm("Are you sure you want to delete this Applicants?");
		if(m){
			document.location="deleteApplication.php?id=<?php echo $_GET['code']; ?>";	
		}
	}
	grant=function(code){
		m = confirm("Are you sure you want to Grant this Applicants?");
		if(m){
			document.location="grantApplication.php?id="+code+"&page=<?php echo $_GET['code']; ?>";	
		}
	}
</script>

<table border='1' cellspacing='0' width='613'>
<tr>
<th bgcolor='green'><font color='white'>Customer Code</font></th>
<th bgcolor='green'><font color='white'>First Name</font></th>
<th bgcolor='green'><font color='white'>Middle Name</font></th>
<th bgcolor='green'><font color='white'>Last Name</font></th>
<th bgcolor='green'><font color='white'>Address</font></th>
<th bgcolor='green'><font color='white'>Email Adress</font></th>
<th bgcolor='green'><font color='white'>Contact No</font></th>
<th bgcolor='green'><font color='white'>Remove</font></th>
</tr>
<?php


$i = 0; 

$number = 0;
while($row = mysql_fetch_array($result)){

$number++;
 ?>

  
 <?php
$i++;

if($i%2)
{
$bg_color = "#EEEEEE";
}
else {
$bg_color = "#E0E0E0";
}
?> 

   <tr bgcolor='". $bg_color ."'>
  <td><font color='red'><?php echo $row['code']; ?></font></td>
  <td><?php echo $row['fname']; ?></td>
  <td><?php echo $row['mname'];  ?></td>
  <td><?php echo $row['lname'];  ?></td>
  <td><?php echo $row['address'];  ?></td>
  <td><?php echo $row['emailadd'];  ?></td>
  <td><?php echo $row['contactno'];  ?></td>
   <td><a href='javascript:del(<?php echo $row['cno']; ?>);void(0); '><font color="blue">Delete</font></a></td>
   </tr>
 <?php } ?>
</table> 

?>

deleteApplication.php

<?php
	$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("reservation", $con);

$result = mysql_query("SELECT * FROM guest order by code asc");

if (isset($_GET['code']) && is_numeric($_GET['code']))
    {
        // get id value
        $code = $_GET['code'];
        
        // delete the entry
        $result = mysql_query("DELETE FROM guest WHERE code=$code")
            or die(mysql_error()); 
            
        // redirect back to the view page
        header("Location: admin.php");
    }
    else
    // if id isn't set, or isn't valid, redirect back to view page
    {
        header("Location: admin.php");
    }

    
?>

how to get values with out post. for get the values there should be a form.

muralikalpana

Posting Pro

540 posts since Sep 2009

Reputation Points: 21

Solved Threads: 36

2 Years Ago

can you give me a sample how to delete a data sir in row of the table.

ryan311

Posting Whiz in Training

254 posts since Jul 2008

Reputation Points: 3