Advertisement
Guest User

surprisemadaka

a guest
Jan 20th, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.34 KB | None | 0 0
  1. <?php
  2.  
  3. $servername = "localhost";
  4. $usr = "root";
  5. $pwd = "root";
  6. $db = "imagsuser";
  7.  
  8. $conn = new mysqli($servername, $usr, $pwd, $db);
  9.  
  10. if(isset($_GET["q"])){
  11.     search($conn,$_GET["gender"],$_GET["age"],$_GET["educ"],$_GET["skills"],$_GET["jobexp"]);
  12. }else{
  13.     mw();
  14. }
  15.  
  16. function mw(){
  17.     $HTML=<<<HTML
  18. <form action="" method="get">
  19. Gender: <br>
  20.     <input type="text" name="gender" /><br>
  21. Age: <br>
  22.     <input type="text" name="age"><br>
  23. Educ Attain:<br>
  24.     <input type="text" name="educ"><br>
  25. Skills:<br>
  26.     <input type="text" name="skills"><br>
  27. JobExp:<br>
  28.     <input type="text" name="jobexp"><br>
  29. <br>
  30. <input type="submit" value="Submit" name="q">
  31. </form>
  32. HTML;
  33.     echo $HTML;
  34. }
  35.  
  36. function search($con,$gender,$age,$educ,$skills,$jobxp){
  37.     mw();
  38.     $Arrage=[$age-=1,$age+=2,$age-=3,$age+=4];
  39.     echo "Searched: $gender, $age, $educ, $skills, $jobxp<br>";
  40.     echo "Result ranging from age: $Arrage[2] .. $Arrage[3]<br>";
  41.     $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";
  42.     $result = $con->query($sql);
  43.  
  44.     while($row = $result->fetch_assoc()) {
  45.         $a=$row['gender'];
  46.         $b=$row['age'];
  47.         $c=$row['educ_attain'];
  48.         $d=$row['skills'];
  49.         $e=$row['jobxp'];
  50.         $HTML=<<<HTML
  51. $a | $b | $c | $d | $e
  52. <br>
  53.  
  54. HTML;
  55.         echo $HTML;
  56.     }
  57. }
  58.  
  59. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement