Count in Dashboard

[Aburajeh]

I Have Dashbord
I want put Employee's Counts

<div class="row">
                <div class="col-md-6 col-xl-3 mb-4">
                  <div class="card shadow border-0">
                    <div class="card-body">
                      <div class="row align-items-center">
                        <div class="col-3 text-center">
                          <span class="circle circle-sm">
                            <i class="nav-icon fa-address-card fa-solid text-muted mb-0"></i>
                          </span>
                        </div>
                        <div class="col pr-0">
                          <p class="small text-muted mb-0"><?= $Language->tablePhrase("employees_records", "TblCaption") ?></p>
>>here count>>             <span class="h3 mb-0">1,869</span>
                          <span class="small text-success">+16.5%</span>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div> <!-- end section -->

[arbei]

You need to execute query to get the count yourself, see ExecuteScalar().

[Aburajeh]

thank you its work