Advertisement
Guest User

Untitled

a guest
Sep 7th, 2017
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. $(function() {
  2. $("#b1").click(function() {
  3. $.ajax({
  4. type: "POST",
  5. url: "complista2.php",
  6. data: $("#preco").val(),
  7. success: $.get("complista2.php", function(data) {
  8. $("#paramount").html(data);
  9. })
  10. });
  11. });
  12. });
  13.  
  14. <input id="preco" type="text" name="preco" value='250 AND 500'><br><br>
  15.  
  16. <?php
  17.  
  18. $username = "root";
  19. $password = "";
  20. $server = "localhost";
  21. $database = "VRealidade";
  22. $conn = mysqli_connect($server, $username, $password, $database);
  23. if (!$conn) {
  24. die("Erro: " . mysqli_connect_error());
  25. } else {
  26. }
  27.  
  28. $preco = $_GET['preco'];
  29. $sql = "SELECT * FROM computadores WHERE preco BETWEEN $preco";
  30. $result = mysqli_query($conn, $sql);
  31. echo mysqli_error($conn);
  32. $row = mysqli_fetch_assoc($result);
  33. echo "<div class='entrada'>$row[nome]</div>";
  34. while($row = mysqli_fetch_assoc($result)) {
  35. echo "<div class='entrada'>$row[nome]</div>";
  36. }
  37.  
  38. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement