Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form class="form-inline" method="get" action="jobTitlePull.php">
- <div class="form-group">
- <label for="firstName">First Name: </label>
- <input type="text" name = "fname" id="firstName"/>
- </div>
- <div class="form-group">
- <label for="lastName">Last Name: </label>
- <input type="text" name = "lname" id="lastName">
- </div>
- <div class="form-group">
- <label for="jobTitle">Job Title: </label>
- <?php
- displayAsSelect($list);
- ?>
- </div>
- <input type="submit" class="btn btn-default"></button>
- </form>
- <?php
- $serverName = "xxxxxx";
- $userName = "xxxxxx";
- $passWord = "xxxxxx";
- $database = "xxxxxx"; // last 4 fields purposefully masked.
- $firstName = $_GET["fname"];
- $lastName = $_GET["lname"];
- $jobTitle = $_GET["jobName"];
- $conn = mysqli_connect($serverName, $userName, $passWord, $database);
- if (!$conn){
- die ("<p>Connection failed: ".mysqli_connect_error()."</p>");
- }
- $queryString = "SELECT jobName, description, posType, basePay FROM Titles WHERE jobName = '$jobTitle'";
- $result = $conn->query($queryString);
- if(!$result){
- die ("<p>Query failed</p>");
- }
- $record = mysqli_fetch_assoc($result); //I think my problem MAY lie here??
- $desc = $record['description']; //or maybe I'm declaring variables wrong?
- $pos = $record['posType'];
- $base = $record['basePay'];
- echo "<h4>Hello $firstName $lastName Job Title: $jobTitle Job Description: $desc Position Type: $pos Base Pay: $base</h4>";
- mysqli_close($conn);
- ?>
Add Comment
Please, Sign In to add comment