Habsburg

Na

Jun 1st, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. /// JQUERY
  2. function getPictures() {
  3. korIme = getCookie("username");
  4. $.get("slike.php", {source: "bezTaga", korisnickoIme: korIme}, function(res) {
  5. res = JSON.parse(res);
  6. for(var i = 0; i < res.length; ++i) {
  7. var imeDisk = res[i][0];
  8. var imePravo = res[i][1];
  9. var putanja = res[i][2] + imeDisk;
  10. var tagovi = res[i][3];
  11. $("#wrap").prepend("<div class='box'><div class='boxInner'><img src='" + putanja +"' /><div class='titleBox'>" + imePravo + "</div><div class='tagBox'>" + tagovi + "</div></div></div>");
  12. }
  13. });
  14. }
  15.  
  16. ///PHP
  17. <?php
  18. include "baza_class.php";
  19. $baza = new Baza();
  20. $baza->spojiDB();
  21.  
  22. $input = $_GET["source"];
  23.  
  24. if($input == "bezTaga") {
  25. $imenaPutanjaSlika = array();
  26. $upit = "SELECT * from slike where korisnici_korime = '" . $_GET["korisnickoIme"]. "'";
  27. $rez = $baza->selectDB($upit);
  28.  
  29. while($row = $rez->fetch_assoc()) {
  30. $upit = "SELECT * from tagovi where slika_id = " . $row["id"];
  31. $rez2 = $baza->selectDB($upit);
  32.  
  33. $tagovi = "";
  34. while($row2 = $rez2->fetch_assoc()) {
  35. $tagovi = $tagovi . ", " . $row2["tag"];
  36. }
  37.  
  38. $imenaPutanjaSlika[] = array($row["ime_nadisku"], $row["ime_pravo"], $row["putanja"], $tagovi);
  39. }
  40. echo json_encode($imenaPutanjaSlika, JSON_UNESCAPED_UNICODE);
  41. }
  42.  
  43.  
  44. exit;
  45. ?>
Advertisement
Add Comment
Please, Sign In to add comment