我需要在我的 SQLtable“醫(yī)生”中顯示記錄（行）的“計(jì)數(shù)”。此計(jì)數(shù)必須出現(xiàn)在我的儀表板頁(yè)面上醫(yī)生總數(shù)的以下元素中這是我的儀表板頁(yè)面的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');?>
2 回答
慕姐8265434
TA貢獻(xiàn)1813條經(jīng)驗(yàn) 獲得超2個(gè)贊
您應(yīng)該在新的 php 版本中使用 mysqli 對(duì)象嘗試以下代碼
首先建立連接就像
<?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');
?>
蠱毒傳說(shuō)
TA貢獻(xiàn)1895條經(jīng)驗(yàn) 獲得超3個(gè)贊
如果您只需要計(jì)數(shù)那么為什么不在查詢(xún)中使用聚合函數(shù) count(*) 呢？這對(duì)你有更好的幫助。在 h3 標(biāo)記的代碼中，您可以直接連接字符串，而不是再次使用 php 代碼。這可能看起來(lái)更好并且是結(jié)構(gòu)化的形式。
嘗試這個(gè)：
<?php
$con = mysqli_connect("localhost","my_user","my_password","my_db");
$result = mysqli_query($con,"SELECT count(*) as total_rows FROM doctors");
$rows = $result->total_rows;
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>'.$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');
?>
- 2 回答
- 0 關(guān)注
- 178 瀏覽
添加回答
舉報(bào)
0/150
提交
取消