Ovo dole je ono do čega sam ja uspeo da dođem:
Code:
<?php
include ("database.php");
$pdo = database::connect();
$brands = ["modern", "classic"];
$qMarks = str_repeat('?,', count($brands) - 1) . '?';
$statement = $pdo->prepare("SELECT naziv, cena, slika, boja_naziv, brand_naziv, format_naziv
FROM produkti LEFT JOIN boja_kon ON produkti_id = produkti.id
LEFT JOIN format ON format_id = format.id
LEFT JOIN brand ON brand_id = brand.id
LEFT JOIN boja ON boja_id = boja.id WHERE brand_naziv IN ($qMarks)");
$statement -> execute($brands);
$results = $statement -> fetchAll(PDO::FETCH_ASSOC);
$json = json_encode($results);
echo($json);
// $_GET['brand_id']
?>
<?php
include ("database.php");
$pdo = database::connect();
$brands = ["modern", "classic"];
$qMarks = str_repeat('?,', count($brands) - 1) . '?';
$statement = $pdo->prepare("SELECT naziv, cena, slika, boja_naziv, brand_naziv, format_naziv
FROM produkti LEFT JOIN boja_kon ON produkti_id = produkti.id
LEFT JOIN format ON format_id = format.id
LEFT JOIN brand ON brand_id = brand.id
LEFT JOIN boja ON boja_id = boja.id WHERE brand_naziv IN ($qMarks)");
$statement -> execute($brands);
$results = $statement -> fetchAll(PDO::FETCH_ASSOC);
$json = json_encode($results);
echo($json);
// $_GET['brand_id']
?>
A ovo mi je otprilike potrebno:
Code:
$statement = $pdo->prepare("SELECT naziv, cena, slika, boja_naziv, brand_naziv, format_naziv
FROM produkti LEFT JOIN boja_kon ON produkti_id = produkti.id
LEFT JOIN format ON format_id = format.id
LEFT JOIN brand ON brand_id = brand.id
LEFT JOIN boja ON boja_id = boja.id WHERE brand_naziv IN ($qMarks) AND format_naziv IN (//niz sa formatima) AND boja_naziv IN (//niz sa bojama)");
$statement = $pdo->prepare("SELECT naziv, cena, slika, boja_naziv, brand_naziv, format_naziv
FROM produkti LEFT JOIN boja_kon ON produkti_id = produkti.id
LEFT JOIN format ON format_id = format.id
LEFT JOIN brand ON brand_id = brand.id
LEFT JOIN boja ON boja_id = boja.id WHERE brand_naziv IN ($qMarks) AND format_naziv IN (//niz sa formatima) AND boja_naziv IN (//niz sa bojama)");
Da li je ovo uopšte pravi pristup? Funkcionalnost koju želim da postignem je otprilike slična ovoj: https://www.weddingpaperdivas....ntage--wedding_invitations.htm
"Stop crying Eddie, cuz you can get the fuck out."
"You're gettin' the fuck...
I know you're seven !"
"But you'll be a seven year old
walkin' the dog no house motherfucker !"
"You're gettin' the fuck...
I know you're seven !"
"But you'll be a seven year old
walkin' the dog no house motherfucker !"