Suchergebnis verfeinern:

Eigenschaften

---

Abmessungen

---

".$value."\""; $s=""; } ?> ".$value.""; $s=""; } ?> ".$value.""; $s=""; } ?> ".$value.""; $s=""; } ?> query("SELECT produkte.id,produkte.artikelnr,produkte.normserie,produkte.produktnummerid, normserien.gattung, normserien.serie, normserien.suchindex, normserien.titel, normserien.vtext FROM produkte LEFT JOIN normserien ON produkte.produktnummer = normserien.serie WHERE sprache='".$_SESSION['lang']."' and aktiv=1 and normserien.filter like '%,".$_POST['anwendung'].",%' ".$sql." and ( normserie = 'ep270' and trim(replace(wert8,' ','')) = 'R".$_POST['pidfilter'][0]."\"' or normserie = 'ep280' and trim(replace(wert13,' ','')) = '".$_POST['pidfilter'][0]."\"' or normserie = 'ep283' and trim(replace(wert11,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep285' and trim(replace(wert13,' ','')) = '".$_POST['pidfilter'][0]."\"' or normserie = 'ep320' and trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][0]."\"' or normserie = 'ep340' and trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][0]."\"' or normserie = 'ep350' and trim(replace(wert15,' ','')) = 'R".$_POST['pidfilter'][0]."\"' or normserie = 'ep360' and trim(replace(wert11,' ','')) = 'R".$_POST['pidfilter'][0]."\"' or normserie = 'ep370' and trim(replace(wert6,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep385' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep400' and trim(replace(wert1,' ','')) = 'R".$_POST['pidfilter'][0]."\"' or normserie = 'ep4000' and trim(replace(wert1,' ','')) = 'R".$_POST['pidfilter'][0]."\"' or normserie = 'ep434' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep435' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep437' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep439' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' or normserie = 'ep445' and trim(replace(wert1,' ','')) = 'G".$_POST['pidfilter'][0]."\"' ) order by normserie, sortierfolge asc "); $ProdukteArray = $qPID->fetchAll(PDO::FETCH_ASSOC); $anzahlprodukte=count($ProdukteArray); }elseif(!empty($_POST['pidfilter'][1])) # metrisch { $_POST['pidfilter'][1]=str_replace(' ','',$_POST['pidfilter'][1]); $qPID = $pdo->query("SELECT produkte.id,produkte.artikelnr,produkte.normserie,produkte.produktnummerid, normserien.gattung, normserien.serie, normserien.suchindex, normserien.titel, normserien.vtext FROM produkte LEFT JOIN normserien ON produkte.produktnummer = normserien.serie WHERE sprache='".$_SESSION['lang']."' and aktiv=1 and normserien.filter like '%,".$_POST['anwendung'].",%' ".$sql." and ( (normserie = 'ep270' and ( trim(replace(wert4,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert5,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert6,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep280' and ( trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert11,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert12,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep283' and ( trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][1]."' )) or (normserie = 'ep285' and ( trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert11,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert12,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep320' and ( trim(replace(wert4,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert5,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert6,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep340' and ( trim(replace(wert5,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert6,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep350' and ( trim(replace(wert6,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert11,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert12,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert13,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert14,' ','')) = '".$_POST['pidfilter'][1]."')) or (normserie = 'ep360' and ( trim(replace(wert6,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert7,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert8,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][1]."' or trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][1]."' )) or (normserie = 'ep370' and trim(replace(wert5,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep380' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep385' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep400' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep4000' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep434' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep435' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep436' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep437' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep438' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep439' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep440' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) or (normserie = 'ep445' and trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][1]."' ) ) order by normserie, sortierfolge asc "); $ProdukteArray = $qPID->fetchAll(PDO::FETCH_ASSOC); $anzahlprodukte=count($ProdukteArray); }elseif(!empty($_POST['pidfilter'][2])) # Panzer { $_POST['pidfilter'][2]=str_replace(' ','',$_POST['pidfilter'][2]); $qPID = $pdo->query("SELECT produkte.id,produkte.artikelnr,produkte.normserie,produkte.produktnummerid, normserien.gattung, normserien.serie, normserien.suchindex, normserien.titel, normserien.vtext FROM produkte LEFT JOIN normserien ON produkte.produktnummer = normserien.serie WHERE sprache='".$_SESSION['lang']."' and aktiv=1 and normserien.filter like '%,".$_POST['anwendung'].",%' ".$sql." and ( (normserie = 'ep280' and trim(replace(wert14,' ','')) = '".$_POST['pidfilter'][2]."' ) or (normserie = 'ep283' and trim(replace(wert12,' ','')) = '".$_POST['pidfilter'][2]."' ) or (normserie = 'ep285' and trim(replace(wert14,' ','')) = '".$_POST['pidfilter'][2]."' ) or (normserie = 'ep320' and trim(replace(wert9,' ','')) = '".$_POST['pidfilter'][2]."' ) or (normserie = 'ep340' and trim(replace(wert10,' ','')) = '".$_POST['pidfilter'][2]."' ) or (normserie = 'ep350' and trim(replace(wert16,' ','')) = '".$_POST['pidfilter'][2]."' ) ) order by normserie, sortierfolge asc "); $ProdukteArray = $qPID->fetchAll(PDO::FETCH_ASSOC); $anzahlprodukte=count($ProdukteArray); }elseif(!empty($_POST['pidfilter'][3])) # UNF { $_POST['pidfilter'][3]=str_replace(' ','',$_POST['pidfilter'][3]); $qPID = $pdo->query("SELECT produkte.id,produkte.artikelnr,produkte.normserie,produkte.produktnummerid, normserien.gattung, normserien.serie, normserien.suchindex, normserien.titel, normserien.vtext FROM produkte LEFT JOIN normserien ON produkte.produktnummerid = normserien.id WHERE sprache='".$_SESSION['lang']."' and aktiv=1 and normserien.filter like '%,".$_POST['anwendung'].",%' ".$sql." and ( ( normserie = 'ep434' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep435' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep436' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep437' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep438' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep439' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep440' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) or ( normserie = 'ep445' and ( trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UN' or trim(replace(wert1,' ','')) = '".$_POST['pidfilter'][3]."UNF' ) ) ) order by normserie, sortierfolge asc "); $ProdukteArray = $qPID->fetchAll(PDO::FETCH_ASSOC); $anzahlprodukte=count($ProdukteArray); } elseif(!empty($_POST['pidfilter'][4])) # Massangabe OK 01.03.2018 SHA { $_POST['pidfilter'][4]=str_replace(' ','',$_POST['pidfilter'][4]); $qPID = $pdo->query("SELECT produkte.id,produkte.artikelnr,produkte.normserie,produkte.produktnummerid, normserien.gattung, normserien.serie, normserien.suchindex, normserien.titel, normserien.vtext FROM produkte LEFT JOIN normserien ON produkte.produktnummer = normserien.serie WHERE sprache='".$_SESSION['lang']."' and aktiv=1 and normserien.filter like '%,".$_POST['anwendung'].",%' ".$sql." and ( ( normserie = 'ep207' and wert11+wert6+wert6 =".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep230' and trim(replace(wert2,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep270' and wert1 =".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep270tk' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep275' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep280' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep283' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep285' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep285gl' and trim(replace(wert1,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep320' and wert1 =".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep330' and trim(replace(wert2,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep340' and wert1 =".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep350' and trim(replace(wert2,' ',''))+1 < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')-1) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep360' and trim(replace(wert2,' ',''))+1 < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')-1) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep370' and trim(replace(wert11,' ','')) < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert2,' ','')) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep380' and trim(replace(wert2,' ',''))+1 < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')-1) > ".floatval($_POST['pidfilter'][4])." ) or ( normserie = 'ep385' and trim(replace(wert2,' ',''))+1 < ".floatval($_POST['pidfilter'][4])." and trim(replace(wert3,' ','')-1) > ".floatval($_POST['pidfilter'][4])." ) ) order by normserie, sortierfolge asc "); $ProdukteArray = $qPID->fetchAll(PDO::FETCH_ASSOC); $anzahlprodukte=count($ProdukteArray); } ?>