Advertisement
Guest User

Untitled

a guest
Nov 3rd, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.17 KB | None | 0 0
  1. <?php
  2. $dbServerName = "127.0.0.1";
  3. $dbUser = "izet";
  4. $dbPass = "1234";
  5. $dbName = "databasefundamentals";
  6. $dbConn = new mysqli($dbServerName, $dbUser, $dbPass, $dbName);
  7.  
  8. if (isset($_POST["submit"])) {
  9. $name = $_POST["tekst"];
  10. $query = "SELECT * from student WHERE first_name = '$name'";
  11. $dbConn -> query($query);
  12.  
  13.  
  14. $result = $dbConn -> query($query);
  15.  
  16. if ($result -> num_rows > 0) {
  17. while ($row = $result -> fetch_assoc()) {
  18. echo $row['first_name'] . "\n";
  19. }
  20. }
  21. $dbConn -> close();
  22. }
  23. ?>
  24. <!doctype html>
  25. <html lang="en">
  26. <head>
  27. <title>Title</title>
  28. <!-- Required meta tags -->
  29. <meta charset="utf-8">
  30. <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  31.  
  32. <!-- Bootstrap CSS -->
  33. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/css/bootstrap.min.css" integrity="sha384-PsH8R72JQ3SOdhVi3uxftmaW6Vc51MKb0q5P2rRUpPvrszuE4W1povHYgTpBfshb" crossorigin="anonymous">
  34. </head>
  35. <body>
  36. <form action="blabla.php" method="post">
  37. <div class="form-group">
  38. <input type="text"
  39. class="form-control" name="tekst" id="tekst" aria-describedby="helpId" placeholder="">
  40. <small id="helpId" class="form-text text-muted">Help text</small>
  41. </div>
  42. <button name="submit" type="submit" class="btn btn-primary">Submit</button>
  43. </form>
  44.  
  45. <!-- Optional JavaScript -->
  46. <!-- jQuery first, then Popper.js, then Bootstrap JS -->
  47. <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
  48. <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.3/umd/popper.min.js" integrity="sha384-vFJXuSJphROIrBnz7yo7oB41mKfc8JzQZiCq4NCceLEaO4IHwicKwpJf9c9IpFgh" crossorigin="anonymous"></script>
  49. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/js/bootstrap.min.js" integrity="sha384-alpBpkh1PFOepccYVYDB4do5UnbKysX5WZXm3XxPqe5iKTfUKjNkCk9SaVuEZflJ" crossorigin="anonymous"></script>
  50. </body>
  51. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement