///////////// 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
Push-in flexiplugs for pipe ends
Speed-Fit. Single Push-Fit application and accurate fitting.
You might also be interested in these PROTEC standards
CAPTOP® EP 283
Tapered plugs with pull ring tab
CAPTOP® EP 207
High temperature cylindrical closures
CAPTOP® EP 306
Push-in flange face protectors
CAPTOP® EP 505
Threaded caps - Flanged - With sealing disk
Certified production & quality management
PROTEC meets the most stringent demands of safety and operations reliability. International approvals and certifications such as UL, CSA, VDE, VDA 6.1 and DIN EN ISO 9001: 2015 demonstrate total quality commitment on superior level.
Be the first to know - Join our newsletter!
Stay on top of the latest news and upcoming events and event information from PROTEC and its partner. Be the first to know when new products are on the market. Get periodic specials and news delivered directly to your email inbox! You can un-subscribe anytime.