evo ovo je cijela stranica, uspio sam napravid da mi u sql queryu ubaci $val variablu ali kad odaberem 2 check boxa onda mi neubaci u query a echo variable tocno ispise,
Code:
<?php
$sql = 'SELECT * FROM objects WHERE zupanija = "obiteljske"';
if (! empty($__current['database']['query'])) {
$box=$_POST['box'];
while (list ($key,$val) = @each ($box)) {
echo "$val";
$sql .= '' . $val . ' ORDER BY id DESC';}
}
if (isset($__current['database']['per_page'])) {
$result_total = mysql_query($sql);
if ($result_total) {
$total_objects = mysql_num_rows($result_total);
mysql_free_result($result_total);
}
$total_pages = ceil((int)$total_objects / (int)$__current['database']['per_page']);
if (isset($_GET['l'])) {
$limit = $_GET['l'];
}
$sql .= ' LIMIT ' . (int)$limit . ', ' . (int)$__current['database']['per_page'];
}
if ((int)$__query[3] > 0) {
$object = new S_Object;
if ($object->load((int)$__query[3])) {
$__current['title'][$__language] = $object->{'naziv_' . $__language} . ' - ' . $__current['title'][$__language];
include('object_galerija.details.php');
}
} else {
$query = mysql_query($sql);
include('templates/' . $__config['template'] . '/header.php');
include('templates/' . $__config['template'] . '/menu2.php');
?>
<div id="content">
<div style="float:left">
<h1><?=$__current["title"][$__language]?></h1>
</div>
<div style="float:right; padding-top:10px;">
<p>
<form action="../">
<select onchange="window.open(this.options[this.selectedIndex].value,'_top')">
<option value="">Sortiraj po...</option>
<option value="<?php echo '/' . $__language . '/galerija'?>">Sve</option>
<option value="<?php echo '/' . $__language . '/galerija_obi'?>">Obiteljske</option>
<option value="<?php echo '/' . $__language . '/galerija_sta'?>">Stambene</option>
<option value="<?php echo '/' . $__language . '/galerija_vis'?>">Visestambene</option>
<option value="<?php echo '/' . $__language . '/galerija_pos'?>">Poslovne</option>
<option value="<?php echo '/' . $__language . '/galerija_sak'?>">Sakralne</option>
<option value="<?php echo '/' . $__language . '/galerija_stu'?>">Urb/Arh studije</option>
</select>
</form>
<?
echo "<form method=post action=''>";
echo "<table border='0' cellspacing='0' style='border-collapse: collapse' width='100' >
<tr bgcolor='#ffffff'>
<td width='25%'><input type=checkbox name=box[] value='AND interijer = 1 '></td>
<td width='25%'> Interijer</td>
<td width='25%'><input type=checkbox name=box[] value='AND detalji = 1 '></td>
<td width='25%'> Detalji</td>
<td colspan =6 align=center><input type=submit value=Filtriraj></form></td></tr>
</table>"; ?>
</p>
</div>
<?php
echo '<!--' . $sql . '-->';
//************************************************************************
// PAGER
//************************************************************************
if ($total_pages > 1) {
?>
<div class="pager">
<?php
$page_next = $limit + $__current['database']['per_page'];
$page_next_limit_string = '/?l=' . $page_next;
$page_prev = $limit - $__current['database']['per_page'];
$page_prev_limit_string = '/?l=' . $page_prev;
if ((int)$page_prev == 0) {
$page_prev_limit_string = '';
}
if ($page_prev > -1) {
?>
<a href="<?php echo '/' . $__language . '/' . $__current['link'][$__language] . $page_prev_limit_string ?>" class="arrow"><<</a>
<?php
}
for ($p = 1; $p <= $total_pages; $p++) {
$page_limit = ($p-1)*$__current['database']['per_page'];
$page_limit_string = '/?l=' . (int)$page_limit;
if ($page_limit == 0) {
$page_limit_string = '';
}
?>
<a<?php
if ($limit == $page_limit) echo ' class="selected"';
?> href="<?php echo '/' . $__language . '/' . $__current['link'][$__language] . $page_limit_string ?>"><?=$p?></a>
<?php
}
if ($page_next < $total_objects) {
?>
<a href="<?php echo '/' . $__language . '/' . $__current['link'][$__language] . $page_next_limit_string ?>" class="arrow">>></a>
<?php
}
?>
</div>
<div class="clear"></div>
<?php
}
//************************************************************************
if ($query) {
$counter = 0;
while ($o = mysql_fetch_assoc($query)) {
include('object_galerija.small.php');
$counter++;
}
}
//************************************************************************
// PAGER
//************************************************************************
if ($total_pages > 1) {
?>
<div class="clear"></div>
<div class="pager">
<?php
$page_next = $limit + $__current['database']['per_page'];
$page_next_limit_string = '/?l=' . $page_next;
$page_prev = $limit - $__current['database']['per_page'];
$page_prev_limit_string = '/?l=' . $page_prev;
if ((int)$page_prev == 0) {
$page_prev_limit_string = '';
}
if ($page_prev > -1) {
?>
<a href="<?php echo '/' . $__language . '/' . $__current['link'][$__language] . $page_prev_limit_string ?>" class="arrow"><<</a>
<?php
}
for ($p = 1; $p <= $total_pages; $p++) {
$page_limit = ($p-1)*$__current['database']['per_page'];
$page_limit_string = '/?l=' . (int)$page_limit;
if ((int)$page_limit == 0) {
$page_limit_string = '';
}
?>
<a<?php
if ($limit == $page_limit) echo ' class="selected"';
?> href="<?php echo '/' . $__language . '/' . $__current['link'][$__language] . $page_limit_string ?>"><?=$p?></a>
<?php
}
if ($page_next < $total_objects) {
?>
<a href="<?php echo '/' . $__language . '/' . $__current['link'][$__language] . $page_next_limit_string ?>" class="arrow">>></a>
<?php
}
?>
</div>
<?php
}
//************************************************************************
?>
</div>
<?
include('templates/' . $__config['template'] . '/footer.php');
}
?>