Advertisement
Guest User

Untitled

a guest
Apr 1st, 2017
563
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.82 KB | None | 0 0
  1. <table class="table table-hover table-bordered">
  2. <tr>
  3. <th class="well" style="text-align:center">ID</th>
  4. <th class="well" style="text-align:center">Email</th>
  5. <th class="well" style="text-align:center">User level</th>
  6. </tr>';
  7.  
  8. <?
  9. $code_sql = "SELECT user_id, user_email,user_level FROM users ORDER BY user_id ASC ";
  10. $code_query = mysql_query($code_sql) or die(error_sql(mysql_error(),__LINE__,__FILE__));
  11. $sql_rows = mysql_num_rows($code_query);
  12. if($sql_rows > 0){
  13. while($rows = mysql_fetch_object($code_query)){
  14. $user_id = intval($rows->user_id);
  15. $user_level= intval($rows->user_level);
  16. $user_email = htmlspecialchars($rows->user_email);
  17. echo ' <tr>
  18. <td>'.$user_id.'</td>
  19. <td>'.$user_email.'</td>
  20. <td>'.$user_level.'</td>
  21. </tr>';
  22. }
  23. mysql_free_result($code_query);
  24. }else{
  25. echo '<tr>
  26. <td>
  27. <font color="red">no data found</font>
  28. </td>
  29. </tr>';
  30. }
  31. echo '</table>';
  32. ?>
  33.  
  34. <table class="table table-hover table-bordered">
  35. <tr>
  36. <th class="well" style="text-align:center">ID</th>
  37. <th class="well" style="text-align:center">Email</th>
  38. <th class="well" style="text-align:center">User level</th>
  39. </tr>
  40. <tr>
  41. <td>1</td>
  42. <td>test1@gmail.com</td>
  43. <td>1</td>
  44. </tr>
  45. <tr>
  46. <td>2</td>
  47. <td>test2@gmail.com</td>
  48. <td>2</td>
  49. </tr>
  50. <tr>
  51. <td>3</td>
  52. <td>test3@gmail.com</td>
  53. <td>2</td>
  54. </tr>
  55. <tr>
  56. <td>4</td>
  57. <td>test4@gmail.com</td>
  58. <td>1</td>
  59. </tr>
  60. </table>
  61.  
  62. <table class="table table-hover table-bordered">
  63. <tr>
  64. <th class="well" style="text-align:center">ID</th>
  65. <th class="well" style="text-align:center">Email</th>
  66. <th class="well" style="text-align:center">User level</th>
  67. </tr>
  68. <div id="users">
  69. <tr>
  70. <td>1</td>
  71. <td>test1@gmail.com</td>
  72. <td>1</td>
  73. </tr>
  74. <tr>
  75. <td>4</td>
  76. <td>test4@gmail.com</td>
  77. <td>1</td>
  78. </tr>
  79. </div>
  80. <div id="admins">
  81. <tr>
  82. <td>2</td>
  83. <td>test2@gmail.com</td>
  84. <td>2</td>
  85. </tr>
  86. <tr>
  87. <td>3</td>
  88. <td>test3@gmail.com</td>
  89. <td>2</td>
  90. </tr>
  91. </div>
  92. </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement