Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /// JQUERY
- function getPictures() {
- korIme = getCookie("username");
- $.get("slike.php", {source: "bezTaga", korisnickoIme: korIme}, function(res) {
- res = JSON.parse(res);
- for(var i = 0; i < res.length; ++i) {
- var imeDisk = res[i][0];
- var imePravo = res[i][1];
- var putanja = res[i][2] + imeDisk;
- var tagovi = res[i][3];
- $("#wrap").prepend("<div class='box'><div class='boxInner'><img src='" + putanja +"' /><div class='titleBox'>" + imePravo + "</div><div class='tagBox'>" + tagovi + "</div></div></div>");
- }
- });
- }
- ///PHP
- <?php
- include "baza_class.php";
- $baza = new Baza();
- $baza->spojiDB();
- $input = $_GET["source"];
- if($input == "bezTaga") {
- $imenaPutanjaSlika = array();
- $upit = "SELECT * from slike where korisnici_korime = '" . $_GET["korisnickoIme"]. "'";
- $rez = $baza->selectDB($upit);
- while($row = $rez->fetch_assoc()) {
- $upit = "SELECT * from tagovi where slika_id = " . $row["id"];
- $rez2 = $baza->selectDB($upit);
- $tagovi = "";
- while($row2 = $rez2->fetch_assoc()) {
- $tagovi = $tagovi . ", " . $row2["tag"];
- }
- $imenaPutanjaSlika[] = array($row["ime_nadisku"], $row["ime_pravo"], $row["putanja"], $tagovi);
- }
- echo json_encode($imenaPutanjaSlika, JSON_UNESCAPED_UNICODE);
- }
- exit;
- ?>
Advertisement
Add Comment
Please, Sign In to add comment