Advertisement
Guest User

Untitled

a guest
Nov 29th, 2018
606
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 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 = new mysqli($servername, $username, $password, $db);
  9.  
  10. // Check connection
  11. if ($conn->connect_error) {
  12. die("Connection failed: " . $conn->connect_error);
  13. }
  14.  
  15. $mysqli = new mysqli($servername, $username, $password, $db);
  16.  
  17. $sql = "SELECT * FROM veiculos WHERE quilometros > 50000";
  18. $result = mysqli_query($conn, $sql);
  19. if (mysqli_num_row($result > 0)) {
  20. while ($row = mysqli_fetch_assoc($result)) {
  21. echo "Marca " . $row['marca'] . ", modelo " . $row['modelo'] . ", matricula " . $row['matricula'] . ", quilometros " . $row['quilometros'] . "<br>";
  22. }
  23. }
  24. ?>
  25. <!DOCTYPE html>
  26. <html>
  27. <head>
  28. <title></title>
  29. </head>
  30. <body>
  31.  
  32. </body>
  33. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement