$max) { $title = substr($title, 0, $max-1); $pos = strpos($title, ' ',$max-10); if ($pos === false) { $title .= '...'; } else { $title = substr($title, 0, $pos).'...'; } } return $title; } function pages($url,$url2,$page,$pages) { if ($pages>1) { echo "

Page: "; if ($page <> 1) { $pagep = $page - 1; if ($page == 2) { echo "\"\"Précédente"; } else { echo "\"\"Précédente"; } } $start = 1; if ($page < $pages - 10) { $pages = $page + 10; if ($pages - 20 > 0) { $start = $pages - 20; } } for($i=$start;$i<=$pages;$i++){ if($i==$page){ print " $i   "; }else{ if ($i == 1) { print " $i   "; } else { print " $i   "; } } } if ($page <> $pages) { $page++; echo "Suivante\"\""; } echo "

"; } } //$kat = array("All","Sandals","Slippers","Boots","Lace up Shoes","Slip on Shoes"); $kat = array("Toutes","Bottes","Bottines","Chaussons","Baskets basses","Baskets montantes","Tongs","Sandales","Espadrilles","Mocassins","Non spécifié","Derbies","Chaussures bateau", "Richelieus", "Baskets", "Chaussures de sport", "Chaussures à lacets"); $id_kat = array("0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16"); $size = array("37","37.5","38","38.5","39","39.5","40","40.5","41","41.5","42","42.5","43","43.5","44","44.5","45","45.5","46","46.5","47","47.5","48","48.5","49"); if ($_GET['s']) { $_GET['s'] = htmlspecialchars(stripslashes(trim($_GET['s'])), ENT_QUOTES); for ($i=0;$i query($query0); $r = $stmt -> fetch(); if ($r[0]) { $s_brand = $r[0]; $title .= ' - '.$s_brand; $link_m = '/marque-'.$_GET['m']; } $query3 = "(brand_link LIKE '".$_GET['m']."') and "; } $coltab = array("Toutes", "Blanc", "Gris", "Beige", "Marron", "Noir", "Bleu", "Turquoise", "Petrole", "Vert", "Kaki", "Jaune", "Orange", "Rouge", "Rose", "Lilas", "Or", "Argent", "Multicolore"); $coltab1 = array("Toutes", "blanc", "gris", "beige", "marron", "noir", "bleu", "turquoise", "petrole", "vert", "kaki", "jaune", "orange", "rouge", "rose", "lilas", "or", "argent", "multicolore"); $coltab2 = array("Toutes", "blanches", "grises", "beiges", "marron", "noires", "bleues", "turquoise", "petrole", "vertes", "kaki", "jaunes", "orange", "rouges", "roses", "lilas", "or", "argent", "multicolores"); if ($_GET['f']) { $_GET['f'] = htmlspecialchars(stripslashes(trim($_GET['f'])), ENT_QUOTES); $link_f = '/colour-'.$_GET['f']; foreach ($coltab1 as $key => $val) { if ($_GET['f'] == $val) { //$s_farbe = $coltab[$key]; $idf = $key; $title .= ' - '.$coltab[$idf]; $link_f = '/couleur-'.$coltab1[$idf]; $s_farbe = $coltab[$idf]; break; } } if ($_GET['f'] =='non-specifie') { $idf='0'; $link_f = '/couleur-non-specifie'; } $query4 = "(col='$idf') and "; } if ($idk) { $query1 = "((category='$idk') or (category2='$idk') or (category3='$idk')) and "; } if ($s_size) { $tmp = str_replace('.','_',$s_size); $query2 = "(s$tmp = '1') and "; } if ($_GET['promos']) { $_GET['promos'] = htmlspecialchars(stripslashes(trim($_GET['promos'])), ENT_QUOTES); if ($_GET['promos']=='promos') { $query5 = "(priceold>price) and "; $sale = ' checked="checked"'; $link_sale = '/promos'; $title .= ' - Promos %'; } } $query0 = "SELECT count(*) FROM fr_shoes_m WHERE "; $query0 .= $query1; $query0 .= $query2; $query0 .= $query3; $query0 .= $query4; $query0 .= $query5; $query0 .= " (ok=1)"; $stmt = $pdo -> query($query0); $r = $stmt -> fetch(); if ($_GET['p'] == '') { $page = 1; } else { $page = $_GET['p']; } $offset = ($page-1)*20; $pages = ceil($r[0]/20); $alle = $r[0]; if (!$alle) $_GET['d']='e'; if ($page>$pages) $_GET['d']='e'; ?> '; echo ' '; if ($alle) $site_index = ''; else $site_index = 'no'; if (($page>$pages) && ($alle)) { $site_index = 'no'; @include('./inc/canonical.inc'); } echo ' '; echo ' Chaussures Hommes - '.$title.''; ?>

