Page 109 of Kevin Yank's PHP/MySQL book

**The_Ohh** · Nov 26, 2004 18:22

Hi,

On page 109 there's an exercise of adding a confirmation prompt to the deleteauthor.php page.

I've been trying to do this exercise but haven't succeeded because:

1) I don't fully understand the author's explanation of $_SERVER['PHP_SELF'].
2) The PHP syntax is really confusing (especially the quotation marks).

Did anyone do this exercise, and if you did, how did you do it please?

**reminder** · Nov 26, 2004 18:56

show the piece of code...
my book hasnt arrived yet

**The_Ohh** · Nov 26, 2004 18:59

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Joke CMS: Delete Author</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php

$dbcnx = mysql_connect('localhost', 'root', 'mypassword');
if (!$dbcnx) {
exit('Unable to connect to the database server at this time.');
}

if (!@mysql_select_db('ijdb')) {
exit('Unable to locate the joke database at this time.');
}

// Delete all jokes belonging to the author along with the entry for the author.
$id = $_GET['id'];
$ok1 = @mysql_query("DELETE FROM joke WHERE authorid='$id'");
$ok2 = @mysql_query("DELETE FROM author WHERE id='$id'");
if ($ok1 and $ok2) {
echo 'Author deleted successfully!';
} else {
echo 'Error deleting author from database! ' .
'Error: ' . mysql_error() . '';
}
?>
<a href="authors.php">Return to authors list</a>
</body>
</html>

**The_Ohh** · Nov 26, 2004 19:02

This is the original code in the book. The user clicks on a delete link from another page (authors.php), and the author is immediately deleted. I've been trying to use an if else statement to bring up a prompt which asks the user to confirm the deletion before the author's name is deleted.

**The_Ohh** · Nov 26, 2004 19:03

This is the code for authors.php:

<body>
<h1>Manage Authors</h1>
<ul>
<?php

$dbcnx = @mysql_connect('localhost', 'root', 'mypassword');
if (!$dbcnx) {
exit('Unable to connect to the database server at this time.');
}

if (!@mysql_select_db('ijdb')) {
exit('Unable to locate the joke database at this time.');
}

$author_list = mysql_query('SELECT id, name FROM author');
if (!$author_list) {
exit('Error retrieving authors from database! '.
'Error: ' . mysql_error() . '');
}

while ($author = mysql_fetch_array($author_list)) {
$id = $author['id'];
$name = htmlspecialchars($author['name']);
echo "<li>$name " .
"<a href='editauthor.php?id=$id'>Edit</a> " .
"<a href='deleteauthor3.php?id=$id'>Delete</a></li>";
}
?>
</ul>
<a href="newauthor.php">Add a new author</a>
<a href="index.html">Return to front page</a>
</body>
</html>

**reminder** · Nov 26, 2004 19:36

where u see here server php self?
what is wrong in this code?
regards

User Tag List

Thread: Page 109 of Kevin Yank's PHP/MySQL book

Thread Tools

Display

Page 109 of Kevin Yank's PHP/MySQL book

Bookmarks

Bookmarks

Posting Permissions