';
}
else
{
//save user
$email_ori=$_POST['email'];
$email_small_letter=strtolower($email_ori);
$insert_project="INSERT INTO user (user_id,first_name,last_name,gender,picture,email,password,access_level,created,status)
VALUES
(0,'".$_POST['first_name']."','".$_POST['last_name']."','0','','$email_small_letter','$password_final','".$_POST['access']."','$time','1')";
$run_project=mysqli_query($con,$insert_project);
//email part
$to = $_POST['email'];
$subject = "Wespack";
$txt = "Your login details.
\r\nWelcome to Wespack Web Portal, you have been successfully registered.
\r\nUsername: ".$_POST['email']."
\r\nPassword: ".$p."
\r\nPlease login at: http://www.wespack.com.my/admin
\r\nIf you have any inquiries, please email: info@wespack.com.my
";
$headers = "From: info@wespack.com.my";
mail($to,$subject,$txt,$headers);
//end email part
echo '
User successfuly created.
';
}
}
else if(isset($_POST['delete2']) && $_POST['delete2']!="")
{
$pid=$_POST['delete2'];
$update_project="DELETE FROM user WHERE user_id='$pid'";
$run_update_project=mysqli_query($con,$update_project);
$update_project2="DELETE FROM setting WHERE user_id='$pid'";
$run_update_project2=mysqli_query($con,$update_project2);
$update_project3="DELETE FROM img WHERE user_id='$pid'";
$run_update_project3=mysqli_query($con,$update_project3);
echo '
User successfuly deleted.
';
}
else if(isset($_POST['update']) && $_POST['update']!="") // update project
{
$pid=$_POST['update'];
$new_password=$_POST['password'];
if($new_password==""){
$update_project="UPDATE user SET first_name='".$_POST['first_name2']."', last_name='".$_POST['last_name']."',access_level='".$_POST['access']."' ,email='".$_POST['email']."' WHERE user_id='$pid'";
$run_update_project=mysqli_query($con,$update_project);
}
else{
$new_password2=md5($new_password);
$update_project="UPDATE user SET first_name='".$_POST['first_name2']."', last_name='".$_POST['last_name']."',access_level='".$_POST['access']."' ,email='".$_POST['email']."', password='$new_password2' WHERE user_id='$pid'";
$run_update_project=mysqli_query($con,$update_project);
//email part
$to = $_POST['email'];
$subject = "Wespack";
$txt = "Your login details.
\r\nAn Admin just update your login details
\r\nYour login details:
\r\nLogin Details Username: ".$_POST['email']."
\r\nPassword: ".$new_password."
\r\nPlease login at: http://www.wespack.com.my/admin
\r\nIf you have any inquiries, please email: info@wespack.com.my
";
$headers = "From: info@wespack.com.my";
mail($to,$subject,$txt,$headers);
//end email part
}
echo '
User successfuly updated.
';
}
else if(isset($_POST['project_id_status']) && $_POST['project_id_status']!="")
{
$s_value=$_POST['stats'];
$pid=$_POST['project_id_status'];
$update_post="UPDATE user SET status='$s_value' WHERE user_id='$pid'";
$run_project=mysqli_query($con,$update_post);
}
else
{}
?>