Alert doesn't pop up

emilcarlo · August 16, 2010

Hi, can anybody check on this code? I don't have any errors in it, except that the supposedly alert after I deleted an information is not working. Thank you very much.

**This is a modified code provided by a friend. It worked originally (I just lost the original file since I sold my old computer xD

Here's the code:

<?php
include("dbconnection.php");



if(mysql_num_rows($result) > 0)
{
$query = "SELECT * FROM records WHERE id = '".$_GET["id"]."'";
$result = mysql_query($query, $connection);

$status = mysql_result($result, 0, "status");
$territory = mysql_result($result, 0, "territory");
$job_title = mysql_result($result, 0, "job_title");
$area_of_work = mysql_result($result, 0, "area_of_work");
$employer = mysql_result($result, 0, "employer");
$department = mysql_result($result, 0, "department");
$location = mysql_result($result, 0, "location");
$date_posted = mysql_result($result, 0, "date_posted");
$closing_date = mysql_result($result, 0, "closing_date");
$gender = mysql_result($result, 0, "gender");
$first_name = mysql_result($result, 0, "first_name");
$last_name = mysql_result($result, 0, "last_name");
$telephone_number = mysql_result($result, 0, "telephone_number");
$title = mysql_result($result, 0, "title");
$address_1 = mysql_result($result, 0, "address_1");
$address_2 = mysql_result($result, 0, "address_2");
$address_3 = mysql_result($result, 0, "address_3");
$city = mysql_result($result, 0, "city");
$country = mysql_result($result, 0, "country");
$postal_code = mysql_result($result, 0, "postal_code");
$website = mysql_result($result, 0, "website");
$email_address = mysql_result($result, 0, "email_address");
$cg_comment = mysql_result($result, 0, "cg_comment");
$date_emailed = mysql_result($result, 0, "date_emailed");
$mailing_comments= mysql_result($result, 0, "mailing_comments");
$telesales_comments= mysql_result($result, 0, "telesales_comments");	
}

if(isset($_POST["btnSubmit"]))
{
$id = $_POST["id"];

$query = "DELETE FROM records WHERE id = '".$id."'";
mysql_query($query) or die(mysql_error());

echo "<script>
	alert('You have successfully deleted a record');
	window.location = 'view_client.php';
</script>";

}

?>

schilly · August 16, 2010

Where is your form?

Does it get into that if statement and delete the record?

emilcarlo · August 16, 2010

Hi schilly, thanks for the response Here's the whole code:

<?php
include("dbconnection.php");



if(mysql_num_rows($result) > 0)
{
$query = "SELECT * FROM records WHERE id = '".$_GET["id"]."'";
$result = mysql_query($query, $connection);

$status = mysql_result($result, 0, "status");
$territory = mysql_result($result, 0, "territory");
$job_title = mysql_result($result, 0, "job_title");
$area_of_work = mysql_result($result, 0, "area_of_work");
$employer = mysql_result($result, 0, "employer");
$department = mysql_result($result, 0, "department");
$location = mysql_result($result, 0, "location");
$date_posted = mysql_result($result, 0, "date_posted");
$closing_date = mysql_result($result, 0, "closing_date");
$gender = mysql_result($result, 0, "gender");
$first_name = mysql_result($result, 0, "first_name");
$last_name = mysql_result($result, 0, "last_name");
$telephone_number = mysql_result($result, 0, "telephone_number");
$title = mysql_result($result, 0, "title");
$address_1 = mysql_result($result, 0, "address_1");
$address_2 = mysql_result($result, 0, "address_2");
$address_3 = mysql_result($result, 0, "address_3");
$city = mysql_result($result, 0, "city");
$country = mysql_result($result, 0, "country");
$postal_code = mysql_result($result, 0, "postal_code");
$website = mysql_result($result, 0, "website");
$email_address = mysql_result($result, 0, "email_address");
$cg_comment = mysql_result($result, 0, "cg_comment");
$date_emailed = mysql_result($result, 0, "date_emailed");
$mailing_comments= mysql_result($result, 0, "mailing_comments");
$telesales_comments= mysql_result($result, 0, "telesales_comments");	
}

if(isset($_POST["btnSubmit"]))
{
$id = $_POST["id"];

$query = "DELETE FROM records WHERE id = '".$id."'";
mysql_query($query) or die(mysql_error());

echo "<script>
	alert('You have successfully deleted a record');
	window.location = 'view_client.php';
</script>";

}

?>

<!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>
<style type="text/css">
<!--
body,td,th {
font-family: Tahoma, Geneva, sans-serif;
font-size: 12px;
}
-->
</style></head>

<body>
<table width="865" height="140" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <th height="69" colspan="2" bgcolor="#38619E" scope="col"><img src="header.gif" width="563" height="100" alt="" /></th>
  </tr>
  <tr>
    <td width="202" valign="top" bgcolor="#A1BDE1" scope="col"><p> </p>
      <table width="200" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td scope="col"><table width="202" height="150" border="0" cellpadding="0" cellspacing="0">
            <tr>
              <th height="35" colspan="5" scope="col">CONTROL PANEL</th>
            </tr>
            <tr>
              <td height="10"> </td>
              <td height="35"><a href="data_mining.php"><img src="arrow_up.png" alt="" width="30" height="30" border="0"/></a></td>
              <td height="10" align="left"> </td>
              <td height="10" align="left">MAIN PAGE</td>
              <td height="10" align="left"> </td>
            </tr>
            <tr>
              <td width="16"> </td>
              <td width="32" height="35"><a href="view_client.php"><img src="Search-icon.png" alt="" width="30" height="30" border="0"/></a></td>
              <td width="16" height="35" align="left"> </td>
              <td width="119" height="35" align="left">VIEW RECORD</a></td>
              <td width="19" align="left"> </td>
            </tr>
            <tr>
              <td> </td>
              <td height="35"><img src="addez7.png" alt="" width="30" height="30" border="0"/></td>
              <td height="35" align="left"> </td>
              <td height="35" align="left">ADD RECORD</td>
              <td align="left"> </td>
            </tr>
            <tr>
              <td height="10"> </td>
              <td height="10"> </td>
              <td height="10" align="left"> </td>
              <td height="10" align="left"> </td>
              <td height="10" align="left"> </td>
            </tr>
          </table></td>
        </tr>
      </table>
      <p> </p></th>
    <th width="657" height="600" align="center" valign="top" bgcolor="#A1BDE1" scope="col"><p> </p>
      <form action="delete_client.php" method="post" name="form" id="form">
        <table width="560" border="0" cellpadding="1" cellspacing="0">
          <tr>
            <td width="115"> </td>
            <td width="144"><input type="text" name="id" id="id" style="visibility:hidden" value="<?php echo $_GET["id"]; ?>" /></td>
            <td width="36"> </td>
            <th width="111" align="left"> Status</th>
            <th width="144" align="center"><?php echo $status; ?></th>
          </tr>
          <tr>
            <td width="115"> </td>
            <td width="144"> </td>
            <td width="36"> </td>
            <td width="111" align="left"> </td>
            <td width="144"><input name="status" type="text" id="status" style="visibility:hidden" value="<?php echo $status; ?>"/></td>
          </tr>
          <tr>
            <th width="115" align="left">Territory</th>
            <td width="144"><input type="text" name="territory" id="territory" value="<?php echo $territory; ?>" /></td>
            <td width="36"> </td>
            <th width="111" align="left">Location</th>
            <td width="144"><input type="text" name="location" id="location"  value="<?php echo $location; ?>"/></td>
          </tr>
          <tr>
            <th width="115" align="left">Area of Work</th>
            <td width="144"><input type="text" name="area_of_work" id="area_of_work" value="<?php echo $area_of_work; ?>" /></td>
            <td width="36"> </td>
            <th width="111" align="left">Job Title</th>
            <td width="144"><input type="text" name="job_title" id="job_title" value="<?php echo $job_title; ?>" /></td>
          </tr>
          <tr>
            <th width="115" align="left">Employer</th>
            <td width="144"><input type="text" name="employer2" id="employer2" value="<?php echo $employer; ?>" /></td>
            <td width="36"> </td>
            <th width="111" align="left">Department</th>
            <td width="144"><input type="text" name="department" id="department" value="<?php echo $department; ?>"/></td>
          </tr>
          <tr>
            <th align="left">Date Posted</th>
            <td><input type="text" name="date_posted" id="date_posted"  value="<?php echo $date_posted; ?>"/></td>
            <td> </td>
            <th align="left">Closing Date</th>
            <td><input type="text" name="closing_date" id="closing_date"  value="<?php echo $closing_date; ?>"/></td>
          </tr>
          <tr>
            <td colspan="5" align="center"> </td>
          </tr>
        </table>
        <hr width="500" />
        <table width="560" border="0" cellpadding="1" cellspacing="0">
          <tr>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
            <th scope="col"> </th>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
          </tr>
          <tr>
            <th width="115" align="left" scope="col">Gender</th>
            <th width="144" scope="col"><input name="gender" type="text" id="gender"  value="<?php echo $gender; ?>"/></th>
            <th width="36" scope="col"> </th>
            <th width="111" align="left" scope="col"> </th>
            <th width="144" scope="col"> </th>
          </tr>
          <tr>
            <th align="left" scope="col">First Name</th>
            <th scope="col"><input type="text" name="first_name" id="first_name"  value="<?php echo $first_name; ?>"/></th>
            <th scope="col"> </th>
            <th align="left" scope="col">Last Name</th>
            <th scope="col"><input type="text" name="last_name" id="last_name"  value="<?php echo $last_name; ?>"/></th>
          </tr>
          <tr>
            <th align="left" scope="col">Title</th>
            <th scope="col"><input type="text" name="title" id="title"  value="<?php echo $title; ?>"/></th>
            <th scope="col"> </th>
            <th align="left" scope="col">Telephone</th>
            <th scope="col"><input type="text" name="telephone_number" id="telephone_number"  value="<?php echo $telephone_number; ?>"/></th>
          </tr>
          <tr>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
            <th scope="col"> </th>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
          </tr>
          <tr>
            <th align="left" scope="col">Address 1</th>
            <th scope="col"><input type="text" name="address_1" id="address_1"  value="<?php echo $address_1; ?>"/></th>
            <th scope="col"> </th>
            <th align="left" scope="col">Address 2</th>
            <th scope="col"><input type="text" name="address_2" id="address_2"  value="<?php echo $address_2; ?>"/></th>
          </tr>
          <tr>
            <th align="left" scope="col">Address 3</th>
            <th scope="col"><input type="text" name="address_3" id="address_3"  value="<?php echo $address_3; ?>"/></th>
            <th scope="col"> </th>
            <th align="left" scope="col">City</th>
            <th scope="col"><input type="text" name="city" id="city"  value="<?php echo $city; ?>"/></th>
          </tr>
          <tr>
            <th align="left" scope="col">Country</th>
            <th scope="col"><input type="text" name="country" id="country"  value="<?php echo $country; ?>"/></th>
            <th scope="col"> </th>
            <th align="left" scope="col">Postal Code</th>
            <th scope="col"><input type="text" name="postal_code" id="postal_code"  value="<?php echo $postal_code; ?>"/></th>
          </tr>
          <tr>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
            <th scope="col"> </th>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
          </tr>
          <tr>
            <th align="left" scope="col">Website</th>
            <th scope="col"><input type="text" name="website" id="website"  value="<?php echo $website; ?>"/></th>
            <th scope="col"> </th>
            <th align="left" scope="col">Email Address</th>
            <th scope="col"><input type="text" name="email_address" id="email_address"  value="<?php echo $email_address; ?>"/></th>
          </tr>
          <tr>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
            <th scope="col"> </th>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
          </tr>
          <tr>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
            <th scope="col"> </th>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
          </tr>
          <tr>
            <th align="left" scope="col">CG Comment</th>
            <th scope="col"><input type="text" name="comment_by_cg" id="cg_comment"  value="<?php echo $cg_comment; ?>"/></th>
            <th scope="col"> </th>
            <th align="left" scope="col">Date Emailed</th>
            <th scope="col"><input type="text" name="date_emailed" id="date_emailed"  value="<?php echo $date_emailed; ?>"/></th>
          </tr>
          <tr>
            <th align="left" scope="col">Mailing Comments</th>
            <th scope="col"><input type="text" name="mailing_comments" id="mailing_comments"  value="<?php echo $mailing_comments; ?>"/></th>
            <th scope="col"> </th>
            <th align="left" scope="col">Telesales Comments</th>
            <th scope="col"><input type="text" name="telesales_comments" id="telesales_comments"  value="<?php echo $telesales_comments; ?>"/></th>
          </tr>
          <tr>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
            <th scope="col"> </th>
            <th align="left" scope="col"> </th>
            <th scope="col"> </th>
          </tr>
          <tr>
            <th colspan="5" align="center" scope="col"><a href="view_client.php" style="text-decoration: none">
              <input type="submit" name="btnSubmit" id="btnSubmit" value="Delete Record" />
              <input type="submit" value="      Cancel      " />
            </a></th>
          </tr>
        </table>
      </form>
      <p> </p></th>
  </tr>
</table>
<center>
  <p><strong>Copyright © 2010 Limited. All   rights reserved.</strong>
  </p>
  <p> </p>
  <p> </p>
</center>
</body>
</html>

schilly · August 16, 2010

Does the record get deleted?

jcbones · August 17, 2010

Try:

mysql_query($query) or die(mysql_error());

echo "<script type=\"text/javascript\">
alert('You have successfully deleted a record');
window.location = 'view_client.php';
</script>";

Sign In

Alert doesn't pop up

Recommended Posts

emilcarlo

Link to comment

Share on other sites

schilly

Link to comment

Share on other sites

emilcarlo

Link to comment

Share on other sites

schilly

Link to comment

Share on other sites

jcbones

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information