Advertisement
Guest User

Untitled

a guest
Jun 16th, 2016
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.83 KB | None | 0 0
  1. <?php
  2.  
  3. error_reporting(-1);
  4. ini_set('display_errors', 'On');
  5. ob_start();
  6. include_once './baza.class.php';
  7. $baza = new Baza();
  8.  
  9. if(isset($_SESSION['idTipKorisnika']) && $_SESSION['idTipKorisnika']==1){
  10. $upit = "select * from Korisnik";
  11. $rezultat = $baza->selectDB($upit);
  12.  
  13. $xml = new DOMDocument("1.0", "UTF-8");
  14. $korisnik = $xml->createElement("korisnik");
  15. $korisnik = $xml->appendChild($korisnik);
  16.  
  17. while($red = $rezultat->fetch_array()){
  18. $podaci = $xml->createElement("podaci");
  19. $podaci = $korisnik->appendChild($podaci);
  20.  
  21. $id = $xml->createElement("id", $red[0]);
  22. $id = $podaci->appendChild($id);
  23.  
  24. $mail = $xml->createElement("mail", $red[7]);
  25. $mail = $podaci->appendChild($mail);
  26.  
  27. $ime = $xml->createElement("ime", $red[1]);
  28. $ime = $podaci->appendChild($ime);
  29.  
  30. $prezime = $xml->createElement("prezime", $red[2]);
  31. $prezime = $podaci->appendChild($prezime);
  32.  
  33. $username = $xml->createElement("username", $red[3]);
  34. $username = $podaci->appendChild($username);
  35.  
  36. $password = $xml->createElement("password", $red[4]);
  37. $password = $podaci->appendChild($password);
  38.  
  39. }
  40. $xml->formatOutput = true;
  41. $string_value = $xml->saveXML();
  42. $xml->save("userList.xml");
  43.  
  44. date_default_timezone_set('Europe/Zagreb');
  45. $time = date('Y/m/d h:i:s');
  46. $log_user = $_SESSION['idKorisnik'];
  47. $upit = "select * from Korisnik where idKorisnik = $log_user";
  48. $rezultat = $baza->selectDB($upit);
  49. $arrayz = $rezultat->fetch_array();
  50. $upit = "insert into Dnevnik values(default, '$log_user', '$time', 'Korisnik $arrayz[0] je zatrazio popis korisnika','0')";
  51. $baza->updateDB($upit);
  52. }else{
  53. date_default_timezone_set('Europe/Zagreb');
  54. $time = date('Y/m/d h:i:s');
  55. $id_user = $_GET['idKorisnik'];
  56. $log_user = $_SESSION['idKorisnik'];
  57. $upit = "select * from Korisnik where idKorisnik = $log_user";
  58. $rezultat = $baza->selectDB($upit);
  59. $arrayz = $rezultat->fetch_array();
  60. $upit = "insert into Dnevnik values(default, '$log_user', '$time', 'Neuspjeli pokusaj pristupa korisnika $arrayz[0] na stranicu userList.php','0')";
  61. $baza->updateDB($upit);
  62. header("Location: failedToAccess");
  63. }
  64. ?>
  65.  
  66.  
  67. <!DOCTYPE html>
  68. <html>
  69. <head>
  70. <title>Prijava</title>
  71. <meta charset="UTF-8">
  72. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  73. <meta name="author" content="Mateo Matic">
  74. <meta name="keywords" content="FOI, WebDiP">
  75. <link href="css/mmatic2.css" rel="stylesheet" type="text/css">
  76. <script src="js/mmatic2.js"></script>
  77. </head>
  78. <body>
  79. <header style="background-color: grey">
  80. <a href="index.html">
  81. <img src="img/logo.png" alt="foi_logo" width="300" height="80">
  82. </a>
  83. <?php
  84. if(isset($_SESSION['loggedin']) && $_SESSION['loggedin']==true){
  85. $username = $_SESSION['korisnicko_ime'];
  86. echo "<a href='logout.php' id= 'signInLink'> Odjavi se " . $username . "</a>";
  87. }else{
  88. echo "<a href='prijava.php' id='signInLink'>Prijavi se</a>";
  89. }
  90. ?>
  91. </header>
  92. <section id="izbornik">
  93. <h5 style="visibility: hidden; display: inline">Izbornik</h5>
  94. <nav>
  95. <a href="registracija.php">Registracija</a>
  96. <a href="prijava.php">Prijava</a>
  97.  
  98. </nav>
  99. </section>
  100.  
  101. <section id="sadrzaj">
  102. <div id="prijava">
  103.  
  104.  
  105.  
  106. </div>
  107. </section><br>
  108. <article id="greska"></article>
  109. <footer class="podnozje" style="text-align: center">
  110. <h1 class="kraj"> Vrijeme rješavanja: 30min</h1>
  111. <img src="img/HTML5.png" alt="html5" width="50" height="50">
  112. <img src="img/CSS3.png" alt="css" width="50" height="50">
  113. </footer>
  114. <script type="text/javascript">
  115. var myTable = $("<table id='userListTable' class='display'>");
  116. myTable.append("<thead><tr><th>ID</th><th>E-mail</th><th>Ime</th><th>Prezime</th><th>Username</th><th>Password</th></tr></thead>");
  117. $(document).ready(function(){
  118. $.ajax({
  119. type: 'GET',
  120. url: './userList.xml',
  121. dataType: 'xml',
  122. success: function (data) {
  123. var tbody = $("<tbody>");
  124. $(data).find('podaci').each(function (){
  125. var red = "<tr>";
  126.  
  127. red += "<td>" + $(this).find('id').text() + "</td>";
  128. red += "<td>" + $(this).find('mail').text() + "</td>";
  129. red += "<td>" + $(this).find('ime').text() + "</td>";
  130. red += "<td>" + $(this).find('prezime').text() + "</td>";
  131. red += "<td>" + $(this).find('username').text() + "</td>";
  132. red += "<td>" + $(this).find('password').text() + "</td>";
  133.  
  134. red += "</tr>";
  135. tbody.append(red);
  136. });
  137. tbody.append("</tbody>");
  138. myTable.append(tbody);
  139.  
  140. $("$prijava").html(myTable);
  141. dataTablez();
  142.  
  143.  
  144. }
  145. });
  146. });
  147. </script>
  148. <script src='js/fetchStatistics.js'></script>
  149. </body>
  150. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement