<?php
                                $host = "127.0.0.1";
                                $dbuser = "root";
                                $dbpass = "ascent";
                                $dbname = "auth";
                                $conn = mysqli_connect($host, $dbuser, $dbpass, $dbname);

                                $status= 1;

                                $stmt = $conn->prepare("SELECT * FROM account");
                                $stmt->bind_param("i", $status);
                                $stmt->execute();
                                $stmt->bind_result($charname);
                                $stmt->store_result();
                                  if($stmt->num_rows > 0) {
                                    while($stmt->fetch()) {
                                      echo $stmt->num_rows;
                                                }
                                }
                                ?>