| Please Click on the task you want to perform |
| Verify publications (To be implemented) |
| Edit an existing Publication |
| Delete an existing Publication |
| Edit an existing Project |
| Add an new project |
| Edit an existing author |
';
}
function verifyDeletePublication($pub_id){
global $PAGE_SELF;
if(!isPublicationExist($pub_id)){
echo " Publication with ID $pub_id doesn't exist ";
echo " ";
}
else{
echo " Are you sure to delete the following paper? ";
echo "";
}
}
function displayVerifyPublication(){
}
function displayEditPublication(){
}
function displayDeletePublication(){
echo
'';
}
function displayEditProject(){
}
function displayAddProject(){
}
function displayEditAuthor(){
}
function doDeletePublication($pub_id){
$link = open_db();
mysql_query("START TRANSACTION", $link);
$query = "delete from publication where pub_id=$pub_id";
$result = mysql_query($query, $link);
if (!$result) {
rollbackAndDie($link, 'Invalid query: ' . $query . mysql_error());
}
$query = "delete from pub_project where pub_id=$pub_id";
$result = mysql_query($query, $link);
if (!$result) {
rollbackAndDie($link, 'Invalid query: ' . $query . mysql_error());
}
$query = "delete from pub_author where pub_id=$pub_id";
$result = mysql_query($query, $link);
if (!$result) {
rollbackAndDie($link, 'Invalid query: ' . $query . mysql_error());
}
mysql_query("COMMIT", $link);
echo "publication $pub_id has been deleted successfully";
global $PAGE_SELF;
echo "";
}
?>