Advertisement
Guest User

Untitled

a guest
Nov 29th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?php
  2. $servername = "168.144.91.34";
  3. $username = "aluno";
  4. $password = "?Rc2018!";
  5. $db = "rc_4";
  6.  
  7. // Create connection
  8. $conn =mysqli_connect($servername, $username, $password, $db);
  9.  
  10. // Check connection
  11. // if ($conn->connect_error) {
  12. // die("Connection failed: " . $conn->connect_error);
  13. // }
  14.  
  15. $sql = "SELECT * FROM veiculos WHERE quilometros > 50000";
  16. $result = mysqli_query($conn, $sql);
  17. if (mysqli_num_rows($result)> 0) {
  18. while ($row = mysqli_fetch_assoc($result)) {
  19. echo "Marca " . $row['marca'] . ", modelo " . $row['modelo'] . ", matricula " . $row['matricula'] . ", quilometros " . $row['quilometros'] . "<br>";
  20. }
  21. }
  22. ?>
  23. <!DOCTYPE html>
  24. <html>
  25. <head>
  26. <title></title>
  27. </head>
  28. <body>
  29.  
  30. </body>
  31. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement