// 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("
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn