Chap 10. Script 10.1 - view_users.php
Line 5, 6, and 7 of source code.
$row['last_name'] turns into "view_users.php?sort=ln" in
the source code. I don't understand how the info is obtained other than this is how a query works. view_users.php is where the query is made. Yet, it accessed the users table in the database. Is "view_users.php?sort=ln" the $results showing?
Is the query using the get method to supply the
requested info, since there is no form suggesting it's a
post method?
Also, The error_log says that:
include(includes/footer.html): failed to open stream: No
such file or directory.
I noticed there's no HTML header file that is suppose to
be included in the example file package, yet, the page is
presented in source code.
The URL to access it is clearly .php, so how is it I'm
getting to see the source code?
Please Explain.
###########################################################
<h1>Registered Users</h1><table align="center" cellspacing="0" cellpadding="5" width="75%">
<tr>
<td align="left"><b>Edit</b></td>
<td align="left"><b>Delete</b></td>
<td align="left"><b><a href="view_users.php?sort=ln">Last Name</a></b></td>
<td align="left"><b><a href="view_users.php?sort=fn">First Name</a></b></td>
<td align="left"><b><a href="view_users.php?sort=rd">Date Registered</a></b></td>
</tr>
<tr bgcolor="#ffffff">
<td align="left"><a href="edit_user.php?id=1">Edit</a></td>
<td align="left"><a href="delete_user.php?id=1">Delete</a></td>
<td align="left">Ullman</td>
<td align="left">Larry</td>
<td align="left">February 13, 2014</td>
</tr>
<tr bgcolor="#eeeeee">
<td align="left"><a href="edit_user.php?id=2">Edit</a></td>
<td align="left"><a href="delete_user.php?id=2">Delete</a></td>
<td align="left">Isabella</td>
<td align="left">Zoe</td>
<td align="left">February 13, 2014</td>
</tr>
<tr bgcolor="#ffffff">
<td align="left"><a href="edit_user.php?id=11">Edit</a></td>
<td align="left"><a href="delete_user.php?id=11">Delete</a></td>
<td align="left">Sedaris</td>
<td align="left">David</td>
<td align="left">February 13, 2014</td>
</tr>
<tr bgcolor="#eeeeee">
<td align="left"><a href="edit_user.php?id=10">Edit</a></td>
<td align="left"><a href="delete_user.php?id=10">Delete</a></td>
<td align="left">Nesmith</td>
<td align="left">Mike</td>
<td align="left">February 13, 2014</td>
</tr>
<tr bgcolor="#ffffff">
<td align="left"><a href="edit_user.php?id=9">Edit</a></td>
<td align="left"><a href="delete_user.php?id=9">Delete</a></td>
<td align="left">Dolenz</td>
<td align="left">Micky</td>
<td align="left">February 13, 2014</td>
</tr>
<tr bgcolor="#eeeeee">
<td align="left"><a href="edit_user.php?id=7">Edit</a></td>
<td align="left"><a href="delete_user.php?id=7">Delete</a></td>
<td align="left">Jones</td>
<td align="left">David</td>
<td align="left">February 13, 2014</td>
</tr>
<tr bgcolor="#ffffff">
<td align="left"><a href="edit_user.php?id=6">Edit</a></td>
<td align="left"><a href="delete_user.php?id=6">Delete</a></td>
<td align="left">Starr</td>
<td align="left">Ringo</td>
<td align="left">February 13, 2014</td>
</tr>
<tr bgcolor="#eeeeee">
<td align="left"><a href="edit_user.php?id=5">Edit</a></td>
<td align="left"><a href="delete_user.php?id=5">Delete</a></td>
<td align="left">Harrison</td>
<td align="left">George</td>
<td align="left">February 13, 2014</td>
</tr>
<tr bgcolor="#ffffff">
<td align="left"><a href="edit_user.php?id=4">Edit</a></td>
<td align="left"><a href="delete_user.php?id=4">Delete</a></td>
<td align="left">McCartney</td>
<td align="left">Paul</td>
<td align="left">February 13, 2014</td>
</tr>
<tr bgcolor="#eeeeee">
<td align="left"><a href="edit_user.php?id=26">Edit</a></td>
<td align="left"><a href="delete_user.php?id=26">Delete</a></td>
<td align="left">Simpson</td>
<td align="left">Abe</td>
<td align="left">February 13, 2014</td>
</tr>
</table><br /><p>1 <a href="view_users.php?s=10&p=3&sort=rd">2</a> <a href="view_users.php?s=20&p=3&sort=rd">3</a> <a href="view_users.php?s=10&p=3&sort=rd">Next</a></p>