[raf]

I need help! Something is wrong with this PHP script. It is short, and simple. I am just trying to get it work properly. The problem I get is...That I am not able to get the Add Joke link to work. It is supposed to "drop down" a text box. On the text box is a submit button that adds the joke to the database i have created. Can someone tell me what is wrong? Maybe the script is written in a older version of PHP. I am running PHP 5 along with MySQL 5. Thank you for your help...

PHP Code:

<?php
  // If the user wants to add a joke
  if (isset($addjoke)):
?>

<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD="POST">
<P>Type your joke here:<BR>
<TEXTAREA NAME="joketext" ROWS=10 COLS=40 WRAP>
</TEXTAREA><BR>
<INPUT TYPE=SUBMIT NAME="submitjoke" VALUE="SUBMIT">
</FORM>

<?php
  else:

    // Connect to the database server
    $dbcnx = @mysql_connect("webhost.server", "************", "**************");
    if (!$dbcnx) {
      echo( "<P>Unable to connect to the " .
            "database server at this time.</P>" );
      exit();
    }

    // Select the jokes database
    if (! @mysql_select_db("jokes123") ) {
      echo( "<P>Unable to locate the joke " .
            "database at this time.</P>" );
      exit();
    }

    // If a joke has been submitted,
    // add it to the database.
    if ("SUBMIT" == $submitjoke) {
      $sql = "INSERT INTO Jokes SET " .
             "JokeText='$joketext', " .
             "JokeDate=CURDATE()";
      if (mysql_query($sql)) {
        echo("<P>Your joke has been added.</P>");
      } else {
        echo("<P>Error adding submitted joke: " .
             mysql_error() . "</P>");
      }
    }
  
    echo("<P> Here are all the jokes " .
         "in our database: </P>");
  
    // Request the text of all the jokes
    $result = mysql_query(
              "SELECT JokeText FROM Jokes");
    if (!$result) {
      echo("<P>Error performing query: " .
           mysql_error() . "</P>");
      exit();
    }
  
    // Display the text of each joke in a paragraph
    while ( $row = mysql_fetch_array($result) ) {
      echo("<P>" . $row["JokeText"] . "</P>");
    }
  
    // When clicked, this link will load this page
    // with the joke submission form displayed.
    echo("<P><A HREF='$PHP_SELF?addjoke=1'>" .
         "Add a Joke!</A></P>");
  
  endif;
  
?>

[job0107]

PHP Code:

<?php
  // If the user wants to add a joke
  if (!empty($_GET["addjoke"])&&$_GET["addjoke"]==1):
?>

<FORM ACTION="?addjoke=0" METHOD="POST">
<P>Type your joke here:<BR>
<TEXTAREA NAME="joketext" ROWS=10 COLS=40 WRAP>
</TEXTAREA><BR>
<INPUT TYPE=SUBMIT NAME="submitjoke" VALUE="SUBMIT">
</FORM>

<?php
  else:

    // Connect to the database server
    $dbcnx = @mysql_connect("webhost.server", "************", "**************");
    if (!$dbcnx) {
      echo( "<P>Unable to connect to the " .
            "database server at this time.</P>" );
      exit();
    }

    // Select the jokes database
    if (! @mysql_select_db("jokes123") ) {
      echo( "<P>Unable to locate the joke " .
            "database at this time.</P>" );
      exit();
    }

    // If a joke has been submitted,
    // add it to the database.
    if (!empty($_POST["submitjoke"])) {
      $sql = "INSERT INTO Jokes SET JokeText='".$_POST["joketext"]."',JokeDate=CURDATE()";
      if (mysql_query($sql)) {
        echo("<P>Your joke has been added.</P>");
      } else {
        echo("<P>Error adding submitted joke: " .
             mysql_error() . "</P>");
      }
    }

    echo("<P> Here are all the jokes " .
         "in our database: </P>");

    // Request the text of all the jokes
    $result = mysql_query(
              "SELECT JokeText FROM Jokes");
    if (!$result) {
      echo("<P>Error performing query: " .
           mysql_error() . "</P>");
      exit();
    }

    // Display the text of each joke in a paragraph
    while ( $row = mysql_fetch_array($result) ) {
      echo("<P>" . $row["JokeText"] . "</P>");
    }

    // When clicked, this link will load this page
    // with the joke submission form displayed.
    echo("<P><A HREF='?addjoke=1'>" .
         "Add a Joke!</A></P>");

  endif;

?>

[raf]

Thank you very much job0107!

Your work is very well appreciated

I do have one question... So what was the problem with my script?

Was it written in PHP4?

I am just so happy! I can't tell you how many hours I spent on trying to fix this script. Funny.

[Nico]

Originally Posted by raf

Was it written in PHP4?

No, but it was based on register globals, which has been disabled by default in PHP 5. And that's a good thing!

[raf]

I think I have another script that needs to have the globals fixed.

I am a beginner to PHP. I am still learning how to do this.

Is there an easy way for me to do this myself?

If you want to take a look at this other script I have. It is very simple, lol. Not for me. It is basically a PHP template for a used car dealership. I suspect the script is written in PHP4 because it is not working at all. I suspect it has something to do with the globals as well. I downloaded the script, installed it in my web host, and nothing. I know I am doing everything correctly. It's the dang script that's messed up. Can anyone please help with this? I found the script, on Free-Car-Dealer-Website - Auto Dealer Inventory Software. Ignore the advertisements on there. Go straight to download towards the top of the stupid website.