Untitled

<!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>SB Admin 2 - Dashboard</title>

    <!-- Custom fonts for this template-->
    <link href="../vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
    <link href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"
          rel="stylesheet">

    <!-- Custom styles for this template-->
    <link href="../css/sb-admin-2.min.css" rel="stylesheet">

</head>

<body id="page-top">

<!-- Page Wrapper -->
<div id="wrapper">

    <!-- Sidebar -->
    <?php
    include_once "../components/navbars_side.php";
    ?>
    <!-- End of Sidebar -->

    <!-- Content Wrapper -->
    <div id="content-wrapper" class="d-flex flex-column">

        <!-- Main Content -->
        <div id="content">

            <!-- Topbar -->
            <?php
            include_once "../components/navbars_top.php";
            ?>
            <!-- End of Topbar -->

            <!-- Begin Page Content -->
            <div class="container-fluid">

                <!-- Page Heading -->
                <div class="d-sm-flex align-items-center justify-content-between mb-4">
                    <h1 class="h3 mb-0 text-gray-800">Gestão de utilizadores</h1>
                    <a href="#" class="d-none d-sm-inline-block btn btn-sm btn-primary shadow-sm"><i
                                class="fas fa-download fa-sm text-white-50"></i> Generate Report</a>
                </div>

                <!-- Content Row -->
                <div class="row">

                    <div class="col-lg-12">
                        <div class="panel panel-default">
                            <div class="panel-heading">
                                Edição de utilizador
                            </div>
                            <!-- /.panel-heading -->
                            <div class="panel-body">

                                <?php

                                if (isset($_GET["id"])) {
                                    $id_user = $_GET["id"];

                                    // We need the function!
                                    require_once("../connections/connection.php");

                                    // Create a new DB connection
                                    $link = new_db_connection();
                                    /* create a prepared statement */
                                    $stmt = mysqli_stmt_init($link);

                                    $query = "SELECT id_users, email, username, date_creation, active, ref_id_roles, roles_descricao FROM users INNER JOIN roles ON users.ref_id_roles= roles.id_roles WHERE id_users = ?";

                                    if (mysqli_stmt_prepare($stmt, $query)) {

                                        mysqli_stmt_bind_param($stmt, 'i', $id_user);

                                        /* execute the prepared statement */
                                        if (!mysqli_stmt_execute($stmt)){
                                            echo "erro;" . mysqli_stmt_error($stmt);
                                        }

                                        /* bind result variables */

                                        mysqli_stmt_bind_result($stmt, $id_users, $email, $username, $date_creation, $active, $id_role, $role);

                                        /* fetch values */
                                        if (!mysqli_stmt_fetch($stmt)) {
                                            ("Location: users.php");
                                            echo "fuygiygiygiu";
                                        }

                                        /* close statement */
                                        mysqli_stmt_close($stmt);
                                    } else {
                                        echo "Error: " . mysqli_error($link);
                                    }

                                    /* close connection */
                                    mysqli_close($link);


                                } else {
                                    header("Location: users.php");
                                }
                                ?>


                                <form role="form" method="post" action="../scripts/users_update.php">
                                    <input type="hidden" name="id_users" value="<?=$id_users?>">
                                    <div class="form-group">
                                        <label>ID do utilizador</label>
                                        <p class="form-control-static"><?=$id_users?></p>
                                    </div>
                                    <div class="form-group">
                                        <label>Data de criação</label>
                                        <p class="form-control-static"><?=$date_creation?></p>
                                    </div>
                                    <div class="form-group">
                                        <label>Username</label>
                                        <input class="form-control" name="username"
                                               value="<?=$username?>">
                                    </div>
                                    <div class="form-group">
                                        <label>Email</label>
                                        <input class="form-control" name="email" value="<?=$email?>">
                                    </div>
                                    <div class="form-group">
                                        <label>Estado</label>
                                        <div class="checkbox">
                                            <label>
                                                <input type="checkbox" name="active" value="<?=$active?>">Activo
                                            </label>
                                        </div>
                                    </div>

                                    <div class="form-group">
                                        <label>Perfil</label>
                                        <select class="form-control" name="id_roles">
                                            <option value='<?=$id_role?>'><?=$role?></option>
                                        </select>
                                    </div>
                                    <button type="submit" class="btn btn-info">Submeter alterações
                                    </button>
                                </form>

                                <!-- /.table-responsive -->
                            </div>
                            <!-- /.panel-body -->
                        </div>
                        <!-- /.panel -->
                    </div>

                </div>


            </div>
            <!-- /.container-fluid -->

        </div>
        <!-- End of Main Content -->

        <!-- Footer -->
        <footer class="sticky-footer bg-white">
            <div class="container my-auto">
                <div class="copyright text-center my-auto">
                    <span>Copyright &copy; Your Website 2019</span>
                </div>
            </div>
        </footer>
        <!-- End of Footer -->

    </div>
    <!-- End of Content Wrapper -->

</div>
<!-- End of Page Wrapper -->

<!-- Scroll to Top Button-->
<a class="scroll-to-top rounded" href="#page-top">
    <i class="fas fa-angle-up"></i>
</a>


<!-- Bootstrap core JavaScript-->
<script src="../vendor/jquery/jquery.min.js"></script>
<script src="../vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

<!-- Core plugin JavaScript-->
<script src="../vendor/jquery-easing/jquery.easing.min.js"></script>

<!-- Custom scripts for all pages-->
<script src="../js/sb-admin-2.min.js"></script>

<!-- Page level plugins -->
<script src="../vendor/chart.js/Chart.min.js"></script>

<!-- Page level custom scripts -->
<script src="../js/demo/chart-area-demo.js"></script>
<script src="../js/demo/chart-pie-demo.js"></script>

</body>

</html>