echo "<ul>"; while ($user_data = mysqli_fetch_assoc($result)) { $username = $user_data['username']; echo "<li>{$username}</li>"; } echo "</ul>"; $sql2 = "SELECT * FROM users"; $result = $db->query($sql2); echo "Teambook Users in Database:<br />"; echo "<ul>"; while ($user_data2 = $db->fetch_assoc($result)) { $username = $user_data2['username']; echo "<li>{$username}</li>"; } echo "</ul>"; echo "<br />"; echo "<h1>Using the User Class</h1>"; echo "<h2>Using an instance method and object instance:</h2>"; $user = new User(); $found_user = $user->find_by_id(1); echo $found_user['username']; echo "<hr />"; echo "<h2>Using a static/class method - less code</h2>"; $found_user = User::find_by_id_static(1); echo $found_user['username']; echo "<hr />"; echo "<h2>Using a static/class method - find_by_sql method</h2>"; $sql3 = "SELECT * FROM users WHERE userId=2"; $result_set = User::find_by_sql($sql3); $found_user = $db->fetch_assoc($result_set); echo $found_user['username'];