Viewing File: /home/rareljzw/public_html/admin/dashboard.php
<?php
$pageName = "Dashboard";
include("./layout/header.php");
$sql = "SELECT * FROM users";
$stmt = $conn->prepare($sql);
$stmt->execute();
$row_count = $stmt->rowCount();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
//$balances = $row['acct_balance']->rowCount();
if(isset($_POST['newsletter'])){
$username = $_POST['username'];
$subjectid = $_POST['subjectid'];
$messageid = $_POST['messageid'];
if(true) {
$APP_NAME = $pageTitle;
$message = $sendMail->MessageUsers($fullName, $subjectid, $messageid, $APP_NAME);
$subject = "Notification - $APP_NAME";
$email_message->send_mail($email, $message, $subject);
if (true) {
toast_alert('success', 'Email Successfully Sent', 'Approved');
} else {
toast_alert('error', 'Sorry Something Went Wrong');
}
}
}
?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Dashboard
</h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li class="active">Dashboard</li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<!-- Small boxes (Stat box) -->
<div class="row">
<div class="col-lg-3 col-xs-6">
<!-- small box -->
<div class="small-box bg-aqua">
<div class="inner">
<?php
$sql = "SELECT SUM(balance) FROM users";
$stmt = $conn->prepare($sql);
$stmt->execute();
$total = $stmt->fetch(PDO::FETCH_NUM);
$sum = $total[0];
?>
<h3><?= $sum ?></h3>
<p>Total Balance</p>
</div>
<div class="icon">
<i class="ion ion-bag"></i>
</div>
<a href="#" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
<div class="col-lg-3 col-xs-6">
<!-- small box -->
<div class="small-box bg-yellow">
<div class="inner">
<?php
$stmt = $conn->query("SELECT * FROM users");
?>
<h3><?= $stmt->rowCount()?></h3>
<p>User Registrations</p>
</div>
<div class="icon">
<i class="ion ion-person-add"></i>
</div>
<a href="./users.php" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
<div class="col-lg-3 col-xs-6">
<!-- small box -->
<div class="small-box bg-green">
<div class="inner">
<?php
$stmt = $conn->query("SELECT * FROM nfts");
?>
<h3><?= $stmt->rowCount()?></h3>
<p>Total Nfts</p>
</div>
<div class="icon">
<i class="ion ion-stats-bars"></i>
</div>
<a href="./nfts.php" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
<div class="col-lg-3 col-xs-6">
<!-- small box -->
<div class="small-box bg-red">
<div class="inner">
<?php
$stmt = $conn->query("SELECT * FROM wallet");
?>
<h3><?= $stmt->rowCount()?></h3>
<p>Total Transactions</p>
</div>
<div class="icon">
<i class="ion ion-pie-graph"></i>
</div>
<a href="./transactions.php" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
</div>
<!-- /.row -->
<!-- Main row -->
<div class="row">
<!-- Left col -->
<section class="col-lg-7 connectedSortable">
<!-- Custom tabs (Charts with tabs)-->
<!-- quick email widget -->
<div class="box box-info">
<div class="box-header">
<i class="fa fa-envelope"></i>
<h3 class="box-title">Quick Email</h3>
<!-- tools box -->
<div class="pull-right box-tools">
<!--<button type="button" class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip"-->
<!-- title="Remove">-->
<!-- <i class="fa fa-times"></i></button>-->
</div>
<!-- /. tools -->
</div>
<form method="post">
<div class="box-body">
<div class="form-group">
<select name="username" class="form-control select2" style="width: 100%;" required>
<option selected="selected">Select User Email</option>
<?php
$sql="select * from users order by id ASC";
$stmt = $conn->prepare($sql);
$stmt->execute();
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
?>
<option value="<?=$row['id']?>"><?= $row['acct_email'] ?></option>
<?php
}
?>
</select>
</div>
<div class="form-group">
<input type="text" class="form-control" name="subjectid" placeholder="Subject">
</div>
<div>
<textarea class="textarea" placeholder="Message" name="messageid"
style="width: 100%; height: 125px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
</div>
<div class="box-footer clearfix">
<button type="submit" class="pull-right btn btn-default" name="newsletter">Send
<i class="fa fa-arrow-circle-right"></i></button>
</div>
</form>
</div>
</section>
<!-- /.Left col -->
<!-- right col (We are only adding the ID to make the widgets sortable)-->
<section class="col-lg-5 connectedSortable">
<!-- Map box -->
<div class="box box-solid bg-light-blue-gradient">
<div class="box-header">
<!-- tools box -->
<div class="pull-right box-tools">
<button type="button" class="btn btn-primary btn-sm daterange pull-right"
data-toggle="tooltip" title="Date range">
<i class="fa fa-calendar"></i></button>
<button type="button" class="btn btn-primary btn-sm pull-right" data-widget="collapse"
data-toggle="tooltip" title="Collapse" style="margin-right: 5px;">
<i class="fa fa-minus"></i></button>
</div>
<!-- /. tools -->
<i class="fa fa-map-marker"></i>
<h3 class="box-title">
Visitors
</h3>
</div>
<div class="box-body">
<div id="world-map" style="height: 250px; width: 100%;"></div>
</div>
<!-- /.box-body-->
<div class="box-footer no-border">
<div class="row">
<div class="col-xs-4 text-center" style="border-right: 1px solid #f4f4f4">
<div id="sparkline-1"></div>
<div class="knob-label">Visitors</div>
</div>
<!-- ./col -->
<div class="col-xs-4 text-center" style="border-right: 1px solid #f4f4f4">
<div id="sparkline-2"></div>
<div class="knob-label">Online</div>
</div>
<!-- ./col -->
<div class="col-xs-4 text-center">
<div id="sparkline-3"></div>
<div class="knob-label">Exists</div>
</div>
<!-- ./col -->
</div>
<!-- /.row -->
</div>
</div>
<!-- /.box -->
</section>
<!-- right col -->
</div>
<!-- /.row (main row) -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<?php
include($_SERVER['DOCUMENT_ROOT']."/admin/layout/footer.php");
?>
Back to Directory
File Manager
<