///////////// 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
DURA-SAFE® SES 3000
Protection pour traitement par sablage
CAPTOP® EP 505
Capuchons filetés d'étanchéité
CAPTOP® EP 207
Capuchons de protection en silicone
CAPTOP® EP 283
Bouchons Universels avec languette annulaire
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.