<?php $field = array("accounts_id", "username", "email"); $where = getwheresearch($field); $total = countquery("SELECT username FROM tbl_accounts"); //primary query $limit = getlimit(10, $_GET['p']); $query = "SELECT * FROM tbl_accounts {$where} {$limit}"; $q = mysql_query($query); $options = getpackagelist(); $pagecount = getpagecount($total, 10); ?> <style> #dataTables-example_filter , #dataTables-example_info , #dataTables-example_wrapper .row { display:none; } </style> <h2>Users</h2> <div class="panel panel-default"> <div class="panel-body"> <div class="row"> <div class="col-md-2"> <div class="panel panel-default"> <div class="panel-body"> <input onclick="window.location='<?php echo "?pages=" . $_GET['pages'] . "&task=add"; ?> ';" type="button" class="btn btn-primary" value="Add New Data"> </div> </div> </div>
<?php $field = array("transnum", "email", "username"); $where = getwheresearch($field); $total = countquery("SELECT id FROM tbl_withdraw_history"); //primary query $limit = getlimit(10, $_GET['p']); $query = "SELECT * FROM tbl_withdraw_history as a LEFT JOIN tbl_accounts as b on a.accounts_id=b.accounts_id {$where} {$limit}"; $q = mysql_query($query); $options = getpackagelist(); $pagecount = getpagecount($total, 10); ?> <style> #dataTables-example_filter , #dataTables-example_info , #dataTables-example_wrapper .row { display:none; } </style> <h2>Payouts</h2> <div class="panel panel-default"> <div class="panel-body"> <div class="row"> <div class="col-md-12"> <div class="panel panel-default"> <div class="panel-body"> Search by: Username,Transact#: <form method=''> <input type='text' value='<?php echo $_GET['search']; ?> ' name='search'> <input type='hidden' name='pages' value='<?php