Chaussures Hommes '.$s_kat.' '; } if ($_GET['g']) { echo ' > '.$s_size.' '; } if ($_GET['m']) { echo ' > '.$s_brand.' '; } if ($_GET['f']) { echo ' > '.$s_farbe.' '; } if ($link_sale) { echo ' > Promos % '; } ?>

Catégorie
    0) GROUP BY category"; $stmt = $pdo -> query($query0); while($r = $stmt -> fetch()) { $tabc[$r[0]] += $r[1]; } $query0 = "SELECT category2, count(*) FROM fr_shoes_m WHERE "; $query0 .= $query2; $query0 .= $query3; $query0 .= $query4; $query0 .= $query5; $query0 .= " (ok=1) and (category2<>0) GROUP BY category2"; $stmt = $pdo -> query($query0); while($r = $stmt -> fetch()) { $tabc[$r[0]] += $r[1]; } $tmp = []; $all = 0; for ($i=1;$i<20;$i++) { if (array_key_exists($i, $tabc) && $tabc[$i] > 0) { $link1=str_replace($search,$replace,$kat[$i]); $link1 =strtolower(preg_replace("/[^a-z0-9-]/i", "", $link1)); if (($idk0) && ($idk0==$i)) { $tmp["$kat[$i]"] = '
  • '.$kat[$i].' ('.$tabc[$i].')
  • '; $tmpsel1["$kat[$i]"] = ''; } else { $tmp["$kat[$i]"] = '
  • '.$kat[$i].' ('.$tabc[$i].')
  • '; $tmpsel1["$kat[$i]"] = ''; } $all += $tabc[$i]; } } if ($idk0==0) { echo '
  • Toutes ('.$all.')
  • '; $sel1 = ''; } else { echo '
  • Toutes ('.$all.')
  • '; $sel1 = ''; } ksort($tmp); foreach ($tmp as $key => $val) { echo $val; $sel1 .= $tmpsel1[$key]; } ?>
Taille
    Toutes'; $sel2 = ''; } else { echo '
  • Toutes
  • '; $sel2 = ''; } $stmt = $pdo -> query($query0); $r = $stmt -> fetch(); for ($i=0;$i0) { $link1=str_replace('.','-',$size[$i]); if (($idg==$i) && ($_GET['g'])) { echo '
  • '.$size[$i].' ('.$r[$i].')
  • '; $sel2 .= ''; } else { echo '
  • '.$size[$i].' ('.$r[$i].')
  • '; $sel2 .= ''; } } } ?>
Marque
    query($query0); $r = $stmt -> fetch(); $all = $r[0]; $cbrands = $r[1]; $query0 = "SELECT brand, count(*) as rsum FROM fr_shoes_m WHERE "; $query0 .= $query1; $query0 .= $query2; $query0 .= $query4; $query0 .= $query5; $query0 .= " (ok=1) GROUP BY brand ORDER BY rsum DESC LIMIT 200"; $stmt = $pdo -> query($query0); $num_rows = $stmt->rowCount(); while ($r = $stmt->fetch()) { $ibrands[$r['brand']] = $r['rsum']; } if ($ibrands) { ksort($ibrands); if ($s_brand) { echo '
  • Toutes ('.$all.')
  • '; } else { echo '
  • Toutes ('.$all.')
  • '; } foreach ($ibrands as $key => $val) { $link1=str_replace($search,$replace,$key); $link1 =strtolower(preg_replace("/[^a-z0-9-]/i", "", $link1)); if (($_GET['m']) && ($_GET['m']==$link1)) { echo '
  • '.$key.' ('.$val.')
  • '; } else { echo '
  • '.$key.' ('.$val.')
  • '; } } } ?>
Couleur
8) GROUP BY col"; $stmt = $pdo -> query($query0); $sum = 0; while($r = $stmt -> fetch()) { $sum += $r[1]; $rcol[$r[0]] = $r[1]; } echo 'Toutes '; $rest = $rcol[0]; unset($rcol[0]); } else { $query0 .= " (ok=1) and (col<>0) and (col<>8) GROUP BY col"; $stmt = $pdo -> query($query0); $sum = 0; while($r = $stmt -> fetch()) { $sum += $r[1]; $rcol[$r[0]] = $r[1]; } echo 'Toutes '; $rest = $alle-$sum; } if ($rcol) { foreach ($rcol as $key1 => $val1) { foreach ($coltab as $key => $val) { if ($key1==$key) { if ($key==$idf) { echo ''.$val.' '; } else { echo ''.$val.' '; } } } } } if (($_GET['f'] =='non-specifie') && ($alle)) { echo 'Non spécifié '; } else { if ($rest>0) { echo 'Non spécifié '; } } ?>
Prix
    query($query0); $r = $stmt -> fetch(); echo '
  • Toutes ('.$r[0].')
  • '; echo '
  • Promos ('.$alle.')
  • '; $price_sale = $alle; } else { $query0 .= "(priceold>price) and "; $query0 .= " (ok=1)"; $stmt = $pdo -> query($query0); $r = $stmt -> fetch(); echo '
  • Toutes ('.$alle.')
  • '; if ($r[0]>0) echo '
  • Promos ('.$r[0].')
  • '; $price_sale = $r[0]; } ?>
'; if ($s_kat) { if ($s_kat=='Non spécifié') { echo 'Chaussures '; } else { echo $s_kat.' '; } } else { echo 'Chaussures Hommes '; } if ($s_brand) { echo $s_brand.' '; } if ($idf) { echo $coltab2[$idf].' '; } if ($s_size) { echo ' taille '.$s_size.' '; } if ($link_sale) { echo '- Promos %'; } echo ''; if ($s_kat=='Non spécifié') { echo '

Non spécifié

'; } echo '

'.$alle.' articles trouvés. Page '.$page.' / '.$pages.'.

'; ?>

>Catégorie:   >Taille:   >Marque:   Couleur: '; } else { if ($_GET['f'] =='non-specifie') echo 'Couleur: '; else echo 'Couleur: '; } ?>  

Toutes ('.$sum.')'; } else { if ($_GET['f'] =='not-specified') echo ' Toutes ('.$sum.')'; else echo ''; } foreach ($rcol as $key1 => $val1) { foreach ($coltab as $key => $val) { if ($key1==$key) { if ($key==$idf) { echo ''; } else { echo ' '.$val.' ('.$val1.')'; } } } } if ($rest>0) { if ($_GET['f'] =='non-specifie') echo ''; else echo ' Non spécifié ('.$rest.')'; } ?>
Les moins chers / Les plus chers / Marque A-Z / Marque Z-A'; $query_o = "ORDER BY price DESC"; } else if ($_GET['a']==3) { $sort = 3; echo 'Trier par: Les moins chers / Les plus chers / Marque A-Z / Marque Z-A'; $query_o = "ORDER BY brand ASC"; } else if ($_GET['a']==4) { $sort = 4; echo 'Trier par: Les moins chers / Les plus chers / Marque A-Z / Marque Z-A'; $query_o = "ORDER BY brand DESC"; } } else { echo 'Trier par: Les moins chers / Les plus chers / Marque A-Z / Marque Z-A'; $query_o = "ORDER BY price ASC"; } ?> query($query); while($row = $stmt -> fetch()) { echo ''; echo ''; echo ''; $link1=str_replace($search,$replace,$row[brand]); $link1 =strtolower(preg_replace("/[^a-z0-9-]/i", "", $link1)); echo ''; echo ''; $par = sid_code($row[product_url],1); echo ''; echo ''; } echo '
'; if ($row['dir']<>0) { echo ''.$row[name].''; } $fullprice = $row[price]+$row[shipping_cost]; $sale=''; if (($row["priceold"]==0) || ($row["priceold"]<=$row["price"])) $row["priceold"]=''; else $sale = round(($row["priceold"]-$row["price"])*100/$row["priceold"]); $row[price] = str_replace('.',',',$row[price]); if (($page==1) && (!$price_from)) $price_from = $row[price]; $row[priceold] = str_replace('.',',',$row[priceold]); $row[description] = txtcut($row[description],150); $row[size] = rtrim($row[size],','); echo ''.$row[name].'

'.$row[description].'

Marque: '.$row[brand].'
'; echo 'Taille: '.$row[size].'
€ '.$row[price]; if ($row["priceold"]) { echo " € ".$row["priceold"].""; } echo ''; if ($sale) { echo '
-'.$sale.'%
'; } if ($row[shipping_cost]=='0') { echo 'Livraison gratuite
'; } else { $row[shipping_cost] = number_format($row[shipping_cost], 2, ',', ''); echo 'Livraison: €'.$row[shipping_cost].'
'; } $fullprice = number_format($fullprice, 2, ',', ''); echo 'Prix global: €'.$fullprice.'
'; if ($row[availability]<>'') { echo 'Availability: '.$row[availability].'
'; } echo 'Boutique: '.$row[shop_name].'
'; if ($_GET['a']) { pages("homme{$link_s}{$link_g}{$link_m}{$link_f}{$link_sale},a$sort",".html",$page,$pages); } else { pages("homme{$link_s}{$link_g}{$link_m}{$link_f}{$link_sale}","",$page,$pages); } if ($_GET['d'] !== 'e') { echo <<