Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <table class="table table-hover table-bordered">
- <tr>
- <th class="well" style="text-align:center">ID</th>
- <th class="well" style="text-align:center">Email</th>
- <th class="well" style="text-align:center">User level</th>
- </tr>';
- <?
- $code_sql = "SELECT user_id, user_email,user_level FROM users ORDER BY user_id ASC ";
- $code_query = mysql_query($code_sql) or die(error_sql(mysql_error(),__LINE__,__FILE__));
- $sql_rows = mysql_num_rows($code_query);
- if($sql_rows > 0){
- while($rows = mysql_fetch_object($code_query)){
- $user_id = intval($rows->user_id);
- $user_level= intval($rows->user_level);
- $user_email = htmlspecialchars($rows->user_email);
- echo ' <tr>
- <td>'.$user_id.'</td>
- <td>'.$user_email.'</td>
- <td>'.$user_level.'</td>
- </tr>';
- }
- mysql_free_result($code_query);
- }else{
- echo '<tr>
- <td>
- <font color="red">no data found</font>
- </td>
- </tr>';
- }
- echo '</table>';
- ?>
- <table class="table table-hover table-bordered">
- <tr>
- <th class="well" style="text-align:center">ID</th>
- <th class="well" style="text-align:center">Email</th>
- <th class="well" style="text-align:center">User level</th>
- </tr>
- <tr>
- <td>1</td>
- <td>test1@gmail.com</td>
- <td>1</td>
- </tr>
- <tr>
- <td>2</td>
- <td>test2@gmail.com</td>
- <td>2</td>
- </tr>
- <tr>
- <td>3</td>
- <td>test3@gmail.com</td>
- <td>2</td>
- </tr>
- <tr>
- <td>4</td>
- <td>test4@gmail.com</td>
- <td>1</td>
- </tr>
- </table>
- <table class="table table-hover table-bordered">
- <tr>
- <th class="well" style="text-align:center">ID</th>
- <th class="well" style="text-align:center">Email</th>
- <th class="well" style="text-align:center">User level</th>
- </tr>
- <div id="users">
- <tr>
- <td>1</td>
- <td>test1@gmail.com</td>
- <td>1</td>
- </tr>
- <tr>
- <td>4</td>
- <td>test4@gmail.com</td>
- <td>1</td>
- </tr>
- </div>
- <div id="admins">
- <tr>
- <td>2</td>
- <td>test2@gmail.com</td>
- <td>2</td>
- </tr>
- <tr>
- <td>3</td>
- <td>test3@gmail.com</td>
- <td>2</td>
- </tr>
- </div>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement