_Luna_/showdata.php at master · DivyeshPuri/_Luna_ · 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
<html>
<head>
    <title> show data of user </title>
</head>
<body>
<?php

$conn = mysqli_connect('localhost','root','','eventmanage');
$sql = "SELECT * FROM registration";

$run = mysqli_query($conn,$sql);
?>

<table bgcolor="#CACFD2" width="80%" border="2" align="center">
    <tr>
        <th> id </th>
        <th> name </th>
        <th> address </th>
        <th> mobile no </th>
        <th> email </th>
        <th> college </th>
        <th> date </th>
    </tr>
    <?php
    while($user = mysqli_fetch_array($run,MYSQLI_ASSOC))
    {
        echo "<tr>";
        echo  "<td>".$user['id']."</td>";
        echo  "<td>".$user['name']."</td>";
        echo  "<td>".$user['address']."</td>";
        echo  "<td>".$user['mobile_no']."</td>";
        echo  "<td>".$user['email']."</td>";
        //echo  "<td>".$user['password']."</td>";
        echo  "<td>".$user['college']."</td>";
        echo  "<td>".$user['date']."</td>";
    }

    ?>

</table>
</body>
</html>

<?php

//var_dump($run);
?>