';
while($record = mysql_fetch_array($query))
{
?>
" rel="stylesheet" type="text/css" />
'something',
), $atts ) );
$qtelReacties = mysql_query(
"SELECT count(*)
FROM ".$wpdb->prefix."alfie_producten
WHERE col_id='".intval($id)."'
");
$items_totaal = mysql_result($qtelReacties, 0);
$huidige_pagina = 0;
$items_per_pagina = 10;
$aantal_paginas = ceil($items_totaal / $items_per_pagina); // het aantal items per pagina
if(isset($_GET['pagina']) && is_numeric($_GET['pagina']) && $_GET['pagina'] > 0 && $_GET['pagina'] < $aantal_paginas) {
$huidige_pagina = $_GET['pagina'];
}
echo "
';
} else {
$query = $wpdb->query("INSERT INTO ".$wpdb->prefix."alfie_reactions (colid,matchid,naam,email,ranking,message)
VALUES ('".intval($_GET['colid'])."',
'".intval($_GET['matchid'])."',
'".$naam."',
'".$email."',
'".$ranking."',
'".$message."')");
}
if($query)
{
setcookie("posted","1",time()+50);
echo "";
}
}
}
// get reacties if there are reactions
$parse_rec = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."alfie_reactions WHERE matchid='".intval($_GET['matchid'])."' AND colid = '".intval($_GET['colid'])."' AND approved='1' ORDER BY datum DESC");
foreach ( $parse_rec as $rec_elem )
{
echo '
get_results("SELECT *
FROM ".$wpdb->prefix."alfie_producten
WHERE col_id='".intval($id)."'GROUP BY match_sequence
");
$items_totaal = count($qtelReacties);
$huidige_pagina = 0;
$items_per_pagina = 10;
$aantal_paginas = ceil($items_totaal / $items_per_pagina); // het aantal items per pagina
if(isset($_GET['pagina']) && is_numeric($_GET['pagina']) && $_GET['pagina'] > 0 && $_GET['pagina'] < $aantal_paginas) {
$huidige_pagina = $_GET['pagina'];
}
echo "
Page ";
for($i = 0; $i < $aantal_paginas; $i++) {
if($huidige_pagina == $i) {
echo "".($i+1)."";
} else {
if(strpos($_SERVER['QUERY_STRING'],"?"))
{ ?>
?&pagina=>
?&pagina=>
?pagina=>
';
$offset = $huidige_pagina * $items_per_pagina;
// show content
$parse_result = $wpdb->get_results(
"SELECT *
FROM ".$wpdb->prefix."alfie_producten
WHERE col_id='".intval($id)."' LIMIT ".$offset."," .$items_per_pagina
);
foreach ( $parse_result as $elems )
{
?>
'something',
), $atts ) );
?>
" rel="stylesheet" type="text/css" />
get_results("SELECT * FROM ".$wpdb->prefix."alfie_producten WHERE match_sequence='".intval($_GET['matchid'])."' AND col_id = '".intval($_GET['colid'])."' ORDER BY prijs ASC") or die (mysql_error());
$teller = 0;
foreach ( $parse_adv as $adv_elem )
{
$teller++;
if($teller==1)
{?>
";
} else {
if($_COOKIE['posted'])
{
echo 'Vergeleken bij de volgende winkels:
All fields are required
Spamming not allowed dude!
Thanks your message has been submited. The administrator will approve your message first.
';
echo 'Reaction from: '.$rec_elem->naam.'
'; echo $rec_elem->message.'
Rating:'; for($i=0; $i<$rec_elem->ranking;$i++) {?>
">
'.$rec_elem->datum.'
'; echo '
';
}
?>
'; echo $rec_elem->message.'
Rating:'; for($i=0; $i<$rec_elem->ranking;$i++) {?>
'; echo '
Add your comment here.
Page ";
for($i = 0; $i < $aantal_paginas; $i++) {
if($huidige_pagina == $i) {
echo "".($i+1)."";
} else {
if(strpos($_SERVER['QUERY_STRING'],"?"))
{ ?>
?&pagina=>
?&pagina=>
?pagina=>
';
$offset = $huidige_pagina * $items_per_pagina;
$parse_result = $wpdb->get_results(
"SELECT *
FROM ".$wpdb->prefix."alfie_producten
WHERE col_id='".intval($id)."'
GROUP BY match_sequence LIMIT ".$offset."," .$items_per_pagina
);
foreach ( $parse_result as $elems )
{
$count_match_occ = checkMatchingProduct($elems->match_sequence,$id);
$match_details = getCheapestDetails($elems->match_sequence);
$match_details = sorteleminarray($match_details,'prijs');
$price = "";
$product_url = "";
// check here if there are matching found
// if so choose the cheapest product otherwise the normal product
if($elems->match_sequence!=0)
{
$price = $match_details[0]["prijs"];
$adv_image = $match_details[0]["adv_img"];
$product_url = $match_details[0]["producturl"];
} else {
$price = $elems->prijs;
$product_url = $elems->producturl;
}?>
€
productnaam;?>
omschrijving,200);?>
match_sequence!=0) { ?> Vergeleken bij winkels.
match_sequence,intval($elems->col_id)); for($i=0; $i<$avgrate;$i++) {?>">
match_sequence,intval($elems->col_id))!=0)
{?>
Reviewed by match_sequence,intval($elems->col_id)); ?> users.
Meer informatie | Meer informatie | Meer informatie | Direct bestellen
omschrijving,200);?>
match_sequence!=0) { ?> Vergeleken bij winkels.
match_sequence,intval($elems->col_id)); for($i=0; $i<$avgrate;$i++) {?>
Meer informatie | Meer informatie | Meer informatie | Direct bestellen