%
##############################################################################
# Program Name : updel_resume.php
# Location : /employment/
# Author : Vandan Juvekar
# Date : 12/03/2001
# For : Authenticate for updation / deletion of previously accepted
# : resume, show forms for updation / deletion.
# Called from : forms in self, updel_resume.php
# System Name : Online Resumes Database
##############################################################################
session_start();
include("includes/common.inc");
openConnection("resume_db");
%>
Edit / Delete your Resume
<%
if ($email == "") # If Authentication form is not shown
{ # IF 1
%>
<%
include("includes/resume_header.inc");
%>
<%
} # IF 1
elseif ($upDel == "") # Authentication form submitted and updation / deletion form is not shown
{
$query = "SELECT * FROM resumes WHERE email = '$email' AND password='$password'";
$result = mysql_query($query) or die ("SELECT query failed on resumes table");
if (mysql_num_rows($result)) # A resume with this email - password combination exists in database
{ # IF 2
$row = mysql_fetch_array($result);
%>
<%
include("includes/resume_header.inc"); # Header and Javascript isValid()
%>
Edit Resume
<%
# The deleteResume form below is for deletion
%>
(Fields marked with * are required)
<%
# The resume form below is for updation
%>
<%
} # IF 2
else # Not a valid combination of email-password
{
include("includes/resume_header.inc");
%>
Incorrect email address or password.
Retry
<%
}
}
else # If deleteResume form was submitted
{ # IF 1
include("includes/resume_header.inc");
$query = "DELETE FROM resumes WHERE id = $resume_id";
$result = mysql_query($query) or die("
Cannot delete resume. Please retry
");
if (mysql_affected_rows())
{
# delete skills info
$query = "DELETE FROM resume_skills_info WHERE resume_id = $resume_id";
$result = mysql_query($query) or die("
Cannot delete resume. Please retry
");
# delete application info
$query = "DELETE FROM application_info WHERE resume_id = $resume_id";
$result = mysql_query($query) or die("
Cannot delete resume. Please retry
");
# delete profile(s)
$query = "DELETE FROM profiles WHERE resume_id = $resume_id";
$result = mysql_query($query) or die("
Cannot delete resume. Please retry
");
%>
The resume was deleted successfully from our system.