<?php
require_once ( 'config.php' ) ;
$html = '' ;
$page = $_GET [ 'page' ] ;
$rowsPerPage = NUM_ITEMS_BY_PAGE;
$offset = ( $page - 1 ) * $rowsPerPage ;
$result = $connexion -> query (
'SELECT * FROM ps_product p
LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_lang = 1)
LEFT JOIN `ps_image` i ON (i.id_product = p.id_product AND cover = 1)
WHERE active = 1
ORDER BY date_upd DESC LIMIT ' . $offset . ', ' . $rowsPerPage
) ;
if ( $result -> num_rows > 0 ) {
while ( $row = $result -> fetch_assoc ( ) ) {
$html .= '<li class="col-lg-4">' ;
$html .= '<div class="item">' ;
$html .= '<img class="img-fluid mx-auto d-block" src="https://w...content-available-to-author-only...r.com/modulos-prestashop/' . $row [ 'id_image' ] . '-home_default/' . $row [ 'link_rewrite' ] . '.jpg" width="100" height="100" />' ;
$html .= '<p class="price">' . round ( $row [ 'price' ] , 2 ) . ' EUR</p>' ; $html .= '<p><a class="btn btn-primary link_rewrite mx-auto d-block" href="https://w...content-available-to-author-only...r.com/modulos-prestashop/es/' . $row [ 'id_product' ] . '-' . $row [ 'link_rewrite' ] . '.html" target="_blank"><i class="fa fa-eye"></i> Ver</a></p>' ;
$html .= '</div>' ;
$html .= '</li>' ;
}
}
echo $html ;
?>
PD9waHAKcmVxdWlyZV9vbmNlKCdjb25maWcucGhwJyk7CgokaHRtbCA9ICcnOwokcGFnZSA9ICRfR0VUWydwYWdlJ107CiRyb3dzUGVyUGFnZSA9IE5VTV9JVEVNU19CWV9QQUdFOwokb2Zmc2V0ID0gKCRwYWdlIC0gMSkgKiAkcm93c1BlclBhZ2U7CnNsZWVwKDEpOwoKJHJlc3VsdCA9ICRjb25uZXhpb24tPnF1ZXJ5KAogICAgJ1NFTEVDVCAqIEZST00gcHNfcHJvZHVjdCBwIAogICAgTEVGVCBKT0lOIHBzX3Byb2R1Y3RfbGFuZyBwbCBPTiAocGwuaWRfcHJvZHVjdCA9IHAuaWRfcHJvZHVjdCBBTkQgcGwuaWRfbGFuZyA9IDEpIAogICAgTEVGVCBKT0lOIGBwc19pbWFnZWAgaSBPTiAoaS5pZF9wcm9kdWN0ID0gcC5pZF9wcm9kdWN0IEFORCBjb3ZlciA9IDEpIAogICAgV0hFUkUgYWN0aXZlID0gMSAKICAgIE9SREVSIEJZIGRhdGVfdXBkIERFU0MgTElNSVQgJy4kb2Zmc2V0LicsICcuJHJvd3NQZXJQYWdlCik7CmlmICgkcmVzdWx0LT5udW1fcm93cyA+IDApIHsKICAgIHdoaWxlICgkcm93ID0gJHJlc3VsdC0+ZmV0Y2hfYXNzb2MoKSkgewogICAgICAgICRodG1sIC49ICc8bGkgY2xhc3M9ImNvbC1sZy00Ij4nOwogICAgICAgICRodG1sIC49ICc8ZGl2IGNsYXNzPSJpdGVtIj4nOwogICAgICAgICRodG1sIC49ICc8aW1nIGNsYXNzPSJpbWctZmx1aWQgbXgtYXV0byBkLWJsb2NrIiBzcmM9Imh0dHBzOi8vdy4uLmNvbnRlbnQtYXZhaWxhYmxlLXRvLWF1dGhvci1vbmx5Li4uci5jb20vbW9kdWxvcy1wcmVzdGFzaG9wLycuJHJvd1snaWRfaW1hZ2UnXS4nLWhvbWVfZGVmYXVsdC8nLiRyb3dbJ2xpbmtfcmV3cml0ZSddLicuanBnIiB3aWR0aD0iMTAwIiBoZWlnaHQ9IjEwMCIgLz4nOwogICAgICAgICRodG1sIC49ICc8aDM+Jy51dGY4X2VuY29kZSgkcm93WyduYW1lJ10pLic8L2gzPic7CiAgICAgICAgJGh0bWwgLj0gJzxwIGNsYXNzPSJkZXNjcmlwdGlvbl9zaG9ydCI+Jy5zdHJpcF90YWdzKHV0ZjhfZW5jb2RlKCRyb3dbJ2Rlc2NyaXB0aW9uX3Nob3J0J10pKS4nPC9wPic7CiAgICAgICAgJGh0bWwgLj0gJzxwIGNsYXNzPSJwcmljZSI+Jy5yb3VuZCgkcm93WydwcmljZSddLCAyKS4nIEVVUjwvcD4nOwogICAgICAgICRodG1sIC49ICc8cD48YSBjbGFzcz0iYnRuIGJ0bi1wcmltYXJ5IGxpbmtfcmV3cml0ZSBteC1hdXRvIGQtYmxvY2siIGhyZWY9Imh0dHBzOi8vdy4uLmNvbnRlbnQtYXZhaWxhYmxlLXRvLWF1dGhvci1vbmx5Li4uci5jb20vbW9kdWxvcy1wcmVzdGFzaG9wL2VzLycuJHJvd1snaWRfcHJvZHVjdCddLictJy4kcm93WydsaW5rX3Jld3JpdGUnXS4nLmh0bWwiIHRhcmdldD0iX2JsYW5rIj48aSBjbGFzcz0iZmEgZmEtZXllIj48L2k+IFZlcjwvYT48L3A+JzsKICAgICAgICAkaHRtbCAuPSAnPC9kaXY+JzsKICAgICAgICAkaHRtbCAuPSAnPC9saT4nOwogICAgfQp9CgplY2hvICRodG1sOwo/Pg==