Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("config.php");
- $sel_q="select a.login_id,a.username,a.password,b.name,b.gender,b.country from login a inner join userdetails b on a.login_id=b.login_id";
- $res=mysql_query($sel_q);
- $count=mysql_num_rows($res);
- ?>
- <html>
- <body>
- <table>
- <tr>
- <td>Login ID</td>
- <td>User Name</td>
- <td>Password</td>
- <td>Name</td>
- <td>Gender</td>
- <td>Country</td>
- <td>Do Edit</td>
- <td>Do Delete</td>
- </tr>
- <?php
- for($i=0;$i<$count;$i++)
- {
- $array_res=mysql_fetch_row($res);
- $login_id=$array_res[0];
- $username=$array_res[1];
- $password=$array_res[2];
- $name=$array_res[3];
- $gender=$array_res[4];
- $country=$array_res[5];
- ?>
- <tr>
- <td><?php echo $i+1; ?></td>
- <td><?php echo $username; ?></td>
- <td><?php echo $password; ?></td>
- <td><?php echo $name; ?></td>
- <td><?php echo $gender; ?></td>
- <td><?php echo $country; ?></td>
- <td><a href="edit.php?login_id="<?php echo $login_id;?>""> edit</a></td>
- <td><a href="delete.php?login_id=<?php echo $login_id;?>">delete</a></td>
- </tr>
- <?php } ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement