php_lab/view1.php at master · Muhammadasim225/php_lab · 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
<?php
include "config.php";
 $sql="SELECT * FROM `user`";
// $sopq = "ALTER TABLE `user` ADD `First Name` VARCHAR(200)";
// $sopqq = "UPDATE `user` SET `First Name`='Muhammad' WHERE `Last Name`='jsjjsjsjs'";
$eww=mysqli_query($x,$sql);
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>User Information</title>
    <style>
        body {
            font-family: Arial, sans-serif;
            background-color: #f5f5f5;
            margin: 0;
            padding: 0;
        }

        .container {
            max-width: 950px;
            margin: 20px auto;
            padding: 20px;
            background-color: #fff;
            border-radius: 8px;
            box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
        }

        h1 {
            text-align: center;
            margin-bottom: 20px;
        }

        table {
            width: 100%;
            border-collapse: collapse;
        }

        th, td {
            padding: 7px;
            text-align: left;
            border-bottom: 1px solid #ddd;

        }

        th {
            background-color: #f2f2f2;
        }

        tr:hover {
            background-color: #f9f9f9;
        }

        .btn {
            display: inline-block;
            padding: 8px 20px;
            background-color: #007bff;
            color: #fff;
            text-decoration: none;
            border-radius: 4px;
        }
        .btnn{
            display: inline-block;
            padding: 8px 20px;
            background-color: #6e6e6e;
            color: #fff;
            margin-bottom:10px;
            text-decoration: none;
            border-radius: 4px;

            margin-left:420px;
            margin-bottom:30px;
        }
        .btnn:hover{
            background-color: #6e6e6e;

        }


        .btn:hover {
            background-color: #0056b3;
        }
    </style>
</head>
<body>
    <div class="container">
        <h1>User Information</h1>
        <a href='create.php' class="btnn">Create New</a>
        <table>
            <tr>
                <th>ID</th>
                <th>First Name</th>
                <th>Last Name</th>
                <th>Email</th>
                <th>Password</th>
                <th>Gender</th>
                <th>Edit</th>
                <th>Delete</th>
            </tr>
            <?php
            if(mysqli_num_rows($eww) > 0) {
                while($fff = mysqli_fetch_assoc($eww)) {
                    echo "<tr>";
                    echo "<td>".$fff['id']."</td>";
                    echo "<td>".$fff['First Name']."</td>";
                    echo "<td>".$fff['Last Name']."</td>";
                    echo "<td>".$fff['Email']."</td>";
                    echo "<td>".$fff['Password']."</td>";
                    echo "<td>".$fff['Gender']."</td>";
                    echo "<td><a href='update.php?id=".$fff['id']."' class='btn'>Edit</a></td>";
                    echo "<td><a href='delete.php?id=".$fff['id']."' class='btn'>Delete</a></td>";
                    echo "</tr>";
                }
            } else {
                echo "<tr><td colspan='8'>No data available</td></tr>";
            }
            ?>
        </table>
    </div>
</body>
</html>