Skip navigation
ED-H
ED-H
Currently Being Moderated

Delete page malfunction

Nov 23, 2009 2:14 PM

I have built a number of input forms with PHP admin pages for displaying data and delete pages for the server side script that deletes the entries. These delete links work properly on all of the sites except my own! When I click the delete link I get a blank page with the URL:

http://turtlerockstudiomarketing.com/TRSMdelete.php?id=15

 

 

Check out these pages if you think you can figure it out. They are currently unsecured. It has to be something silly, right?

 

http://turtlerockstudiomarketing.com/TRSMadmin.php

http://turtlerockstudiomarketing.com/TRSMdelete.php

916 Views   10 Replies   Latest reply: David_Powers, Dec 1, 2009 4:15 PM
 
Replies
  • jon@cmiwebstudio
    Currently Being Moderated
    1. jon@cmiwebstudio,
    Nov 24, 2009 10:15 AM   in reply to ED-H
    Report

    Without posting your code and verifying the data exists, there's no way to know for sure what is wrong.

     
    |
    Mark as:
  • David_Powers
    Currently Being Moderated
    2. David_Powers,
    Nov 24, 2009 11:28 AM   in reply to ED-H
    Report

    ED-H wrote:

     

    When I click the delete link I get a blank page

    When you get a blank PHP page, it means there's an error, but that the display of errors has been turned off. There's a more detailed explanation in Why is my PHP page blank? in the Dreamweaver FAQ.

     
    |
    Mark as:
  • ED-H
    Currently Being Moderated
    3. ED-H,
    Nov 27, 2009 11:36 AM   in reply to jon@cmiwebstudio
    Report

    Here's the code:

     

    <?php require_once('Connections/trs.php'); ?>
    <?php
    if (!function_exists("GetSQLValueString")) {
    function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
    {
      if (PHP_VERSION < 6) {
        $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
      }

      $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

      switch ($theType) {
        case "text":
          $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
          break;   
        case "long":
        case "int":
          $theValue = ($theValue != "") ? intval($theValue) : "NULL";
          break;
        case "double":
          $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
          break;
        case "date":
          $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
          break;
        case "defined":
          $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
          break;
      }
      return $theValue;
    }
    }

    if ((isset($_GET['ID'])) && ($_GET['ID'] != "")) {
      $deleteSQL = sprintf("DELETE FROM contactform WHERE ID=%s",
                           GetSQLValueString($_GET['ID'], "int"));

      mysql_select_db($database_trs, $trs);
      $Result1 = mysql_query($deleteSQL, $trs) or die(mysql_error());

      $deleteGoTo = "TRSMadmin.php";
      if (isset($_SERVER['QUERY_STRING'])) {
        $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
        $deleteGoTo .= $_SERVER['QUERY_STRING'];
      }
      header(sprintf("Location: %s", $deleteGoTo));
    }
    ?>
    <!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>TRSM delete</title>
    </head>

    <body>
    </body>
    </html>

     
    |
    Mark as:
  • David_Powers
    Currently Being Moderated
    4. David_Powers,
    Nov 28, 2009 6:03 AM   in reply to ED-H
    Report

    ED-H wrote:

     

    Here's the code:

    There's nothing immediately obvious in the code. Did you use the technique described in the FAQ article to turn on the display of errors temporarily?

     

    It's possible that Connections/trs.php is not accessible, or that there is something in that file that's causing headers to be output, thereby preventing the page from redirecting to TRSMadmin.php.

     
    |
    Mark as:
  • ED-H
    Currently Being Moderated
    5. ED-H,
    Nov 29, 2009 11:15 AM   in reply to David_Powers
    Report

    Adding the error display script results in this:

    Parse error: syntax error, unexpected ':' in /home/turtlero/public_html/TRSM/TRSMdelete.php on line 1

     

    I believe you stated earlier that this is unreliable for syntax errors.

     

    If my database connection, Connections/trs.php, were not accessible, how could I be getting input on my admin page?

     

    I have this exact same page set up on two other websites, character for character except for the connection name, and it works on both. Puzzling.

     

    Thanks a lot for your suggestions.

     
    |
    Mark as:
  • David_Powers
    Currently Being Moderated
    6. David_Powers,
    Nov 29, 2009 11:52 AM   in reply to ED-H
    Report

    ED-H wrote:

     

    Adding the error display script results in this:

    Parse error: syntax error, unexpected ':' in /home/turtlero/public_html/TRSM/TRSMdelete.php on line 1

    Line 1 now contains the script that I asked you to put in to turn on the display of errors. Unfortunately, there was an error in that script. I used a colon instead of a semicolon. Sorry about that. I have now corrected the code in the Dreamweaver FAQ. Correct your version, and try it again.

    If my database connection, Connections/trs.php, were not accessible, how could I be getting input on my admin page?

    The path could be wrong. The whole point of displaying error messages is to try to find out where the error is being triggered. Until then, it's purely guesswork.

     
    |
    Mark as:
  • ED-H
    Currently Being Moderated
    7. ED-H,
    Nov 30, 2009 8:34 AM   in reply to David_Powers
    Report

    I corrected the line 1 script. Now there is no error message at all, whether I use the delete link from the admin page or go directly to the URL. The delete page (http://turtlerockstudiomarketing.com/TRSMdelete.php) is blank, and still fails to delete from the admin page.

     
    |
    Mark as:
  • David_Powers
    Currently Being Moderated
    8. David_Powers,
    Dec 1, 2009 6:38 AM   in reply to ED-H
    Report

    If you right-click that page, and view the source code, you'll see that it contains the HTML code for the page. That means it's loading correctly. Looking back over your previous posts, it's now obvious why it's not working. PHP is a case-sensitive language. The example URL you gave uses id in lowercase, but the code in your Delete Record server behavior is looking for ID in uppercase.

     

    Change the delete link to use uppercase, or change the Delete Record server behavior to use lowercase, and it should work.

     
    |
    Mark as:
  • ED-H
    Currently Being Moderated
    9. ED-H,
    Dec 1, 2009 11:11 AM   in reply to David_Powers
    Report

    Remember back at the beginning of this mess when I said it had to be something silly?!

     

    Thanks, David. I just bought one of your books. You've been a great help in my php adventure.

     
    |
    Mark as:
  • David_Powers
    Currently Being Moderated
    10. David_Powers,
    Dec 1, 2009 4:15 PM   in reply to ED-H
    Report

    ED-H wrote:

     

    Remember back at the beginning of this mess when I said it had to be something silly?!

    Case-sensititivity is very important in PHP, but it's certainly easy to miss.

     

    Thanks, David. I just bought one of your books. You've been a great help in my php adventure.

    Thanks for buying. Hope you find the book helpful.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points