// If the user wants to add a joke if (isset($addjoke)): ?>
else:
// Connect to the database server $dbcnx = @mysql_connect("localhost", "root", "mypasswd"); if (!$dbcnx) { echo( "
Unable to connect to the " . "database server at this time.
" ); exit(); }
// Select the jokes database if (! @mysql_select_db("jokes") ) { echo( "
Unable to locate the joke " . "database at this time.
" ); 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("
这是我们上面提出的“家庭作业”的解决方案。要在每一个笑话后面添加一个“Delete this Joke”连接,必须作下面的改动:
之前,我们曾经在我们的页面的底端的“Add a Joke!”连接中传递过一个$addjoke变量,通过这个变量来通知我们的脚本不再显示通常的笑话列表,而是显示一个录入笑话的表单。与此相类似,我们在我们的“Delete this Joke”连接中传递一个$deletejoke变量来表示我们想要删除一个笑话。
// If the user wants to add a joke if (isset($addjoke)): ?>
else:
// Connect to the database server $dbcnx = @mysql_connect( "localhost", "root", "mypasswd"); if (!$dbcnx) { echo( "
Unable to connect to the " . "database server at this time.
" ); exit(); }
// Select the jokes database if (! @mysql_select_db("jokes") ) { echo( "
Unable to locate the joke " . "database at this time.
" ); 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("
// If a joke has been deleted, // remove it from the database. if (isset($deletejoke)) { $sql = "DELETE FROM Jokes " . "WHERE ID=$deletejoke"; if (mysql_query($sql)) { echo("
The joke has been deleted.
"); } else { echo("
Error deleting joke: " . mysql_error() . "
"); } } echo("
Here are all the jokes " . "in our database:
"); // Request the ID and text of all the jokes $result = mysql_query( "SELECT ID, JokeText FROM Jokes"); if (!$result) { echo("
Error performing query: " . mysql_error() . "
"); exit(); } // Display the text of each joke in a paragraph // with a "Delete this Joke" link next to each. while ( $row = mysql_fetch_array($result) ) { $jokeid = $row["ID"]; $joketext = $row["JokeText"]; echo("
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn