if (!($link = mysql_pconnect($hostName, $userName, $password))) {
DisplayErrMsg(sprintf("error connecting to host %s, by user %s", $hostName, $userName));
exit;
}
//select the database
if (!mysql_select_db($databaseName, $link)) {
DisplayErrMsg(sprintf("error in selecting %s database", $databaseName));
DisplayErrMsg(sprintf("error: %d %s", mysql_errno($link), mysql_error($link)));
exit;
}
if (!mysql_query($updateStmt, $link)) {
DisplayErrMsg(sprintf("error in executing %s stmt", $updateStmt));
DisplayErrMsg(sprintf("error: %d %s", mysql_errno($link), mysql_error($link)));
//echo "failed";
exit;
}
GenerateHTMLHeader("The Entry was modified successfully");
ReturnToMain();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title></title>
</head>
<body>
</body>
</html>
}
// check if the page is called for the first time
if (!$choice) {
//generate the header of the main page
GenerateHTMLHeader("Click below to access the address Book");
//generate the main page
GenerateFrontPage();
} else {
if ($choice == "Search Address Book") {
GenerateHTMLHeader("Search using the following criteria:");
//generate an HTML form containing a submit button with value "SEARCH" and action script
//as search.php
GenerateHTMLForm(0, "search.php", "SEARCH");
} else {
if ($choice == "Add a New Entry") {
GenerateHTMLHeader("Please fill in fields : Name and Email mandatory");
GenerateHTMLForm(0, "add.php", "ADD ENTRY");
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title></title>
</head>
<body>
</body>
exit;
}
//select the database
if (!mysql_select_db($databaseName, $link)) {
DisplayErrMsg(sprintf("error in selecting %s database", $databaseName));
DisplayErrMsg(sprintf("error: %d %s", mysql_errno($link), mysql_error($link)));
exit;
}
if (!($result = mysql_query($selectStmt, $link))) {
DisplayErrMsg(sprintf("error in executing %s stmt", $stmt));
DisplayErrMsg(sprintf("error: %d %s", mysql_errno($link), mysql_error($link)));
echo "failed";
exit;
}
//Generate the html header with message "please modify fields"
GenerateHTMLHeader("please modify fields");
// display the result of the search
if (!($row = mysql_fetch_object($result))) {
DisplayErrMsg("Internal error: the entry does not exist");
exit;
}
$resultEntry["cn"] = $row->name;
$resultEntry["mail"] = $row->email;
$resultEntry["locality"] = $row->city;
$resultEntry["description"] = $row->description;
$resultEntry["telephonenumber"] = $row->telephone;
//generate html form
GenerateHTMLForm($resultEntry, "update.php?rowid={$rowid}", "MODIFY");
mysql_free_result($result);
//free the memory associated with $result variable.
mysql_free_result($result);
DisplayErrMsg(sprintf("error connecting to host %s, by user %s", $hostName, $userName));
exit;
}
//select the database
if (!mysql_select_db($databaseName, $link)) {
DisplayErrMsg(sprintf("error in selecting %s database", $databaseName));
DisplayErrMsg(sprintf("error: %d %s", mysql_errno($link), mysql_error($link)));
exit;
}
if (!($result = mysql_query($deleteStmt, $link))) {
DisplayErrMsg(sprintf("error in executing %s stmt", $stmt));
DisplayErrMsg(sprintf("error: %d %s", mysql_errno($link), mysql_error($link)));
echo "failed";
exit;
}
//generate the HTML header to display the status of delete operation
GenerateHTMLHeader("The entry was deleted successfully");
ReturnToMain();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title></title>
</head>
<body>
</body>
</html>
exit;
}
if (!($link = mysql_pconnect($hostName, $userName, $password))) {
DisplayErrMsg(sprintf("error connecting to host %s, by user %s", $hostName, $userName));
exit;
}
if (!mysql_select_db($databaseName, $link)) {
DisplayErrMsg(sprintf("error in selecting %s database", $databaseName));
DisplayErrMsg(sprintf("error: %d %s", mysql_errno($link), mysql_error($link)));
exit;
}
if (!mysql_query(sprintf($addStmt, $cn, $mail, $locality, $description, $telephonenumber), $link)) {
DisplayErrMsg(sprintf("error in executing %s stmt", $stmt));
DisplayErrMsg(sprintf("error: %d %s", mysql_errno($link), mysql_error($link)));
exit;
}
GenerateHTMLHeader("The entry was added successfully");
ReturnToMain();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title></title>
</head>
<body>
</body>
</html>
