PHP ManageUserDatabase Examples

Example #1

File: list_user.php Project: habibzadeh/php-mailadmin

?>
<div class="container">
    <div class="row">
        <div class="col-md-12">
            <div id="AccountList">
                <table class="EmailList">
                    <thead>
                        <tr>
                            <td>Id</td>
                            <td>Email</td>
                            <td>Access Level</td>
                        </tr>
                    </thead>
                    <tbody>
                        <?php 
if ($conn = new ManageUserDatabase()) {
    $query_result = $conn->MySql->query($conn->GetQueryString('users'));
    if ($query_result) {
        while ($row = $query_result->fetch_row()) {
            echo '<tr>';
            echo '<td>' . $row[0] . '</td>';
            echo '<td>' . $row[1] . '</td>';
            echo '<td>' . $row[2] . '</td>';
            echo '</tr>';
        }
        $query_result->close();
    }
    $conn->Close();
    unset($conn);
} else {
    echo '<tr>';

Example #2

File: delete_user.php Project: habibzadeh/php-mailadmin

$cfgProgDir = '../security/';
include $cfgProgDir . "secure.php";
include 'ManageUserDatabase.php';
require 'EntryCheck.php';
$TITLE = 'Delete User Account.';
include_once INC_PATH . 'header.php';
if (isset($_SERVER['REQUEST_METHOD'])) {
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        $email = $_POST['email'];
        $checks = new EntryCheck();
        if (!$checks->CheckEmail($email)) {
            ?>
            <script>ShowAlert('#FormAlert');</script>
        <?php 
        } else {
            if ($conn = new ManageUserDatabase()) {
                if (($record_id = $conn->CheckForExistingUser($email)) > 0) {
                    ?>
                    <script>
                        if(confirm("Are you sure ?")){
                            <?php 
                    if ($conn->DeleteUser($record_id)) {
                        ?>
                                    ShowAlert('#FormInfo');
                                <?php 
                    } else {
                        ?>
                                    ShowAlert('#DatabaseError');
                                <?php 
                    }
                    ?>

Example #3

File: password_user.php Project: habibzadeh/php-mailadmin

require 'EntryCheck.php';
$TITLE = 'Edit User';
include_once INC_PATH . 'header.php';
if (isset($_SERVER['REQUEST_METHOD'])) {
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        $email = $_POST['email'];
        $password = $_POST['password'];
        $re_password = $_POST['re_password'];
        $level = $_POST['level'];
        $checks = new EntryCheck();
        if (!$checks->CheckEmail($email) || !$checks->CheckForSamePassword($password, $re_password) || !$checks->CheckUserAccessLevel($level)) {
            ?>
            <script>ShowAlert('#FormAlert');</script>
        <?php 
        } else {
            if ($conn = new ManageUserDatabase()) {
                $record_id = $conn->CheckForExistingUser($email);
                if ($record_id > 0) {
                    if ($conn->UpdateUser($record_id, $password, $level)) {
                        ?>
                        <script>ShowAlert('#FormInfo');</script>
                    <?php 
                    } else {
                        ?>
                        <script>ShowAlert('#UnSuccess');</script>
                    <?php 
                    }
                } else {
                    ?>
                    <script>ShowAlert('#NotFound');</script>
                <?php 

Example #4

File: new_user.php Project: habibzadeh/php-mailadmin

require 'EntryCheck.php';
$TITLE = 'New User Account';
include_once INC_PATH . 'header.php';
if (isset($_SERVER['REQUEST_METHOD'])) {
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        $email = $_POST['email'];
        $password = $_POST['password'];
        $re_password = $_POST['re_password'];
        $level = $_POST['level'];
        $checks = new EntryCheck();
        if (!$checks->CheckEmail($email) || !$checks->CheckForSamePassword($password, $re_password) || !$checks->CheckUserAccessLevel($level)) {
            ?>
            <script>ShowAlert('#FormAlert');</script>
            <?php 
        } else {
            if ($conn = new ManageUserDatabase()) {
                if ($conn->CheckForExistingUser($email) > 0) {
                    ?>
                    <script>ShowAlert('#UserExist');</script>
                <?php 
                } else {
                    if ($conn->InsertUser($email, $password, $level)) {
                        ?>
                        <script>ShowAlert('#FormInfo');</script>
                    <?php 
                    } else {
                        ?>
                        <script>ShowAlert('#DatabaseError');</script>
                    <?php 
                    }
                }