Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php $page_title = 'manageclients'; ?>
- <?php include('header.php');?>
- <body class="animsition dashboard page-profile">
- <?php include('navbar.php');?>
- <?php include('sidebar.php');?>
- <!-- Page -->
- <div class="page">
- <div class="page-content container-fluid">
- <!-- Panel Table Add Row -->
- <div class="panel">
- <header class="panel-heading">
- <h3 class="panel-title">Benutzer</h3>
- </header>
- <div class="panel-body">
- <div class="row">
- <div class="col-md-6">
- <div class="mb-15">
- <button id="addToTable" class="btn btn-outline btn-primary" type="button" href="" data-toggle="modal" data-target="#AddUser">
- <!-- <a -->
- <i class="icon wb-plus" aria-hidden="true"></i> Benutzer Hinzufügen
- <!-- </a> -->
- </button>
- <!-- Modal php -->
- <?php
- if (isset($_POST['AddUsr']))
- {
- $new_username = $_POST['add_username'];
- $new_password = $_POST['add_password'];
- $new_vorname = $_POST['add_vorname'];
- $new_nachname = $_POST['add_nachname'];
- $new_email = $_POST['add_email'];
- $new_handy = $_POST['add_handy'];
- $new_admin = $_POST['add_admin'];
- $HashedPass = hash('sha512', $_POST['add_password']);
- {
- $SQLCheckUser = $odb -> prepare("SELECT * FROM `Account` WHERE `email` = :email");
- $SQLCheckUser -> execute(array(':email' => $_POST['add_email']));
- $SQLCheckUser = $SQLCheckUser -> fetchColumn(0);
- if ($SQLCheckUser > 0)
- {
- $show -> showError('Benutzer bereits in der Datenbank');
- }
- else
- {
- $SQLAddClient = $odb -> prepare("INSERT INTO `Account` VALUES(NULL, :username, :password, :vorname, :nachname, :email, :handy, :admin)");
- $SQLAddClient -> execute(array(':username' => $_POST['add_username'], ':password' => $HashedPass, ':vorname' => $_POST['add_vorname'], ':nachname' => $_POST['add_nachname'], ':email' => $_POST['add_email'], ':handy' => $_POST['add_handy'], ':admin' => $_POST['add_admin']));
- echo "<meta http-equiv='refresh(10)' content='0'>";
- }
- }
- }
- ?>
- <!-- Modal -->
- <div class="modal fade" id="AddUser" aria-hidden="false" aria-labelledby="AddUserModal"
- role="dialog" tabindex="-1">
- <div class="modal-dialog modal-simple modal-center">
- <form class="modal-content" role="form" action="" method="post">
- <div class="modal-header">
- <button type="button" class="close" data-dismiss="modal" aria-label="Close">
- <span aria-hidden="true">×</span>
- </button>
- <h4 class="modal-title" id="AddUserModal">Benutzer eingeben</h4>
- </div>
- <div class="modal-body">
- <div class="row">
- <div class="col-xl-6 form-group">
- <input type="text" class="form-control" id="username" name="add_username" placeholder="Username" />
- </div>
- <div class="col-xl-6 form-group">
- <input type="password" class="form-control" id="password" name="add_password" placeholder="Passwort" required="">
- </div>
- <div class="col-xl-4 form-group">
- <input type="text" class="form-control" id="vorname" name="add_vorname" placeholder="Vorname" required="">
- </div>
- <div class="col-xl-8 form-group">
- <input type="text" class="form-control" id="nachname" name="add_nachname" placeholder="Nachname" required="">
- </div>
- <div class="col-xl-8 form-group">
- <input type="text" class="form-control" id="email" name="add_email" placeholder="email" required="">
- </div>
- <div class="col-xl-4 form-group">
- <input type="text" class="form-control" id="handy" name="add_handy" placeholder="TelefonNr." required="">
- </div>
- <div class="col-xl-12 form-group">
- <input type="text" class="form-control" id="admin" name="add_admin" required="">
- </div>
- <div class="col-md-12 float-right">
- <button type="submit" name="AddUsr" class="btn btn-primary btn-outline" >Benutzer Hinzufügen</button>
- </div>
- </div>
- </div>
- </form>
- </div>
- </div>
- <!-- End Modal -->
- </div>
- </div>
- </div>
- <table class="table table-bordered table-hover table-striped" cellspacing="0" id="exampleAddRow">
- <thead>
- <tr>
- <th >ID</th>
- <th>Username</th>
- <th>Vorname</th>
- <th>Nachname</th>
- <th>Email</th>
- <th>TelefonNr</th>
- <th>Admin</th>
- <th>Aktion</th>
- </tr>
- </thead>
- <tbody>
- <!-- <tr class="gradeA"> -->
- <?php $SQLGetLogs = $odb -> query("SELECT * FROM `Account` ORDER BY `ID`");
- while($ArrayInfo = $SQLGetLogs -> fetch(PDO::FETCH_ASSOC))
- {
- // Assign variables to column values in database
- $ID = $ArrayInfo['ID'];
- $username = $ArrayInfo['username'];
- $vorname = $ArrayInfo['vorname'];
- $nachname = $ArrayInfo['nachname'];
- $email = $ArrayInfo['email'];
- $handy = $ArrayInfo['handy'];
- $admin = $ArrayInfo['admin'];
- echo '<tr class="gradeA">
- <td>'.$ID.'</td>
- <td>'.$username.'</td>
- <td>'.$vorname.'</td>
- <td>'.$nachname.'</td>
- <td>'.$email.'</td>
- <td>'.$handy.'</td>
- <td>'.$admin.'</td>
- <td class="actions">
- <a href="?UpdateUser=' .$ID. '" class="btn btn-sm btn-icon btn-pure btn-default on-default edit-row"
- data-original-title="Bearbeiten" ref="" data-toggle="modal" data-target="#EditUser">
- <i class="icon wb-edit" aria-hidden="true"></i></a>
- <a href="?DeleteID=' .$ID. '" class="btn btn-sm btn-icon btn-pure btn-danger on-default remove-row"
- data-toggle="tooltip" data-original-title="Löschen">
- <i class="icon wb-trash" aria-hidden="true"></i></a>
- <div class="modal fade" id="EditUser" aria-hidden="false" aria-labelledby="EditUserModal"
- role="dialog" tabindex="-1">
- <div class="modal-dialog modal-simple modal-center">
- <form class="modal-content" method="POST" role="form" action="">
- <div class="modal-header">
- <button type="button" class="close" data-dismiss="modal" aria-label="Close">
- <span aria-hidden="true">×</span>
- </button>
- <h4 class="modal-title" id="EditUserModal">Benutzer bearbeiten</h4>
- </div>
- <div class="modal-body">
- <div class="row">
- <div class="col-xl-12 form-group">
- <p><b>Username</b></p>
- <input type="text" class="form-control" name="username" value="'.$username.'">
- </div>
- <div class="col-xl-4 form-group">
- <p><b>Vorname</b></p>
- <input type="text" class="form-control" name="vorname" value="'.$vorname.'">
- </div>
- <div class="col-xl-8 form-group">
- <p><b>Nachname</b></p>
- <input type="text" class="form-control" name="nachname" value="'.$nachname.'">
- </div>
- <div class="col-xl-8 form-group">
- <p><b>Email</b></p>
- <input type="email" class="form-control" name="email" value="'.$email.'">
- </div>
- <div class="col-xl-4 form-group">
- <p><b>TelefonNr.</b></p>
- <input type="text" class="form-control" name="handy" value="'.$handy.'">
- </div>
- <div class="col-xl-12 form-group">
- <p><b>Admin</b></p>
- <input type="text" class="form-control" name="admin" value="'.$admin.'">
- </div>
- <div class="col-md-12 float-right">
- <button class="btn btn-primary btn-outline" data-dismiss="modal" type="submit">Speichern</button>
- </div>
- </div>
- </div>
- </form>
- </div>
- </div>
- </td>
- </tr>';
- }
- if(isset($_POST['UpdateUser']))
- {
- if($_POST['UpdateUser'])
- {
- // $stmt = $odb->execute("UPDATE Account SET username = '$username' , vorname = '$vorname', nachname = '$nachname', email = '$email', handy = '$handy', admin = '$admin' WHERE id=? ");
- $query = 'UPDATE Account SET
- username = :username,
- vorname = :vorname,
- nachname = :nachname,
- email = :email,
- handy = :handy,
- admin = :admin
- WHERE id = :id';
- $stmt = $pdo->prepare($query);
- $stmt->execute(array(
- ':username' => $username,
- ':vorname' => $vorname,
- ':nachname' => $nachname,
- ':email' => $email,
- ':handy' => $handy,
- ':admin' => $admin,
- ':id' => $id
- ));
- }
- echo "<meta http-equiv='refresh()' content='0'>";
- }
- if(isset($_GET['DeleteID']))
- {
- if($_GET['DeleteID'])
- {
- $stmt = $odb->prepare("DELETE FROM Account WHERE id=? ");
- $stmt->execute(array($_GET['DeleteID']));
- }
- echo "<meta http-equiv='refresh()' content='0'>";
- }
- ?>
- <!-- Modal -->
- <!-- End Modal -->
- </tr>
- </tbody>
- </table>
- </div>
- </div>
- <!-- End Panel Table Add Row -->
- </div>
- </div>
- <!-- End Page -->
- <?php include('footer.php'); ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement