Advertisement
duca88

Untitled

Sep 18th, 2016
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.83 KB | None | 0 0
  1. <?php @session_start();
  2.  
  3.  
  4. if(isset($_REQUEST['btnUlogujse'])){
  5.  
  6. $username=$_REQUEST['tbUsername'];
  7. $password=$_REQUEST['tbPassword'];
  8. include('konn.php');
  9. $upitUlog="SELECT * FROM korisnici WHERE username='$username' AND password='$password'";
  10. $rezUlog=mysqli_query($conn,$upitUlog);
  11. if($rezUlog){
  12. $niz=mysqli_fetch_array($rezUlog);
  13. $_SESSION['idKor']=$niz['idKor'];
  14. $_SESSION['username']=$niz['username'];
  15. $_SESSION['idUloge']=$niz['idUloge'];
  16. $_SESSION['uloga']=$idUloga;
  17. switch($idUloga){
  18.  
  19. case '1':
  20. header("location:index.php?1");
  21. break;
  22. case '2':
  23. header("location:index.php?2");
  24. break;
  25. }
  26.  
  27. }else{
  28.  
  29.  
  30. echo "Ne postoji korisnik sa tim kor.imenom i lozinkom";
  31. }mysqli_close($conn);
  32. }
  33.  
  34. ?>
  35.  
  36. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  37. <html>
  38. <head>
  39. <script type="text/javascript" >
  40. function kreiranje(str)
  41. {
  42. if (str.length==0) {
  43. document.getElementById("search").innerHTML="";
  44.  
  45. return;
  46. }
  47. if (window.XMLHttpRequest) {
  48. // code for IE7+, Firefox, Chrome, Opera, Safari
  49. xmlhttp=new XMLHttpRequest();
  50. } else { // code for IE6, IE5
  51. xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  52. }
  53. xmlhttp.onreadystatechange=function() {
  54. if (xmlhttp.readyState==4 && xmlhttp.status==200) {
  55. document.getElementById("ispisPretrage").innerHTML=xmlhttp.responseText;
  56.  
  57. }
  58. }
  59. xmlhttp.open("GET","pretraga.php?search_text="+str,true);
  60. xmlhttp.send();
  61. }
  62.  
  63.  
  64. </script>
  65. </head>
  66. <body>
  67. <form action='index.php' method='post'>
  68. <?php if(!isset($_SESSION['idKor'])){ ?>
  69. <table border="1">
  70. <tr><th colspan='2'>Logovanje</th></tr>
  71. <tr><th>username</th><th>password</th></tr>
  72. <tr><td><input type="text" name="tbUsername"/></td><td><input type="password" name="tbPassword"/></td></tr>
  73. <tr><td colspan='2'align="center"><input type="submit" name="btnUlogujse" value="Uloguj se"/></td></tr>
  74. </table>
  75. <a href="registracija.php">Registruj se!</a>
  76. <?php }else{?>
  77. <a href="logout.php">logout</a>
  78. <p>
  79. <?php
  80. if(isset($_SESSION['idUloge'])){
  81.  
  82. print "Dobrodošli:".$_SESSION['username'];
  83. }
  84. ?>
  85. <?php } ?>
  86. </form><br/>
  87.  
  88. <div id="pretraga">
  89. <form action="" method="post" name="search" id="search">
  90. <input type="text" name="search_text" placeholder="pretrazi dela" onkeyup="kreiranje(this.value);"/><br/><br/>
  91. <?php
  92.  
  93.  
  94. if(isset($_GET['izabranoDelo'])){
  95.  
  96. $search_text=$_REQUEST['izabranoDelo'];
  97. if(!empty($search_text)){
  98. include("konn.php");
  99.  
  100. $upitP=" SELECT * FROM umetnickadela WHERE naziv LIKE '%$search_text%'";
  101. $rezP=mysqli_query($conn,$upitP) or die("greska u upitu".mysqli_error());
  102. echo '<table border="1">';
  103. while($niz=mysqli_fetch_array($rezP)){
  104. echo"<tr><td><a href='dodatneslike.php?idDela=".$niz["idDela"]."'>".$niz['naziv']."</a></td>
  105. <td>".$niz['podaci']."</td>
  106. <td><img src=".$niz['slika']." width=100 height=100/></td>";
  107. if($_SESSION['idKor']){
  108. echo "<td>".$niz['datumPostavke']."</td>
  109. <td>".$niz['cena']."</td>";
  110. }
  111. echo"</tr>";
  112.  
  113. }echo '</table>';
  114. } }
  115.  
  116. echo'</form>';
  117. echo'<div id="ispisPretrage"></div>';
  118. echo'</div><div>';
  119.  
  120.  
  121. include("konn.php");
  122. $upit1="select * from umetnickadela";
  123. $rez1=mysqli_query($conn,$upit1) or die("greska u upitu".mysqli_error());
  124. echo '<form action="" method="request"><table border="1">';
  125. while($niz1=mysqli_fetch_array($rez1)){
  126. echo"<tr><td>".$niz1['naziv']."</td>
  127. <td>".$niz1['podaci']."</td>
  128. <td><img src=".$niz1['slika']." width=100 height=100/></td>";
  129. if($_SESSION['idKor']){
  130. echo "<td>".$niz1['datumPostavke']."</td>
  131. <td>".$niz1['cena']."</td>";
  132. }
  133. echo"</tr>";
  134.  
  135. }echo '</table></form>';
  136. ?>
  137.  
  138. </div>
  139. </body></html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement