function show_users($table) { $user_set = find_all_users($table); $output = "<table id=\"t02\">"; $output .= "<tr>"; $output .= "<th>Username </th>"; $output .= "<th colspan=\"3\">Operations</th>"; $output .= "</tr>"; while ($user = mysqli_fetch_assoc($user_set)) { $output .= "<tr>"; $output .= "<td>{$user["user_name"]}</td>"; $output .= "<td><a href=\"show_user.php?id="; $output .= urlencode($user["id"]); $output .= "\">show</a> </td>"; $output .= "<td><a href=\"edit_user.php?id="; $output .= urlencode($user["id"]); $output .= "\">edit</a> </td>"; $output .= "<td><a href=\"delete_user.php?id="; $output .= urlencode($user["id"]); $output .= "\" onclick=\"return confirm('Are you sure?');\">delete</a> </td>"; $output .= "</tr>"; } $output .= "</table>"; mysqli_free_result($user_set); return $output; }
<?php require_once "../includes/session.php"; require_once "../includes/db_connection.php"; require_once "../includes/functions.php"; ?> <?php confirm_logged_in(); ?> <?php $user_set = find_all_users(); ?> <?php $layout_context = "admin"; include "../includes/layouts/header.php"; ?> <div id="main"> <div id="navigation"> <br /> <a href="admin.php">« Admin Menu</a><br /> </div> <div id="page"> <?php echo message(); ?> <h2>Manage Users</h2> <table width="200%">
<?php //debug.php ini_set('display_errors', 1); error_reporting(E_ALL | E_STRICT); require_once "dbconnection.php"; //read database and get all users; $users_list = find_all_users(); while ($row = mysql_fetch_array($users_list)) { echo $row['display_name'] . "||" . $row['photo_url'] . "||" . $row['seat_id']; echo "<br />"; } //get a user display name, photoURL, profileURL, and SEAT!! //Draw these things ?> <!DOCTYPE html> <!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]--> <!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8"> <![endif]--> <!--[if IE 8]> <html class="no-js lt-ie9"> <![endif]--> <!--[if gt IE 8]><!--> <html class="no-js"> <!--<![endif]--> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <title>Classroom 2.0</title> <meta name="description" content="Who's Who in this Classroom 2.0"> <meta name="viewport" content="width=device-width">