Abonnement | Bellen + SMS | Internet | Prijs | ||
---|---|---|---|---|---|
if ($row['bundel1_aantal'] + $row['bundel2_aantal'] == 0) echo '0'; else if ($row['bundel1_aantal'] == 9999 && $row['bundel2_aantal'] == 9999) echo 'onbeperkt'; else { if ($row['bundel1_aantal'] == 9999) echo 'onbeperkt'; else echo $row['bundel1_aantal']; echo ' + '; if ($row['bundel2_aantal'] == 9999) echo 'onbeperkt'; else echo $row['bundel2_aantal']; } ?> | switch ($row['bundel3_type']) { case 2: if ((float)$row['bundel3_snelheid'] >= 225) { ?>4G+ } else { ?>4G } break; } ?> |
€0,00 |
Kies telefoon |
Mobiele telefoons
Merken
$brands = $db->fetchAll('SELECT naam, COUNT(*) AS aantal, SUM(sales) AS verkopen FROM `Merk` ' .
'INNER JOIN `Toestel` USING (merk_nr) ' .
'INNER JOIN `Toestel_eigenschap` USING (toestel_nr) ' .
'WHERE Merk.omgeving_nr IN (1, 2) AND Toestel.omgeving_nr IN (1, 2) AND Toestel.categorie_nr = 1 ' .
'AND Toestel.has_sublinks > 0 AND Toestel.has_retlinks > 0 AND Toestel_eigenschap.eigenschap_nr = 37 ' .
'GROUP BY merk_nr ORDER BY verkopen DESC');
$countBrands = count($brands);
$breakPoint = ceil($countBrands / 3);
for ($i = 0; $i < $countBrands; $i++) {
// New column
if ($i > 0 && $i % $breakPoint === 0) {
?>
Top 5 populair
$rows = $db->fetchAll('SELECT toestel_nr, naam, serie, type, alias, TRIM(CONCAT(naam, " ", IFNULL(serie, ""), " ", type, " ", IFNULL(alias, ""))) AS prodName, img_nr FROM `Toestel` ' .
'INNER JOIN `Merk` USING (merk_nr) ' .
'WHERE has_sublinks > 0 AND has_retlinks > 0 ' .
'ORDER BY sales DESC LIMIT 5');
foreach ($rows as $row) {
?>
}
// Clear results
unset($rows);
?>
Top 5 nieuw
$rows = $db->fetchAll('SELECT toestel_nr, naam, serie, type, alias, TRIM(CONCAT(naam, " ", IFNULL(serie, ""), " ", type, " ", IFNULL(alias, ""))) AS prodName, img_nr FROM `Toestel` ' .
'INNER JOIN `Merk` USING (merk_nr) ' .
'WHERE has_sublinks > 0 AND has_retlinks > 0 ' .
'ORDER BY datum_verkrijgbaar DESC LIMIT 5');
foreach ($rows as $row) {
?>
}
// Clear results
unset($rows);
?>