define('COLS', 3); define('ROWS', 2); define('QUALITY', 7); if (!$_GET['page']) $_GET['page'] = 0; include_once($_SERVER['DOCUMENT_ROOT'].'/inc/mysql.inc.php'); $url_appendix = ''; $where_keytype = ''; if (is_array($_GET['key_type'])) { foreach ($_GET['key_type'] as $val) { $where_keytype .= " or key_type='$val'"; $url_appendix .= '&key_type[]='.$val; } }elseif ($_GET['key_type']) { $where_keytype = " or key_type = '$_GET[key_type]'"; $url_appendix .= '&key_type='.$_GET['key_type']; } $where_keywords = ''; if (is_array($_GET['Keywords_web'])) { foreach ($_GET['Keywords_web'] as $val) { $where_keywords .= " or keywords_web like '%$val%'"; $val = stripslashes($val); $url_appendix .= '&Keywords_web[]='.$val; } }elseif ($_GET['Keywords_web']) { $where_keywords = " or keywords_web like '%$_GET[Keywords_web]%'"; $_GET['Keywords_web'] = stripslashes($_GET['Keywords_web']); $url_appendix .= '&Keywords_web='.$_GET['Keywords_web']; } if (!$_GET['Keywords_web'] && !$_GET['key_type']) { $where_keywords = " or 1"; $url_appendix = ''; } $e = $db->query("select count(*) anz from fotoarchiv where quality=".QUALITY." and (0 $where_keytype $where_keywords)"); $d = $db->fetch($e); $anzahl = $d['anz']; $pages = ceil($anzahl / (COLS*ROWS)); $cur_page = $_GET['page']; $prev_page = $_GET['page'] - 1; $next_page = $_GET['page'] + 1; $e = $db->query("select * from fotoarchiv where quality=".QUALITY." and (0 $where_keytype $where_keywords) order by no_codebar desc limit ".$_GET[page]*COLS*ROWS.", ".COLS*ROWS); ?>
|
||||||||||||||||||||||||||||
|