CODEWITHSUNDEEP
phphtmlmysql
D. Iseli
D. Iseli

Reputation: 61

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?

Upvotes: 0

Views: 50

Answers (2)

Herry Potei
Herry Potei

Reputation: 179

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

Upvotes: 3

Bobert123
Bobert123

Reputation: 113

change 

"SELECT count(*) FROM gamesnw"

to

"SELECT count(*) AS cntt FROM gamesnw"

Upvotes: 1

Related Questions