Thanks
(mod edit: added
Code: Select all
tag for some readability)Code: Select all
<HTML>
<BODY>
<?php // If the user wants to add a joke
$addjoke=$_GET[addjoke];
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", "");
if (!$dbcnx)
{
echo( "<P>Unable to connect to the " ."database server at this time.</P>" );
exit();
}
// Select the jokes database
mysql_select_db("jokes",$dbcnx);
if (! @mysql_select_db("jokes") )
{
echo( "<P>Unable to locate the joke " . "database at this time.</P>" );
exit();
}
// If a joke has been submitted,
$submitjoke= $_POST[submitjoke];
echo("<P> Here are all </P>");
if ($submitjoke)
{
$joketext = $_POST[joketext];
echo("<P> works until here</P>");
$sql = "INSERT INTO jokes SET " . "JokeText='$joketext', " . "JokeDate=CURDATE()";
$result = mysql_query($sql);
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",$dbcnx);
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>