query("SELECT UserID,Fname,Lname,isactive,ordered FROM user order by UserID ASC");
#Dropdown zusammenbauen
echo "
";
echo "
";
}else{
#Funktion edit_user aufrufen
edit_user();
}
}
#Funtkion für User bearbeitung
function edit_user()
{
if ($_POST['User'] == 0 ){
print "";
}else{
global $con;
#Userid setzen
$userID = $_POST['User'];
#Daten des Users laden
$result= $con->query("SELECT * FROM user where UserID = $userID");
#Tabelle aus array des Users füllen
while($user = mysqli_fetch_array($result))
{
echo '
'.$user["UserID"].'
';
}
echo '
';
}
}
#Funktion user settings speichern
function update()
{
global $con;
$U_UserID = $_POST['U_UserID'];
$U_Fname = $_POST['U_Fname'];
$U_Lname = $_POST['U_Lname'];
$U_Email = $_POST['U_Email'];
$U_isactive = $_POST['U_isactive'];
$U_Username = $_POST['U_Username'];
$U_Password = $_POST['U_Password'];
$U_UserLevel = $_POST['U_UserLevel'];
$U_Ordered = $_POST['U_Ordered'];
#Prüfen ob password eingegeben wurde oder nicht leer ist
if(isset($U_Password) AND !empty($U_Password)){
#Wenn password eingegeben wurde password und andere Daten speichern
$Update_Password = password_hash("$U_Password", PASSWORD_BCRYPT, array('cost' => 10));
$sql = $con->query("UPDATE user SET Fname='{$U_Fname}', Lname='{$U_Lname}', Email='{$U_Email}', isactive='{$U_isactive}', Username='{$U_Username}', Password='{$Update_Password}', UserLevel='{$U_UserLevel}', ordered='{$U_Ordered}' where UserID= $U_UserID");
#Sonst nur ändere werte ändern
}else{
$sql = $con->query("UPDATE user SET Fname='{$U_Fname}', Lname='{$U_Lname}', Email='{$U_Email}', isactive='{$U_isactive}', Username='{$U_Username}', UserLevel='{$U_UserLevel}', ordered='{$U_Ordered}' where UserID= $U_UserID");
}
}
function remove_account()
{
global $con;
$U_UserID = $_POST['U_UserID'];
$result = $con->query("delete from user WHERE UserID='{$U_UserID}';") or die(mysql_error());
}
#Button Überprüfen und Funktion auffrufen
if(isset($_POST['Update'])){
update();
}
if(isset($_POST['Delete'])){
remove_account();
}
if(isset($_POST['Datenschutz'])){
$con->query("update user set privacy_policy = 0");
}
#Header und menü einbinden
$webpagetitle = "Userverwaltung";
include "Includes/Header.php";
include "Includes/Menu.php";
#html Content ausgeben
?>