///////////// SELECT END ///////////////////////////////////////////////////////////////////////////////////////////////////// ?> if(!empty($_POST['pidfilter'][0])) # Whitworth { # es müssen in der Tabelle "G", "R" und leerzeichen entfernt werden $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(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); } ?>
CAPTOP® EP 230
Bouchons universels à lamelles
Pour la fermeture des tubes
Diamètre compris entre 10,0 ...
Vous pourriez également être intéressé par ces séries PROTEC
CAPTOP® EP 306
Protecteurs de brides pour montage rapide
CAPTOP® EP 505
Capuchons filetés d'étanchéité
CAPTOP® EP 300
Protecteurs de brides
CAPTOP® EP 210
Capuchons souples à languette
Production certifiée et gestion de la qualité
PROTEC répond aux exigences les plus strictes en matière de sécurité et de fiabilité des opérations. Les approbations et certifications internationales que sont UL, CSA, BSA, DIN EN ISO 9001:2015 VDE et VDA 6.2 prouvent l'engagement total et de haut niveau qui est le nôtre en matière de qualité.
Soyez le premier informé - Inscrivez-vous à notre newsletter!
Restez informé des dernières nouvelles et événements à venir et disposez des informations sur les événements de PROTEC et de ses partenaires. Soyez le premier à savoir quand de nouveaux produits sont mis sur le marché. Recevez des promotions et disposez d'informations régulières directement dans votre boîte de réception ! Vous pouvez vous désabonner à tout moment.