Professional CodeIgniter, Thomas Myer
Chapter 6: Creating a Dashboard
178
The
deleteProduct()
function looks suspiciously like the
deleteCategory()
function created in the
previous section. And it should, too, as it was basically copied and the table name changed to products .
function deleteProduct($id){
$data = array(`status' =
>
`inactive');
$this-
>
db-
>
where(`id', $id);
$this-
>
db-
>
update(`products', $data);
}
Creating the User Management Tools
Creating the User management tools will take the very same paths you took in creating Product and
Category management tools. In fact, you should be able to copy and paste your controllers, models, and
views, and with judicious name changing, create a basic framework in just a few minutes.
In fact, you already know a lot of what you ' ll need in your model right now, so you might as well build
it out before you get started. For example, you know that you ' ll need a way to retrieve one and all users.
You also need a way to add, update, and delete/deactivate a user.
Here ' s the complete MAdmins model (remembering that you created the
verifyUser()
function
previously in the chapter). At this stage of the game, nothing in this model should be a surprise to you,
as the functions are all the standard ones for retrieving, adding, and updating database records.
as the functions are all the standard ones for retrieving, adding, and updating database records.
<
?php
class MAdmins extends Model{
function MAdmins(){
parent::Model();
}
function verifyUser($u,$pw){
$this-
>
db-
>
select(`id,username');
$this-
>
db-
>
where(`username',$u);
$this-
>
db-
>
where(`password', $pw);
$this-
>
db-
>
where(`status', `active');
$this-
>
db-
>
limit(1);
$Q = $this-
>
db-
>
get(`admins');
if ($Q-
>
num_rows()
>
0){
$row = $Q-
>
row_array();
$_SESSION[`userid'] = $row[`id'];
$_SESSION[`username'] = $row[`username'];
}else{
$this-
>
session-
>
set_flashdata(`error', `Sorry, your username or password is
incorrect!');
}
}
function getUser($id){
$data = array();
$options = array(`id' =
>
$id);
c06.indd 178
c06.indd 178
6/10/08 5:36:07 PM
6/10/08 5:36:07 PM