Advertisement
Guest User

Untitled

a guest
Sep 28th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.81 KB | None | 0 0
  1. <?php $page_title = 'manageclients'; ?>
  2. <?php include('header.php');?>
  3. <body class="animsition dashboard page-profile">
  4. <?php include('navbar.php');?>
  5. <?php include('sidebar.php');?>
  6. <!-- Page -->
  7. <div class="page">
  8. <div class="page-content container-fluid">
  9. <!-- Panel Table Add Row -->
  10. <div class="panel">
  11. <header class="panel-heading">
  12. <h3 class="panel-title">Benutzer</h3>
  13. </header>
  14. <div class="panel-body">
  15. <div class="row">
  16. <div class="col-md-6">
  17. <div class="mb-15">
  18. <button id="addToTable" class="btn btn-outline btn-primary" type="button" href="" data-toggle="modal" data-target="#AddUser">
  19. <!-- <a -->
  20. <i class="icon wb-plus" aria-hidden="true"></i> Benutzer Hinzufügen
  21. <!-- </a> -->
  22. </button>
  23.  
  24. <!-- Modal php -->
  25. <?php
  26. if (isset($_POST['AddUsr']))
  27. {
  28. $new_username = $_POST['add_username'];
  29. $new_password = $_POST['add_password'];
  30. $new_vorname = $_POST['add_vorname'];
  31. $new_nachname = $_POST['add_nachname'];
  32. $new_email = $_POST['add_email'];
  33. $new_handy = $_POST['add_handy'];
  34. $new_admin = $_POST['add_admin'];
  35. $HashedPass = hash('sha512', $_POST['add_password']);
  36. {
  37. $SQLCheckUser = $odb -> prepare("SELECT * FROM `Account` WHERE `email` = :email");
  38. $SQLCheckUser -> execute(array(':email' => $_POST['add_email']));
  39. $SQLCheckUser = $SQLCheckUser -> fetchColumn(0);
  40. if ($SQLCheckUser > 0)
  41. {
  42. $show -> showError('Benutzer bereits in der Datenbank');
  43. }
  44. else
  45. {
  46. $SQLAddClient = $odb -> prepare("INSERT INTO `Account` VALUES(NULL, :username, :password, :vorname, :nachname, :email, :handy, :admin)");
  47. $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']));
  48. echo "<meta http-equiv='refresh(10)' content='0'>";
  49. }
  50. }
  51. }
  52. ?>
  53. <!-- Modal -->
  54. <div class="modal fade" id="AddUser" aria-hidden="false" aria-labelledby="AddUserModal"
  55. role="dialog" tabindex="-1">
  56. <div class="modal-dialog modal-simple modal-center">
  57. <form class="modal-content" role="form" action="" method="post">
  58. <div class="modal-header">
  59. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  60. <span aria-hidden="true">×</span>
  61. </button>
  62. <h4 class="modal-title" id="AddUserModal">Benutzer eingeben</h4>
  63. </div>
  64. <div class="modal-body">
  65. <div class="row">
  66. <div class="col-xl-6 form-group">
  67. <input type="text" class="form-control" id="username" name="add_username" placeholder="Username" />
  68. </div>
  69. <div class="col-xl-6 form-group">
  70. <input type="password" class="form-control" id="password" name="add_password" placeholder="Passwort" required="">
  71. </div>
  72. <div class="col-xl-4 form-group">
  73. <input type="text" class="form-control" id="vorname" name="add_vorname" placeholder="Vorname" required="">
  74. </div>
  75. <div class="col-xl-8 form-group">
  76. <input type="text" class="form-control" id="nachname" name="add_nachname" placeholder="Nachname" required="">
  77. </div>
  78. <div class="col-xl-8 form-group">
  79. <input type="text" class="form-control" id="email" name="add_email" placeholder="email" required="">
  80. </div>
  81. <div class="col-xl-4 form-group">
  82. <input type="text" class="form-control" id="handy" name="add_handy" placeholder="TelefonNr." required="">
  83. </div>
  84. <div class="col-xl-12 form-group">
  85. <input type="text" class="form-control" id="admin" name="add_admin" required="">
  86. </div>
  87.  
  88. <div class="col-md-12 float-right">
  89. <button type="submit" name="AddUsr" class="btn btn-primary btn-outline" >Benutzer Hinzufügen</button>
  90. </div>
  91. </div>
  92. </div>
  93. </form>
  94. </div>
  95. </div>
  96. <!-- End Modal -->
  97. </div>
  98. </div>
  99. </div>
  100. <table class="table table-bordered table-hover table-striped" cellspacing="0" id="exampleAddRow">
  101.  
  102. <thead>
  103. <tr>
  104. <th >ID</th>
  105. <th>Username</th>
  106. <th>Vorname</th>
  107. <th>Nachname</th>
  108. <th>Email</th>
  109. <th>TelefonNr</th>
  110. <th>Admin</th>
  111. <th>Aktion</th>
  112. </tr>
  113. </thead>
  114. <tbody>
  115. <!-- <tr class="gradeA"> -->
  116.  
  117. <?php $SQLGetLogs = $odb -> query("SELECT * FROM `Account` ORDER BY `ID`");
  118. while($ArrayInfo = $SQLGetLogs -> fetch(PDO::FETCH_ASSOC))
  119. {
  120. // Assign variables to column values in database
  121. $ID = $ArrayInfo['ID'];
  122. $username = $ArrayInfo['username'];
  123. $vorname = $ArrayInfo['vorname'];
  124. $nachname = $ArrayInfo['nachname'];
  125. $email = $ArrayInfo['email'];
  126. $handy = $ArrayInfo['handy'];
  127. $admin = $ArrayInfo['admin'];
  128.  
  129.  
  130. echo '<tr class="gradeA">
  131. <td>'.$ID.'</td>
  132. <td>'.$username.'</td>
  133. <td>'.$vorname.'</td>
  134. <td>'.$nachname.'</td>
  135. <td>'.$email.'</td>
  136. <td>'.$handy.'</td>
  137. <td>'.$admin.'</td>
  138.  
  139. <td class="actions">
  140. <a href="?UpdateUser=' .$ID. '" class="btn btn-sm btn-icon btn-pure btn-default on-default edit-row"
  141. data-original-title="Bearbeiten" ref="" data-toggle="modal" data-target="#EditUser">
  142. <i class="icon wb-edit" aria-hidden="true"></i></a>
  143.  
  144. <a href="?DeleteID=' .$ID. '" class="btn btn-sm btn-icon btn-pure btn-danger on-default remove-row"
  145. data-toggle="tooltip" data-original-title="Löschen">
  146. <i class="icon wb-trash" aria-hidden="true"></i></a>
  147.  
  148.  
  149.  
  150. <div class="modal fade" id="EditUser" aria-hidden="false" aria-labelledby="EditUserModal"
  151. role="dialog" tabindex="-1">
  152. <div class="modal-dialog modal-simple modal-center">
  153. <form class="modal-content" method="POST" role="form" action="">
  154. <div class="modal-header">
  155. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  156. <span aria-hidden="true">×</span>
  157. </button>
  158. <h4 class="modal-title" id="EditUserModal">Benutzer bearbeiten</h4>
  159. </div>
  160. <div class="modal-body">
  161. <div class="row">
  162. <div class="col-xl-12 form-group">
  163. <p><b>Username</b></p>
  164. <input type="text" class="form-control" name="username" value="'.$username.'">
  165. </div>
  166. <div class="col-xl-4 form-group">
  167. <p><b>Vorname</b></p>
  168. <input type="text" class="form-control" name="vorname" value="'.$vorname.'">
  169. </div>
  170. <div class="col-xl-8 form-group">
  171. <p><b>Nachname</b></p>
  172. <input type="text" class="form-control" name="nachname" value="'.$nachname.'">
  173. </div>
  174. <div class="col-xl-8 form-group">
  175. <p><b>Email</b></p>
  176. <input type="email" class="form-control" name="email" value="'.$email.'">
  177. </div>
  178. <div class="col-xl-4 form-group">
  179. <p><b>TelefonNr.</b></p>
  180. <input type="text" class="form-control" name="handy" value="'.$handy.'">
  181. </div>
  182. <div class="col-xl-12 form-group">
  183. <p><b>Admin</b></p>
  184. <input type="text" class="form-control" name="admin" value="'.$admin.'">
  185. </div>
  186. <div class="col-md-12 float-right">
  187. <button class="btn btn-primary btn-outline" data-dismiss="modal" type="submit">Speichern</button>
  188. </div>
  189. </div>
  190. </div>
  191. </form>
  192. </div>
  193. </div>
  194. </td>
  195. </tr>';
  196. }
  197. if(isset($_POST['UpdateUser']))
  198. {
  199. if($_POST['UpdateUser'])
  200. {
  201. // $stmt = $odb->execute("UPDATE Account SET username = '$username' , vorname = '$vorname', nachname = '$nachname', email = '$email', handy = '$handy', admin = '$admin' WHERE id=? ");
  202. $query = 'UPDATE Account SET
  203. username = :username,
  204. vorname = :vorname,
  205. nachname = :nachname,
  206. email = :email,
  207. handy = :handy,
  208. admin = :admin
  209. WHERE id = :id';
  210.  
  211. $stmt = $pdo->prepare($query);
  212.  
  213. $stmt->execute(array(
  214. ':username' => $username,
  215. ':vorname' => $vorname,
  216. ':nachname' => $nachname,
  217. ':email' => $email,
  218. ':handy' => $handy,
  219. ':admin' => $admin,
  220. ':id' => $id
  221. ));
  222. }
  223. echo "<meta http-equiv='refresh()' content='0'>";
  224. }
  225. if(isset($_GET['DeleteID']))
  226. {
  227. if($_GET['DeleteID'])
  228. {
  229. $stmt = $odb->prepare("DELETE FROM Account WHERE id=? ");
  230. $stmt->execute(array($_GET['DeleteID']));
  231. }
  232. echo "<meta http-equiv='refresh()' content='0'>";
  233. }
  234. ?>
  235. <!-- Modal -->
  236. <!-- End Modal -->
  237. </tr>
  238. </tbody>
  239. </table>
  240. </div>
  241. </div>
  242. <!-- End Panel Table Add Row -->
  243. </div>
  244. </div>
  245. <!-- End Page -->
  246. <?php include('footer.php'); ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement