phpCRUD/all-user.php at master · mukeshg1/phpCRUD · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<?php

/*
File Name    : all-user.php
File Path    : C:\xampp\htdocs\phpCRUD
Description  : PHP page which displays all the user in a table 'user' of database 'crudphp'
Created date : 04/02/2019
Author       : Mukesh
*/


session_start();
// Create connection
include 'constants.php';
$conn = mysqli_connect(SERVER, USER, PASSWORD, DB);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if (ISSET($_SESSION['user']))
{
$sql = "SELECT * FROM user";
$result = $conn->query($sql);
?>
    <html>
    <head>
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css">
        <link rel="stylesheet" href="stylephp.css">
    </head>
    <body>
    <nav class="navbar navbar-expand-lg navbar-dark bg-dark">
        <a href="userprofile.php" ><img class="logo" src="logo2.png"></a>
        <div class="collapse navbar-collapse" id="navbarNav">
            <ul class="navbar-nav">
                <li class="nav-item active">
                     <a class="nav-link" href="userprofile.php">Home <span class="sr-only">(current)</span></a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="all-user.php">All users</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="all-activity.php">Activities</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" href="logoutuser.php">Logout</a>
                </li>
            </ul>
        </div>
    </nav>
    <table class="table table-hover">
        <thead>
            <tr>
                <th>Id</th>
                <th>First Name</th>
                <th>Last Name</th>
                <th>Email</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
<?php
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "<tr><td>".$row["id"]."</td><td>" . $row["firstname"]. "</td><td>" . $row["lastname"]. "</td><td>".$row["email"]."
        </td><td><input class='btn btn-primary' type='button' value='Update' id='b_Update'>
        <input class='btn btn-secondary' type='button' value='Delete' id='b_Del'></td></tr>";
    }
} else {
    echo "No records to show.";
}
$conn->close();
?>
    </tbody>
    </table>

    <!-- Button trigger modal -->


    <!-- Modal -->
    <div class="modal fade" id="updateModal" role="dialog">
    <div class="modal-dialog">
        <div class="modal-content">
        <div class="modal-header">
            <h5>Update User</h5>
            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
            <span aria-hidden="true">&times;</span>
            </button>
        </div>
        <div class="modal-body">
            <i><div id ="updatemsg"></div></i>
                <div class="form-row">
                    <div class="form-group col-md-6">
                        <input type="text" class="form-control" name="updatefirstname" id="updatefirstname" autocomplete="off" placeholder="First Name*">
                    </div>
                    <div class="form-group col-md-6">
                        <input type="text" class="form-control" name="updatelastname" id="updatelastname" autocomplete="off" placeholder="Last Name*">
                    </div>
                </div>
                <div class="form-group col-md-13">
                    <input type="email" name="updateemail" id="updateemail" class="form-control" autocomplete="off" placeholder="Email*">
                </div>
                <div class="form-row">
                    <div class="form-group col-md-6">
                        <button name="save_btn" id="save_btn" class="btn btn-primary btn-block btn-huge">Save changes</button>
                    </div>
                    <div class="form-group col-md-6">
                        <button type="button" id="close_btn" class="btn btn-secondary btn-block btn-huge" data-dismiss="modal">Close</button>
                    </div>
                </div>
        </div>
    </div>
    </div>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"></script>
    <script language="javascript" type="text/javascript" src="crud.js"></script>
    <script language="javascript" type="text/javascript" src="activity.js"></script>
    </body>
    </html>
<?php }
else{
    include 'index.html';
    echo "<p style='color:white;'>Error: Invalid Session</p>";
}