<% ############################################################################## # 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"); %>


Authentication
Email:
Password:
<% } # 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() %>
<% # The deleteResume form below is for deletion %> "> <% # The resume form below is for updation %> ">
Edit Resume
OR Delete Resume
(Fields marked with * are required)
Name
* First: "> * Last: ">
Contact Info
* Email: "> * Phone: ">
Address
Street: ">
City: "> State: "> Zip: ">
Qualifications
* Education: ">
Certifications: ">
Work Experience (years+): Position applied for:
Skills:
(Choose all applicable)
Text Resume
Password
Password: Confirm:
<% } # 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.

Back to Home <% } else { %>

The resume could not be deleted from our system.

Retry <% } } # IF 1 mysql_close($link); %>