query("SELECT url, entry_id, intro, body, aantal_woorden, afbeelding, titel, datum as datum_unixtime, favicon, DATE_FORMAT(FROM_UNIXTIME(datum), '%d-%m-%Y') as datum, DATE_FORMAT(FROM_UNIXTIME(datum), '%d %M %Y om %H:%i') as datum_uitgeschreven, IFNULL(aantal_reacties, 0) as aantal_reacties, shares_twitter, shares_linkedin, shares_facebook_totaal, shares_googleplus, shares_pinterest, IFNULL(shares_email, 0) as shares_email, IFNULL(shares_whatsapp, 0) as shares_whatsapp, IFNULL(incoming_links, 0) as incoming_links, (shares_twitter+shares_facebook_totaal+shares_pinterest+shares_linkedin+shares_googleplus) as shares, IFNULL(aantal_reacties, 0)+shares_twitter+shares_facebook_totaal+shares_pinterest+shares_linkedin+shares_googleplus+IFNULL(shares_whatsapp, 0)+IFNULL(shares_email, 0)+IFNULL(incoming_links, 0) as totaal_interacties, favicon, site_naam FROM artikelen INNER JOIN koppeltabel_auteurs ON artikelen.url=koppeltabel_auteurs.url_blog INNER JOIN sites ON sites.site_id=artikelen.site_id WHERE entry_id = '$entry' LIMIT 1"); while($row = $results->fetch_assoc()) { $url = $row["url"]; $entry_id = $row["entry_id"]; $titel = $row["titel"]; $intro = $row["intro"]; $body = $row["body"]; $afbeelding = $row["afbeelding"]; $aantal_woorden = $row["aantal_woorden"]; $datum = $row["datum"]; $datum_unixtime = $row["datum_unixtime"]; $datum_uitgeschreven = $row["datum_uitgeschreven"]; $shares = $row["shares"]; $aantal_reacties = $row["aantal_reacties"]; $aantal_twitter = $row["shares_twitter"]; $aantal_facebook = $row["shares_facebook_totaal"]; $aantal_linkedin = $row["shares_linkedin"]; $aantal_googleplus = $row["shares_googleplus"]; $aantal_pinterest = $row["shares_pinterest"]; $aantal_email = $row["shares_email"]; $aantal_links = $row["incoming_links"]; $totaal_interacties = $row["totaal_interacties"]; $interactiesminshares = $totaal_interacties - $shares; $interactiesminlinks = $totaal_interacties - $aantal_links; $interactiesminreacties = $totaal_interacties - $aantal_reacties; $favicon = ''.$row["favicon"].''; $site_naam = ''.$row["site_naam"].''; $slug = create_slug($titel); } $_SERVER['REQUEST_URI_PATH'] = parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH); $segments = multiexplode(array("/","?","&"), $_SERVER['REQUEST_URI_PATH']); if ($segments[3] != $slug){ header("HTTP/1.1 404 Not Found"); echo ''; exit; } // Wie is de auteur? $results = $mysqli->query("SELECT naam FROM auteurs WHERE url IN (SELECT url_auteur FROM koppeltabel_auteurs WHERE url_blog = '$url')"); while($row = $results->fetch_assoc()) { $auteur = ''.$row["naam"].''; } // Head settings $headtitle = ''.$titel.' | Blogosphere.co'; if ($intro == ''){ $headdescription = ''.substr($body, 0, 150).'...'; } elseif (strlen($intro) < 150){ $headdescription = $intro; } else { $headdescription = ''.substr($intro, 0, 150).'...'; } $headimage = $afbeelding; $headtwitter = array(); $headauteur = array(); $results = $mysqli->query("SELECT naam FROM auteurs WHERE url IN (SELECT url_auteur FROM koppeltabel_auteurs WHERE url_blog = '$url')"); while($row = $results->fetch_assoc()) { array_push($headauteur, $row["naam"]); $twitterresults = $mysqli->query("SELECT twitter FROM auteurs WHERE naam = '".$row["naam"]."' AND twitter != '' limit 1"); while($twitterrow = $twitterresults->fetch_assoc()) { array_push($headtwitter, $twitterrow["twitter"]); } } $headurl = 'http://www.blogosphere.co/artikel/'.$entry_id.'/'.$slug.''; $headtype = 'article'; $headpublisheddate = date("c", $datum_unixtime); include 'includes/header.php'; include 'includes/navbar.php'; include 'includes/menu.php'; include 'includes/precontent.php'; ?>

'; } ?>
Auteur(s)
query("SELECT naam, foto FROM auteurs WHERE url IN (SELECT url_auteur FROM koppeltabel_auteurs WHERE url_blog = '$url')"); while($row = $results->fetch_assoc()) { ?>
Info
1500) { echo 'Longread'; }?> woorden
,
">
Reacties
,
Backlinks
,
Social shares
">
Twitter
">
Google+
E-mail