Prompt Van De Dag
$today = (new DateTime('today'))->format('Y-m-d'); $stmt = $pdo->prepare('SELECT p.*, c.name AS cat, e.name AS eng FROM posts p JOIN categories c ON p.category_id=c.id JOIN engines e ON p.engine_id=e.id WHERE p.published=1 AND p.publish_date<=? ORDER BY p.publish_date DESC LIMIT 1'); $stmt->execute([$today]); $post = $stmt->fetch(); if (!$post): echo '

Nog geen prompt voor vandaag

Kom later terug of bekijk het archief.

'; else: $title = e($post['title']); $slug = e($post['slug']); $canonical = url('prompt/'.$slug); $avg = $pdo->prepare('SELECT ROUND(AVG(rating),2) a, COUNT(*) c FROM ratings WHERE post_id=?'); $avg->execute([$post['id']]); $r = $avg->fetch(); $try = $pdo->prepare('SELECT SUM(tried=1) y, SUM(tried=0) n FROM tries WHERE post_id=?'); $try->execute([$post['id']]); $t = $try->fetch(); ?>
Categorie:
Warning: Undefined variable $post in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 54

Warning: Trying to access array offset on value of type null in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 54
· Engine:
Warning: Undefined variable $post in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 54

Warning: Trying to access array offset on value of type null in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 54
· Datum:
Warning: Undefined variable $post in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 54

Warning: Trying to access array offset on value of type null in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 54


Warning: Undefined variable $post in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 55

Warning: Trying to access array offset on value of type null in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 55


Warning: Undefined variable $post in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 56

Warning: Trying to access array offset on value of type null in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 56

Warning: Undefined variable $post in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 57

Warning: Trying to access array offset on value of type null in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 57

Warning: Undefined variable $post in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 57

Warning: Trying to access array offset on value of type null in /home/u657303534/domains/promptvandedag.be/public_html/index.php on line 57
Voorbeeld