D. Iseli D. Iseli - 26 days ago 6
MySQL Question

PHP / MySQL count (*) and using var in html

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 Source

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