Guest User

Untitled

a guest
May 30th, 2018
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. <?php include "adminheader.php";?>
  2.  
  3. <form action="<? echo $PHP_SELF; ?>" method="GET">
  4. <? include "guestlistSelector.php"; ?>
  5. <input type="submit" value="Go"/>
  6. </form>
  7.  
  8. <?
  9. $host="**********************";
  10. $username="user_logins";
  11. $password="A1@**************";
  12. $db_name="user_logins";
  13. $tbl_name=$_GET['glid'];
  14.  
  15. mysql_connect("$host", "$username", "$password")or die("cannot connect");
  16. mysql_select_db("$db_name")or die("cannot select DB");
  17.  
  18. $sql="SELECT * FROM $tbl_name";
  19. $result=mysql_query($sql);
  20.  
  21. $count=mysql_num_rows($result);
  22.  
  23. echo "<table><tr><td colspan='4'>Guest List for ".$tbl_name."</td></tr>";
  24.  
  25. $i=0;
  26. while ($i < $count) {
  27.  
  28. $gid = mysql_result($result,$i,"uid");
  29. $gname = mysql_result($result,$i,"u_name");
  30. $gphone = mysql_result($result,$i,"u_phone");
  31. $siteu = mysql_result($result,$i,"site_uname");
  32.  
  33. echo "<tr><td>$gid</td><td>$gname</td><td>$gphone</td><td>$siteu</td></tr></table>";
  34.  
  35. $i++;
  36. }
  37.  
  38. ?>
Add Comment
Please, Sign In to add comment