<!-- page content -->\n        <div class="col-md-9">\n          <div class="pageContent">\n\n          <form method="post" action="<?php print APP_DOC_ROOT; ?>/user/create">\n            <div class="form-group">\n              <label for="username">Username</label>\n              <input type="text" class="form-control" id="username" name="username" placeholder="Enter username">\n            </div>\n            <div class="form-group">\n              <label for="email">Email</label>\n              <input type="email" class="form-control" id="email" name="email" placeholder="Enter email">\n            </div>\n            <div class="form-group">\n              <label for="firstname">First Name</label>\n              <input type="text" class="form-control" id="firstname" name="firstname" placeholder="Enter first name">\n            </div>\n            <div class="form-group">\n              <label for="lastname">Last Name</label>\n              <input type="text" class="form-control" id="lastname" name="lastname" placeholder="Enter last name">\n            </div>\n            <div class="form-group">\n              <label for="password">Password</label>\n              <input type="password" class="form-control" id="password" name="password" placeholder="Enter password">\n            </div>\n            <div class="checkbox">\n              <label>\n                <input type="checkbox" id="active" name="active" value="true"> Active\n              </label>\n            </div>\n            <div class="checkbox">\n              <label>\n                <input type="checkbox" id="locked" name="locked" value="true"> Locked\n              </label>\n            </div>\n            <button type="submit" id="create" name="create" value="true" class="btn btn-default">\n              <span class="fa fa-check"></span> Create\n            </button>\n          </form>\n\n           </div>\n        </div>\n        <!-- end page content -->$sql = "SELECT
                  a.description,
                  CONCAT(s.first_name, ' ', s.last_name) AS student,
                  CONCAT(i.first_name, ' ', i.last_name) AS instructor,
                  a.due_date,
                  a.submit_date
                FROM
                  assignment a
                JOIN student s    ON a.student = s.id
                JOIN instructor i ON a.instructor = i.id
                ORDER BY
                  a.submit_date";

        $dbObj = new db();
        $dbObj->dbPrepare( $sql );
        $dbObj->dbExecute();

        include( APP_VIEW .'/assignment/assignmentSubNav.php' );
        include( APP_VIEW .'/assignment/listView.php' );
        break;