Guest User

Untitled

a guest
Dec 2nd, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. <form class="form-inline" method="get" action="jobTitlePull.php">
  2. <div class="form-group">
  3. <label for="firstName">First Name: </label>
  4. <input type="text" name = "fname" id="firstName"/>
  5. </div>
  6. <div class="form-group">
  7. <label for="lastName">Last Name: </label>
  8. <input type="text" name = "lname" id="lastName">
  9. </div>
  10. <div class="form-group">
  11. <label for="jobTitle">Job Title: </label>
  12. <?php
  13. displayAsSelect($list);
  14. ?>
  15. </div>
  16. <input type="submit" class="btn btn-default"></button>
  17. </form>
  18.  
  19. <?php
  20. $serverName = "xxxxxx";
  21. $userName = "xxxxxx";
  22. $passWord = "xxxxxx";
  23. $database = "xxxxxx"; // last 4 fields purposefully masked.
  24. $firstName = $_GET["fname"];
  25. $lastName = $_GET["lname"];
  26. $jobTitle = $_GET["jobName"];
  27. $conn = mysqli_connect($serverName, $userName, $passWord, $database);
  28. if (!$conn){
  29. die ("<p>Connection failed: ".mysqli_connect_error()."</p>");
  30. }
  31. $queryString = "SELECT jobName, description, posType, basePay FROM Titles WHERE jobName = '$jobTitle'";
  32. $result = $conn->query($queryString);
  33. if(!$result){
  34. die ("<p>Query failed</p>");
  35. }
  36. $record = mysqli_fetch_assoc($result); //I think my problem MAY lie here??
  37. $desc = $record['description']; //or maybe I'm declaring variables wrong?
  38. $pos = $record['posType'];
  39. $base = $record['basePay'];
  40. echo "<h4>Hello $firstName $lastName Job Title: $jobTitle Job Description: $desc Position Type: $pos Base Pay: $base</h4>";
  41. mysqli_close($conn);
  42. ?>
Add Comment
Please, Sign In to add comment