Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";
- $usr = "root";
- $pwd = "root";
- $db = "imagsuser";
- $conn = new mysqli($servername, $usr, $pwd, $db);
- if(isset($_GET["q"])){
- search($conn,$_GET["gender"],$_GET["age"],$_GET["educ"],$_GET["skills"],$_GET["jobexp"]);
- }else{
- mw();
- }
- function mw(){
- $HTML=<<<HTML
- <form action="" method="get">
- Gender: <br>
- <input type="text" name="gender" /><br>
- Age: <br>
- <input type="text" name="age"><br>
- Educ Attain:<br>
- <input type="text" name="educ"><br>
- Skills:<br>
- <input type="text" name="skills"><br>
- JobExp:<br>
- <input type="text" name="jobexp"><br>
- <br>
- <input type="submit" value="Submit" name="q">
- </form>
- HTML;
- echo $HTML;
- }
- function search($con,$gender,$age,$educ,$skills,$jobxp){
- mw();
- $Arrage=[$age-=1,$age+=2,$age-=3,$age+=4];
- echo "Searched: $gender, $age, $educ, $skills, $jobxp<br>";
- echo "Result ranging from age: $Arrage[2] .. $Arrage[3]<br>";
- $sql = "SELECT * FROM dafuq WHERE gender='$gender' AND age=$Arrage[0] OR age=$Arrage[1] OR age=$Arrage[2] OR age=$Arrage[3] ORDER BY id DESC";
- $result = $con->query($sql);
- while($row = $result->fetch_assoc()) {
- $a=$row['gender'];
- $b=$row['age'];
- $c=$row['educ_attain'];
- $d=$row['skills'];
- $e=$row['jobxp'];
- $HTML=<<<HTML
- $a | $b | $c | $d | $e
- <br>
- HTML;
- echo $HTML;
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement