delete_role.php 778 B

1234567891011121314151617181920
  1. <?php
  2. include($_SERVER['DOCUMENT_ROOT'] . "/Authorization/script/php/permission/check_right.php");
  3. include('../permission/connect_sql.php');
  4. if (isset($_POST['UserID']) && $_POST['GroupID']) {
  5. $UserID = $_POST['UserID'];
  6. $GroupID = $_POST['GroupID'];
  7. $sql = "DELETE FROM [UserGroup] WHERE [UserID] = ? AND [GroupID] = ?";
  8. $stmt = sqlsrv_query($conn, $sql, array($UserID, $GroupID));
  9. if ($stmt === false) {
  10. if (($errors = sqlsrv_errors()) != null) {
  11. foreach ($errors as $error) {
  12. echo "SQLSTATE: " . $error['SQLSTATE'] . "<br />";
  13. echo "code: " . $error['code'] . "<br />";
  14. echo "message: " . $error['message'] . "<br />";
  15. }
  16. }
  17. }else{
  18. echo('success');
  19. }
  20. }