doouzlrvb01417498
2017-09-26 10:39 阅读 37
已采纳

PHP / MySQL计数(*)并在html中使用var

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?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

2条回答 默认 最新

  • 已采纳
    duanfen2349 duanfen2349 2017-09-26 10:48

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

    点赞 评论 复制链接分享
  • duanming7833 duanming7833 2017-09-26 10:41

    change

    "SELECT count(*) FROM gamesnw" 
    

    to

    "SELECT count(*) AS cntt FROM gamesnw"
    
    点赞 评论 复制链接分享

相关推荐