Advertisement
Guest User

adminlog

a guest
May 24th, 2019
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.65 KB | None | 0 0
  1. <style>
  2. table {
  3. margin-top: 3%;
  4. border-collapse: collapse;
  5. width: 100%;
  6. color: #b56161;
  7. font-family: monospace;
  8. font-size: 25px;
  9. text-align: left;
  10. border: 3px solid #b56161;
  11.  
  12. }
  13. th {
  14. background-color: #b56161;
  15. color: white;
  16. }
  17. tr:nth-child(even) {background-color: #f2f2f2}
  18. </style>
  19. <table>
  20. <tr>
  21. <th>ID</th>
  22. <th>Ime</th>
  23. <th>Prezime</th>
  24. <th>Datum</th>
  25. <th>Grad</th>
  26. </tr>
  27. </div>
  28. </div>
  29. </div>
  30. </body>
  31. </html>
  32.  
  33.  
  34.  
  35. <?php
  36. $korisnik = $_POST['Korisnik'];
  37. $lozinka = $_POST['Lozinka'];
  38. $host="localhost"; // Host name
  39. $username="root"; // Mysql username
  40. $password=''; // Mysql password
  41. $db_name="myproject"; // Database name
  42. $tbl_name="users"; // Table name
  43.  
  44. // connect to database
  45. $con = mysqli_connect("$host","$username","$password", "$db_name");
  46.  
  47. $podaci = "SELECT ID, Ime, Prezime, Datum, Grad FROM users";
  48. $rezultat = $con->query($podaci);
  49. //mysqli_select_db("$con", "admin");
  50.  
  51. // Query the database for user
  52. $result = mysqli_query($con,"SELECT * FROM admin WHERE Korisnik = '$korisnik' and Lozinka = '$lozinka'")
  53. or die("Failed" .mysqli_error($con));
  54.  
  55. $row = mysqli_fetch_array($result);
  56. //if ($row['Korisnik'] == $korisnik && $row['Lozinka'] == $lozinka) {
  57.  
  58.  
  59.  
  60.  
  61.  
  62. if ($row['Korisnik'] == $korisnik && $row['Lozinka'] == $lozinka && $result->num_rows > 0){
  63. while($row = $rezultat->fetch_assoc()) {
  64. echo "<tr><td>" . $row["ID"] . "</td><td>" . $row["Ime"] . "</td><td>" . $row["Prezime"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Grad"] . "</td>"
  65. . "</td></tr>";
  66.  
  67.  
  68.  
  69.  
  70.  
  71.  
  72. }
  73. echo "</table>";
  74. }
  75.  
  76. else{
  77. echo "Neuspjela prijava!";
  78. }
  79.  
  80. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement