PHP - Acortar páginación

$perPage = 12;

	if($result["url"] == "informatica") { $search = "WHERE cat LIKE '%Accesorios para PC Gaming%' OR cat LIKE '%Almacenamiento%' OR cat LIKE '%Componentes de PC%' OR cat LIKE '%Conectividad y redes%' OR cat LIKE '%Estabilizadores y UPS%' OR cat LIKE '%Impresión%' OR cat LIKE '%Ordenadores portátiles y accesorios%' OR cat LIKE '%Lectores y escáneres%' OR cat LIKE '%Monitores y accesorios%' OR cat LIKE '%Periféricos de PC%' OR cat LIKE '%Proyectores y pantallas%' OR cat LIKE '%Tablets y accesorios%'"; }

	if($result["url"] == "componentes-de-pc") { $search = "WHERE cat LIKE '%Componentes%'"; }

										   $stmt = $pdo->prepare("SELECT count(*) as num_rows FROM products $search");

		$stmt->execute();

		$row = $stmt->fetch(PDO::FETCH_ASSOC);

        $total_results = $row['num_rows'];

    $total_pages = ceil($total_results / $perPage);

    // Current page

    $page = isset($_GET['page']) ? $_GET['page'] : 1;

    $starting_limit = ($page - 1) * $perPage;

	$stmt1 = $pdo->prepare("SELECT name,img,id FROM products $search ORDER BY id DESC LIMIT $starting_limit,$perPage");

	$stmt1->execute();

	while ($i = $stmt1->fetch(PDO::FETCH_ASSOC)) {

	$a = $pdo->prepare("SELECT shop_id, url, MIN(pvp) as minimo FROM products_shops WHERE product_id=".$i["id"]."");

	$a->execute();

		$a = $a->fetch(PDO::FETCH_ASSOC);

		$b = $pdo->prepare("SELECT shop_name FROM shops WHERE id=".$a["shop_id"]."");

	$b->execute();

		$b = $b->fetch(PDO::FETCH_ASSOC);

		$count = $pdo->prepare("SELECT COUNT(*) as num_rows FROM products_shops WHERE product_id=".$i["id"]."");

		$count->execute();

		$row = $count->fetch(PDO::FETCH_ASSOC);

        $totalRowCount = $row['num_rows'];

		?>

	<div class="widget">

    <div class="widgetImage animation">

      <img src="<?php echo $i["img"]; ?>" alt="<?php echo $i["name"]; ?>" />

    </div>

    <div class="widgetContent animation">

		<span class="cap t12 bold"><?php echo decrypt($b["shop_name"],$key); ?></span>

      <h2 class="widgetTitle"><?php echo substr($i["name"], 0, 77); if(strlen($i["name"]) > 77) { echo "..."; } ?></h2>

		<span class="price t18 bold"><?php echo $a["minimo"]; ?> €</span><span class="t11 right1">(Envío incluido)</span><br/><div class="sop"><?php if($totalRowCount>1) { ?><span class="icon-check green t16"></span> <?php } ?>

		<span class="t12"><?php if($totalRowCount>1) { ?>El precio más bajo<?php } else { ?>Único precio disponible<?php } ?></span></div>

		<br/><br/><a href="<?php echo $a["url"]; ?>" target="_blank" title="<?php if($totalRowCount>1) { ?>Ir a la mejor oferta<?php } else { ?>Ir a la oferta<?php } ?>" rel="nofollow"><div class="snd"><?php if($totalRowCount>1) { ?>Ir a la mejor oferta<?php } else { ?>Ir a la oferta <?php } ?></div></a><hr/>

		<div class="snd2">

		<?php if($totalRowCount>1) { ?><b>Ver</b> las <b><?php echo $totalRowCount; ?></b> tiendas <?php } else { ?> Ver producto en <b><?php echo substr(decrypt($b["shop_name"],$key), 0, 13); if(strlen(decrypt($b["shop_name"],$key)) > 13) { echo "..."; } ?></b> <?php } ?></div>

		<br/>

		<?php $stmt3 = $pdo->prepare("SELECT pvp, url, shop_id FROM products_shops WHERE product_id=".$i["id"]." ORDER BY pvp ASC LIMIT 3");

	$stmt3->execute();

	$i=1;

	while ($c = $stmt3->fetch(PDO::FETCH_ASSOC)) {

		$d = $pdo->prepare("SELECT shop_name FROM shops WHERE id=".$c["shop_id"]."");

	$d->execute();

		$d = $d->fetch(PDO::FETCH_ASSOC);

		?>

		<div class="prices" <?php if($i<3 && $totalRowCount>1){ echo "style=\"border-bottom:1px solid #eee\""; } ?>><a href="<?php echo $c["url"]; ?>" target="_blank" title="Ir a la oferta de <?php echo decrypt($d["shop_name"],$key); ?>" rel="nofollow"><span class="slc"><?php echo $i; ?>º</span><span class="nme"><?php echo substr(decrypt($d["shop_name"],$key), 0, 16); if(strlen(decrypt($d["shop_name"],$key)) > 16) { echo "..."; } ?></span> <div class="price bold"><?php echo $c["pvp"]; ?> €</div></a></div>

		<?php

		$i++;

	}

		?>

    </div>

  </div>

	<?php

	}

		?><?php for ($page = 1; $page <= $total_pages ; $page++):?>

        <a href='?page=<?php echo $page ?>' class="links">

            <?php  echo $page; ?>

	</a> |

	<?php endfor; ?>

<?php

  $sidePages = 10;

  $total_pages = 25;

  if ($total_pages > ($sidePages * 2)) {

    for ($page=1; $page<$sidePages+1 ; $page++) {

      echo ' | <a class="links" href="?page='.$page.'">'.$page.'</a>';

    }

    echo ' | ... | ';

    for ($page=$total_pages-$sidePages+1; $page<=$total_pages; $page++) {

      echo '<a class="links" href="?page='.$page.'">'.$page.'</a> | ';

    }

  } else {

    for ($page=1; $page<=$total_pages; $page++) {

      echo ' | <a class="links" href="?page='.$page.'">'.$page.'</a>';

    }

    echo ' |';

  }

?>