Permalink
Cannot retrieve contributors at this time
Name already in use
A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
UConnJobSearch/resume.php
Go to fileThis commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
381 lines (324 sloc)
14.6 KB
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!-- Authored by Iu-Wei Sze and Ashley Dumaine and Robert Paganetti--> | |
| <?php | |
| session_start(); | |
| if($_POST) | |
| { | |
| $connect = mysqli_connect("localhost", "root", '', "databasesproject") or die(mysql_error()); | |
| $UnivName = mysqli_real_escape_string($connect, $_POST["UnivName"]); | |
| $sql = "SELECT `UniversityID` FROM `university` WHERE `UniversityName` = '". $UnivName ."'"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if(!($result)) | |
| { | |
| echo '<script type="text/javascript">alert("UnivID query failed");</script>'; | |
| } | |
| else{ | |
| if(mysqli_num_rows($result)){ | |
| $row = mysqli_fetch_object($result); | |
| $UnivID = $row -> UniversityID; | |
| } | |
| else{ | |
| $sql = "INSERT INTO university (UniversityName) VALUES ('". $UnivName ."')"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if($result){ | |
| $sql = "SELECT `UniversityID` FROM `university` WHERE `UniversityName` = '". $UnivName ."'"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| $row = mysqli_fetch_object($result); | |
| $UnivID = $row -> UniversityID; | |
| } | |
| else{ | |
| echo '<script type="text/javascript">alert("inserting new university went wrong.");</script>'; | |
| } | |
| } | |
| } | |
| $DType = mysqli_real_escape_string($connect, $_POST["DType"]); | |
| $sql = "SELECT `DegreeTypeID` FROM `degreetype` WHERE `DegreeType` = '". $DType ."'"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if(!($result)) | |
| { | |
| echo '<script type="text/javascript">alert("DTypeID query failed");</script>'; | |
| } | |
| else{ | |
| if(mysqli_num_rows($result)){ | |
| $row = mysqli_fetch_object($result); | |
| $DTypeID = $row -> DegreeTypeID; | |
| } | |
| else{ | |
| $sql = "INSERT INTO degreetype (DegreeType) VALUES ('". $DType ."')"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if($result){ | |
| $sql = "SELECT `DegreeTypeID` FROM `degreetype` WHERE `DegreeType` = '". $DType ."'"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| $row = mysqli_fetch_object($result); | |
| $DTypeID = $row -> DegreeTypeID; | |
| } | |
| else{ | |
| echo '<script type="text/javascript">alert("inserting new dtype went wrong.");</script>'; | |
| } | |
| } | |
| } | |
| $DArea = mysqli_real_escape_string($connect, $_POST["DArea"]); | |
| $sql = "SELECT `DegreeAreaID` FROM `degreearea` WHERE `DegreeArea` = '". $DArea ."'"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if(!($result)) | |
| { | |
| echo '<script type="text/javascript">alert("DAreaID query failed");</script>'; | |
| } | |
| else{ | |
| if(mysqli_num_rows($result)){ | |
| $row = mysqli_fetch_object($result); | |
| $DAreaID = $row -> DegreeAreaID; | |
| } | |
| else{ | |
| $sql = "INSERT INTO degreearea (DegreeArea) VALUES ('". $DArea ."')"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if($result){ | |
| $sql = "SELECT `DegreeAreaID` FROM `degreearea` WHERE `DegreeArea` = '". $DArea ."'"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| $row = mysqli_fetch_object($result); | |
| $DAreaID = $row -> DegreeAreaID; | |
| } | |
| else{ | |
| echo '<script type="text/javascript">alert("inserting new DArea went wrong.");</script>'; | |
| } | |
| } | |
| } | |
| $UName = $_SESSION['myusername']; | |
| $sql = "SELECT * FROM `resume` WHERE `UName` = '". $UName ."'"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if(mysqli_num_rows($result)) { //user already has a resume! | |
| echo '<script type="text/javascript">alert("You already have a resume in the database!");</script>'; | |
| } | |
| else{ | |
| $Objective = mysqli_real_escape_string($connect, $_POST["Objective"]); | |
| $MinSalary = mysqli_real_escape_string($connect, $_POST["MinSalary"]); | |
| $MaxSalary = mysqli_real_escape_string($connect, $_POST["MaxSalary"]); | |
| $sql = "INSERT INTO resume (RObjective, RSalaryMin, RFile, UName) VALUES ('". $Objective ."', ". $MinSalary .", NULL, '". $UName ."')"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if($result) | |
| { | |
| $sql = "SELECT `ResumeID` FROM `resume` WHERE `UName` = '". $UName ."'"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| $row = mysqli_fetch_object($result); | |
| $ResumeID = $row -> ResumeID; | |
| $GPA = $_POST["GPA"]; | |
| $CStartDate = $_POST["CStartDate"]; | |
| $gradDate = $_POST["gradDate"]; | |
| $sql = "INSERT INTO education (EUniversityID, EGPA, EstartDate, EGradDate, DegreeTypeID, DegreeAreaID, ResumeID) VALUES | |
| (". $UnivID .", '". $GPA ."', '". $CStartDate ."', '". $gradDate ."', ". $DTypeID .", ". $DAreaID .", ". $ResumeID .")"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if(!($result)){ | |
| echo '<script type="text/javascript">alert("Inserting new education went wrong!");</script>'; | |
| } | |
| $state = $_POST["PJState"]; | |
| if((strlen($state) < 3) && (strlen($state) >=0)){ | |
| echo '<script type="text/javascript">alert("Please enter the full name of the state!");</script>'; | |
| } | |
| else{ | |
| $sql = "SELECT StateID FROM state WHERE state.StateName = '". $state ."';"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if(mysqli_num_rows($result)){ | |
| $row = mysqli_fetch_object($result); | |
| $StateID = $row -> StateID; | |
| $PJCName = mysqli_real_escape_string($connect, $_POST["PJCName"]); | |
| $PJTitle = mysqli_real_escape_string($connect, $_POST["PJTitle"]); | |
| $PJDuties = mysqli_real_escape_string($connect, $_POST["PJDuties"]); | |
| $PJCity = mysqli_real_escape_string($connect, $_POST["PJCity"]); | |
| $PJStartDate = $_POST["PJStartDate"]; | |
| $PJEndDate = $_POST["PJEndDate"]; | |
| $sql = "INSERT INTO priorjobs (PJCompanyName, PJJobTitle, PJDuties, PJCity, StateID, PJStartDate, PJEndDate, ResumeID) VALUES | |
| ('". $PJCName ."', '". $PJTitle ."', '". $PJDuties ."', '". $PJCity ."', ". $StateID .", '". $PJStartDate ."', '". $PJEndDate ."', '". $ResumeID ."')"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if($result){ | |
| $skills = $_POST["Skills"]; | |
| $skillsArr = explode(",", $skills); | |
| foreach($skillsArr as &$value) | |
| { | |
| $sql = "SELECT SSkillID FROM skill WHERE SSkillName = '". $value ."';"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if(mysqli_num_rows($result)){ | |
| $row = mysqli_fetch_object($result); | |
| $SSkillID = $row -> SSkillID; | |
| } | |
| else{ | |
| $sql = "INSERT INTO skill (SSkillName) VALUES ('". $value ."')"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if($result){ | |
| $sql = "SELECT SSkillID FROM skill WHERE SSkillName = '". $value ."';"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| $row = mysqli_fetch_object($result); | |
| $SSkillID = $row ->SSkillID; | |
| } | |
| else{ | |
| echo '<script type="text/javascript">alert("inserting new Skill name failed");</script>'; | |
| } | |
| } | |
| $sql = "INSERT INTO skillset (SSkillID, ResumeID) VALUES (". $SSkillID .", ". $ResumeID .")"; | |
| $result = mysqli_query($connect, $sql) or trigger_error($connect->error."[ $sql]"); | |
| if(!($result)){ | |
| echo '<script type="text/javascript">alert("inserting into skillset failed!");</script>'; | |
| } | |
| } | |
| echo "<br><div role='alert' class='alert alert-success'>Resume added successfully!</div>"; | |
| } | |
| else{ | |
| echo '<script type="text/javascript">alert("Inserting prior job failed!");</script>'; | |
| } | |
| } | |
| else{ | |
| echo '<script type="text/javascript">alert("Check your state spelling!");</script>'; | |
| } | |
| } | |
| } | |
| else{ | |
| echo '<script type="text/javascript">alert("Resume insert failed!");</script>'; | |
| } | |
| } | |
| } | |
| ?> | |
| <!DOCTYPE html> | |
| <html> | |
| <style> | |
| form { width: 1200px; } | |
| input { float: right; width: 250px; } | |
| </style> | |
| <head> | |
| <!-- META --> | |
| <title>Add Resume</title> | |
| <meta charset="UTF-8"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"/> | |
| <meta name="description" content="" /> | |
| <!-- CSS --> | |
| <link rel="stylesheet" type="text/css" href="css/kickstart.css" media="all" /> | |
| <link rel="stylesheet" type="text/css" href="style.css" media="all" /> | |
| <!-- Javascript --> | |
| <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script> | |
| <script type="text/javascript" src="js/kickstart.js"></script> | |
| <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script> | |
| <script> | |
| $(document).ready(function () { | |
| $('div.toshow').fadeIn(20); | |
| //$('div.toshow').show(2000); | |
| //$('div.toshow').slideDown("slow"); | |
| }); | |
| </script> | |
| <link href="http://s3.amazonaws.com/codecademy-content/courses/ltp/css/shift.css" rel="stylesheet"> | |
| <link rel="stylesheet" href="http://s3.amazonaws.com/codecademy-content/courses/ltp/css/bootstrap.css"> | |
| <link rel="stylesheet" href="register_formatting.css"> | |
| </head> | |
| <body> | |
| <div class="nav"> | |
| <div class="container"> | |
| <ul class="pull-left"> | |
| <!-- <li><a href=<img><></li> --> | |
| <li><a href="http://localhost/UConnJobSearch/index.php">UConnJobSearch</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/about.php">About</a></li> | |
| </ul> | |
| <ul class="pull-right"> | |
| <?php if ($_SESSION): ?> | |
| <?php if ($_SESSION['type'] == "Admin"): ?> | |
| <li><a href="http://localhost/UConnJobSearch/admin_dashboard.php">Dashboard</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/admin.php">My Account</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/logout.php">Log Out</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/faq.php">Help</a></li> | |
| <?php elseif ($_SESSION['type'] == "Poster"): ?> | |
| <li><a href="http://localhost/UConnJobSearch/posterDashboard.php">Dashboard</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/poster.php">My Account</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/logout.php">Log Out</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/faq.php">Help</a></li> | |
| <?php elseif ($_SESSION['type'] == "Seeker"): ?> | |
| <li><a href="http://localhost/UConnJobSearch/dashboard.php">Dashboard</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/seeker.php">My Account</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/logout.php">Log Out</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/faq.php">Help</a></li> | |
| <?php endif; ?> <!-- not logged in --> | |
| <?php else: header("location:error.php"); ?> | |
| <li><a href="http://localhost/UConnJobSearch/register.php">Register</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/login.php">Log In</a></li> | |
| <li>|</li> | |
| <li><a href="http://localhost/UConnJobSearch/faq.php">Help</a></li> | |
| <?php endif; ?> | |
| </ul> | |
| </div> | |
| </div> | |
| <div class="toshow" style="display:none;"> | |
| <div class="jumbotron"> | |
| <div class="container"> | |
| <form action="resume.php" method="post"> | |
| <div class="row"> | |
| <div class="col-md-6"> | |
| <h1>Add Resume</h1> | |
| <hr style="height: 1px; color: #008000; width: 100% " /> | |
| <h4 style="color: #fff">Education</h4><br> | |
| <p style="color: #fff; font-size: 15px"> | |
| University Name: <input type="text" id="UnivName" name="UnivName" style="color:#000"></input><br><br> | |
| Degree Type: <input type="text" id="DType" name="DType" style="color:#000"></input><br><br> | |
| Degree Area: <input type="text" id="DArea" name="DArea" style="color:#000"></input><br><br> | |
| GPA: <input type="text" id="GPA" name="GPA" style="color:#000"></input><br><br> | |
| College Start Date: <input type="date" id="CStartDate" name="CStartDate" style="color:#000"></input><br><br><br> | |
| Graduation Date: <input type="date" id="gradDate" name="gradDate" style="color:#000"></input><br><br> | |
| </p> | |
| <hr style="height: 1px; color: #008000; width: 100% " /> | |
| <h4 style="color: #fff">Prior Job</h4><br> | |
| <p style="color: #fff; font-size: 15px"> | |
| Company Name: <input type="text" id="PJCName" name="PJCName" style="color:#000"></input><br><br> | |
| Job title : <input type="text" id="PJTitle" name="PJTitle" style="color:#000"></input><br><br> | |
| Job Duties: <input type="text" id="PJDuties" name="PJDuties" style="color:#000"></input><br><br> | |
| City: <input type="text" id="PJCity" name="PJCity" style="color:#000"></input><br><br> | |
| State: <input type="text" id="PJState" name="PJState" style="color:#000"></input><br><br> | |
| Job Start Date: <input type="date" id="PJStartDate" name="PJStartDate" style="color:#000"></input><br><br><br> | |
| Job End Date: <input type="date" id="PJEndDate" name="PJEndDate" style="color:#000"></input><br><br> | |
| </p> | |
| <hr style="height: 1px; color: #008000; width: 100% " /> | |
| <h4 style="color: #fff">Other Background Info</h4><br> | |
| <p style="color: #fff; font-size: 15px"> | |
| Objective: <input type="text" id="Objective" name="Objective" style="color:#000"></input><br><br> | |
| Minimum Salary: <input type="text" id="MinSalary" name="MinSalary" style="color:#000"></input><br><br> | |
| Maximum Salary: <input type="text" id="MaxSalary" name="MaxSalary" style="color:#000"></input><br><br> | |
| Skills (separated by comma): <input type="text" id="Skills" name="Skills" style="color:#000"></input><br><br> | |
| </p> | |
| </div> | |
| <div class="col-md-6"> | |
| <br><br> | |
| </div> | |
| </div> | |
| <br> | |
| <input type = "submit" name = "addresumebutton" value = "Add Resume"> | |
| </form> | |
| <div id='returnHTML'></div> | |
| </div> | |
| </div> | |
| <div class="learn-more"> | |
| <div class="container"> | |
| <div class="row"> | |
| </div> | |
| </div> | |
| </div> | |
| </div> | |
| <div class="credits"> | |
| <footer> <!-- site wide footer --> | |
| <nav> | |
| <p><a href="http://localhost/UConnJobSearch/credits.php">Credits</a> | |
| <a>|</a> | |
| <a href="">Terms of Service</a> | |
| <a>|</a> | |
| <a herf="">Blog Index</a> | |
| </p> | |
| </nav> | |
| <p>Copyright © 2015 UConn</p> | |
| </footer> | |
| </div> | |
| </body> | |
| <head> | |
| </head> | |
| </html> |