Monday 9 January 2017

Make the Dashboard Using Mysql

<body>
<table border="1">

<?php

if(isset($_SESSION["useremail"])){
$unm = $_SESSION["useremail"];
$qr = "select * from submit where email = '$unm' ";
$rs = mysql_query($qr);
$num = mysql_num_rows($rs);


?>
        <tr>
        <td>Name</td>
        <td>Surname</td>
        <td>Email id</td>
        <td>password</td>
        <td>Gender</td>
        <td>Phone</td>
        <td>Address</td>
        <td>File</td>
        <td>agree</td>
        <td>delete</td>
        <td>Logout</td>
        <td>Update</td>
     
        </tr>
        <?php
if ($num > 0){
while ($row = mysql_fetch_array($rs)){ ?>

                <tr>
                <td><?php echo $row["name"]; ?></td>
                <td><?php echo $row["surname"]; ?></td>
                <td><?php echo $row["email"]; ?></td>
                <td><?php echo $row["password"]; ?></td>
                <td><?php echo $row["gender"]; ?></td>
                <td><?php echo $row["phone"]; ?></td>
                <td><?php echo $row["address"]; ?></td>
                <td><?php echo $row["file"]; ?></td>
                <td><?php echo $row["agree"]; ?></td>
                 <td><a href="dashboard.php?del=<?php echo $row['id'];?>">delete</a></td>
                 <td><a href="dashboard.php?logout=0">Logout</a></td>
                 <td><a href="dashboard.php?upt=<?php echo $row['id'];?>">update</a></td>
               
                </tr>
               
<?php }} }?>

</table>


       
</body>

No comments:

Post a Comment