PHP / MySQL计数（*）并在html中使用var

Question

I'm trying to count all rows of a dataset and would like to print the number later as part of a small statistic.

But I'm not sure, where my error might be. The html returns (echo) works well if I only display a text, but it won't show the amount of rows.

PHP:

<?php
session_start();
require_once("inc/config.inc.php");
require_once("inc/functions.inc.php");

$user = check_user();

include("templates/header.inc.php");

$statement = $pdo->prepare("SELECT count(*) FROM gamesnw");
$nw = $statement->fetch();

?>

html:

<div class="col-md-6">
 <h1><?php echo htmlentities($nw); ?><h1>
  <h3>Nachwuchsspiele</h3>
   <p>Anzahl in der Datenbank erfasste Nachwuchsspiele.</p>
</div>

any ideas?

Answer 1

You did not execute your prepared statement. What you have to do is add this after your prepared statement: $statement->execute(). Hope I helped :)