时间戳

首页 > 解决方案 > 在 PHP 仪表板中显示数据库记录数

php - 在 PHP 仪表板中显示数据库记录数

问题描述

我需要在我的 SQLtable“医生”中显示记录（行）的“计数”。此计数必须出现在我的仪表板页面的以下元素中，以获取医生总数

这是我的仪表板页面的 index.php

    <?php

$con = mysqli_connect("localhost","root","","hospital_db");
$result = mysqli_query($con,"SELECT * FROM doctors");
$rows = mysqli_num_rows($result);

  $content = '<div class="row">
        <div class="col-lg-3 col-xs-6">
          <!-- small box -->
          <div class="small-box bg-aqua">
            <div class="inner">
             <h3><?php echo '.$rows.';?></h3>

              <p>Doctors</p>
            </div>
            <div class="icon">
              <i class="ion ion-bag"></i>
            </div>
            <a href="http://localhost/medibed/doctor" class="small-box-footer">View Doctors <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>
        <!-- ./col -->

      </div>';
  include('../master.php');
?>

标签： phpsqldatabasecountecho

解决方案

您应该在新的 php 版本中使用 mysqli 对象尝试以下代码

首先建立连接

<?php

$con = mysqli_connect("localhost","my_user","my_password","my_db");

$result = mysqli_query($con,"SELECT * FROM doctors");
$rows = mysqli_num_rows($result);
echo "There are " . $rows . " rows in my table.";

  $content = '<div class="row">
        <div class="col-lg-3 col-xs-6">
          <!-- small box -->
          <div class="small-box bg-aqua">
            <div class="inner">
              *<h3><?php echo "$rows"; } ?></h3>*

              <p>Doctors</p>
            </div>
            <div class="icon">
              <i class="ion ion-bag"></i>
            </div>
            <a href="http://localhost/medibed/doctor" class="small-box-footer">View Doctors <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>
        <!-- ./col -->

      </div>';
  include('../master.php');
?>

推荐阅读