Connected to mySQL through PhP but can't retrieve, add or delete records

**Markus** · Nov 13 '08, 08:32 PM

T'would help to see the code you use to run these queries, my friend.

Markus.

**jessiK** · Nov 14 '08, 04:42 AM

Hi, sorry, this is one of the code snippets I've tried. It is part of a tutorial by Kevin Yank from his book "Building a Database-Driven Web Site Using PHP and MySQL".

Code:

<HTML>
<BODY>
<?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("localhost",
             "root", "root");
    if (!$dbcnx) {
      echo( "<P>Unable to connect to the " .
            "database server at this time.</P>" );
      exit();
    }

    // Select the jokes database
    if (! @mysql_select_db("ijdb") ) {
      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;
  
?>
</BODY>
</HTML>

All that is displayed on the page is:

Code:

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

and

Code:

echo("<P><A HREF='$PHP_SELF?addjoke=1'>" .
         "Add a Joke!</A></P>");

If I click on the above link nothing happens.

Yet if I run this piece of code it creates the new table witout a problem.

Code:

$sql = "CREATE TABLE Jokes ( " .
       "ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, " .
       "JokeText TEXT, " .
       "JokeDate DATE NOT NULL " .
       ")";
if ( mysql_query($sql) ) {
  echo("<P>Jokes table successfully created!</P>");
} else {
  echo("<P>Error creating Jokes table: " .
       mysql_error() . "</P>");
}

Hope I've explained this correctly

Thanks!

**r035198x** · Nov 14 '08, 09:36 AM

Most likely this check is failing [CODE=php]if ("SUBMIT" == $submitjoke)[/CODE] because everything else depends on it. Verify that that part is returning true.

**Markus** · Nov 14 '08, 01:29 PM

Originally posted by r035198x

Most likely this check is failing [CODE=php]if ("SUBMIT" == $submitjoke)[/CODE] because everything else depends on it. Verify that that part is returning true.

Indeed. What is $submitjoke. I don't see it declared anywhere.

Also, I was too tired/dying this morning to inform you:

Please use code tags when posting your code. To do this, highlight the code, and then hit the '#' key at the top of the textarea. Read Posting Guidelines if you're still unsure about anything.

Moderator.

Connected to mySQL through PhP but can't retrieve, add or delete records

Connected to mySQL through PhP but can't retrieve, add or delete records

Comment

Comment

Comment

Comment