In this fourth and final article covering the creation of a PHP invoicing system, we're going to put together the user management section. In this section we will be able to view all available users and do all the associated things like deleting or updating user details. We are also going to be able to add new users.
Three downloadable files are available for this article; you can access them here, here, and here.
Let's start by showing how we are going to list all the users in the database. Create a new PHP document and save it as allusers.php. On this page we are going to display user names and full names.
But before we do anything else, let's create the query that will retrieve all the user details from the database. On the very top of the page add the following code:
<? include "config.php"; $query_users = "SELECT uid, uname, fname,lname FROM users ORDER BY uid DESC"; $result_users = mysql_query($query_users); $num_users = mysql_num_rows($result_users); ?>
As a matter of good coding practice, not to mention security, I have not retrieved the password of the user at this stage. It will be retrieved only when the user wants to view his/her profile, later on.
So let's create a table with the above headers as well as a column with "action" as its header:
For security reasons I've added a condition on when the action column can be displayed. The column should only be shown if the person who is logged in is an administrator. This will prevent non-admin users from changing any important information. If you just want to view or change your details, then you should go to the "User settings link."
Next we will built a dynamic table based on the results from the query: