Blog

Archive for the MVC Category

Post to a MySQL Database Using a jQuery AJAX Form with CodeIgniter
Posted on July 10, 2015 in AJAX, CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model Example

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Quote extends CI_Model
{

    public function all()
    {
        return $this->db->query("SELECT * FROM quotes")->result_array();
    }

    public function create($new_quote)
    {
        $query = "INSERT INTO quotes (author, quote) VALUES (?, ?)";

        $values = array($new_quote['author'], $new_quote['quote']);

        return $this->db->query($query, $values);
    }

}

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Quote extends CI_Model

{

public function all()

{

return $this->db->query("SELECT * FROM quotes")->result_array();

}

public function create($new_quote)

{

$query = "INSERT INTO quotes (author, quote) VALUES (?, ?)";

$values = array($new_quote['author'], $new_quote['quote']);

return $this->db->query($query, $values);

}

Controller Example

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Quotes extends CI_Controller {

    public function index_json()
    {
        $this->load->model('Quote');
        $data['quotes'] = $this->Quote->all();
        echo json_encode($data);
    }

    public function index_html()
    {
        $this->load->model('Quote');
        $data['quotes'] = $this->Quote->all();
        $this->load->view('partials/quotes', $data);
    }

    public function create()
    {
        $this->load->model('Quote');

        $new_quote = $this->input->post();
        $this->Quote->create($new_quote);
        redirect(base_url());
    }

    public function index()
    {
        $this->load->view('index');
    }
}

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Quotes extends CI_Controller {

public function index_json()

{

$this->load->model('Quote');

$data['quotes'] = $this->Quote->all();

echo json_encode($data);

}

public function index_html()

{

$this->load->model('Quote');

$data['quotes'] = $this->Quote->all();

$this->load->view('partials/quotes', $data);

}

public function create()

{

$this->load->model('Quote');

$new_quote = $this->input->post();

$this->Quote->create($new_quote);

redirect(base_url());

}

public function index()

{

$this->load->view('index');

}

jQuery AJAX to Read from and Insert into a MySQL Database

$(function() {
    // Get an HTML string to dump into the
    // #quotes DIV later
    $.get('/quotes/index_html', function(result) {

        $('#quotes').html(result);

    });

    // Submit form, add new quote and author into DB,
    // & add show new DB row without reloading page
    $('#add-quote').on('submit', function() {


        $.post('/quotes/create', $(this).serialize(), function(result) {

        });

    });

    // Prevents double-form submission
    // by removing all event handlers from
    // form#add-quote after the form is submitted
    $('#add-quote').off();

});

$(function() {

// Get an HTML string to dump into the

// #quotes DIV later

$.get('/quotes/index_html', function(result) {

$('#quotes').html(result);

});

// Submit form, add new quote and author into DB,

// & add show new DB row without reloading page

$('#add-quote').on('submit', function() {

$.post('/quotes/create', $(this).serialize(), function(result) {

});

// Prevents double-form submission

// by removing all event handlers from

// form#add-quote after the form is submitted

$('#add-quote').off();

});

View that Shows PHP and HTML for the
Read more…

Delete a Database Row using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

<?php
class UserDashboardModel extends CI_Model
{

    // After admin is logged in
    // delete user
    public function delete_user($product_id)
    {

        $this->db->query("DELETE FROM users WHERE id = $product_id");
        
    }

}
?>

<?php

class UserDashboardModel extends CI_Model

{

// After admin is logged in

// delete user

public function delete_user($product_id)

{

$this->db->query("DELETE FROM users WHERE id = $product_id");

}

Controller

<?php
class UserDashboard extends CI_Controller
{

    public function __construct()
    {
        parent::__construct();

        // Load the UserDashboardModel on all pages
        $this->load->model('UserDashboardModel');

        $this->output->enable_profiler();
    }

    public function deleteuser($user_id)
    {

        $this->UserDashboardModel->delete_user($user_id);

        $this->session->set_flashdata("delete_success", "<p><strong>You have sucessfully deleted a user with the ID of <em>$user_id</em>.</strong></p>");

        redirect(base_url() . 'dashboard/admin');
    }

}
?>

<?php

class UserDashboard extends CI_Controller

{

public function __construct()

{

parent::__construct();

// Load the UserDashboardModel on all pages

$this->load->model('UserDashboardModel');

$this->output->enable_profiler();

}

public function deleteuser($user_id)

{

$this->UserDashboardModel->delete_user($user_id);

$this->session->set_flashdata("delete_success", "<p><strong>You have sucessfully deleted a user with the ID of <em>$user_id</em>.</strong></p>");

redirect(base_url() . 'dashboard/admin');

}

View

<?php
// If the admin sessin variable DOESN'T exist
// redirect to home page
if(!$this->session->userdata('admin_session'))
{
    redirect(base_url());
}
?>

<?php
echo $this->session->flashdata('delete_success');
?>

<table id="admin-dashboard-table">
    <thead>
    <tr>
        <th>ID</th>
        <th>Name</th>
        <th>Email</th>
        <th>Created At</th>
        <th>User Level</th>
        <th colspan="2">Actions</th>
    </tr>
    </thead>
    <tbody>
    <?php
    foreach(array_reverse($show_users) as $row) {
        $first_last_name = $row['first_name'] . ' ' . $row['last_name'];

        ?>
        <tr>
            <td><?php echo $row['id']; ?></td>
            <td><a href="<?php echo base_url() . 'dashboard/user/' . $row['id']; ?>"><?php echo $row['first_name'] . ' ' . $row['last_name']; ?></a></td>
            <td><?php echo $row['email']; ?></td>
            <td><?php echo $row['created_at']; ?></td>
            <td><?php echo $row['user_level']; ?></td>
            <td class="no-border"><a href="<?php echo base_url() . 'users/edit/' . $row['id']; ?>">edit</a></td>
            <td><a href="<?php echo base_url() . 'dashboard/admin/delete/' . $row['id']; ?>">delete</a></td>
        </tr>
    <?php
    }
    ?>
    </tbody>

</table>

<?php

// If the admin sessin variable DOESN'T exist

// redirect to home page

if(!$this->session->userdata('admin_session'))

{

redirect(base_url());

}

<?php

echo $this->session->flashdata('delete_success');

<thead>

<tr>

<th>Email</th>

<th>Created At</th>

<th>User Level</th>

<th colspan="2">Actions</th>

</tr>

</thead>

<tbody>

<?php

foreach(array_reverse($show_users) as $row) {

$first_last_name = $row['first_name'] . ' ' . $row['last_name'];

<tr>

<td><a href="<?php echo base_url() . 'dashboard/admin/delete/' . $row['id']; ?>">delete</a></td>

</tr>

<?php

}

</tbody>

</table>

Insert a User with Admin Privileges into a Database Using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

<?php
class UserDashboardModel extends CI_Model
{

    // After Admin is logged in insert user
    public function admin_insert_user($post_data)
    {
        $this->db->query("INSERT INTO users (first_name, last_name, email, password, user_level, created_at, updated_at) VALUES (?,?,?,?,?,NOW(),NOW())", array($post_data['first_name'], $post_data['last_name'], $post_data['email'], substr(md5($post_data['password']), 0, -2), $post_data['user_level']));
    }

}
?>

<?php

class UserDashboardModel extends CI_Model

{

// After Admin is logged in insert user

public function admin_insert_user($post_data)

{

$this->db->query("INSERT INTO users (first_name, last_name, email, password, user_level, created_at, updated_at) VALUES (?,?,?,?,?,NOW(),NOW())", array($post_data['first_name'], $post_data['last_name'], $post_data['email'], substr(md5($post_data['password']), 0, -2), $post_data['user_level']));

}

Controller

<?php
class UserDashboard extends CI_Controller
{

    public function __construct()
    {
        parent::__construct();

        // Load the UserDashboardModel on all pages
        $this->load->model('UserDashboardModel');

        $this->output->enable_profiler();
    }

    public function insertuserintodb()
    {

        // Load the form helper
        $this->load->helper('form');

        // Load the form_validation library
        $this->load->library('form_validation');

        // Set form validation rules
        $this->form_validation->set_rules('email', '<strong><em>email</em></strong>', 'required|xss_clean|trim|min_length[5]|max_length[100]|is_unique[users.email]|valid_email');

        $this->form_validation->set_rules('first_name', '<strong><em>first name</em></strong>', 'required|xss_clean|trim|min_length[2]|max_length[100]');

        $this->form_validation->set_rules('last_name', '<strong><em>last name</em></strong>', 'required|xss_clean|trim|min_length[2]|max_length[100]');

        $this->form_validation->set_rules('password', '<strong><em>password</em></strong>', 'required|xss_clean|trim|min_length[6]|max_length[20]');

        $this->form_validation->set_rules('confirm_password', '<strong><em>password confirmation</em></strong>', 'required|xss_clean|trim|matches[password]');

        // If there are form validation errors
        if($this->form_validation->run() == FALSE)
        {

            // Set registration errors as a
            // flash data variable
            $this->session->set_flashdata('admin_user_add_errors', validation_errors());


            redirect(base_url() . 'users/new');
        }
        else
        {
            // Set form post first_name and last_name
            // as variables
            $first_name_post = $this->input->post('first_name', TRUE);
            $last_name_post = $this->input->post('last_name');

            // Set registration success message
            // as flash data
            $this->session->set_flashdata("admin_user_add_success", "<p><strong>$first_name_post $last_name_post has been added to the database!</strong></p>");

            // Run model to insert form fields into
            // database
            $this->UserDashboardModel->admin_insert_user($this->input->post(NULL, TRUE));

            redirect(base_url() . 'users/new');

        }

    }

}
?>

<?php

class UserDashboard extends CI_Controller

{

public function __construct()

{

parent::__construct();

// Load the UserDashboardModel on all pages

$this->load->model('UserDashboardModel');

$this->output->enable_profiler();

}

public function insertuserintodb()

{

// Load the form helper

$this->load->helper('form');

// Load the form_validation library

$this->load->library('form_validation');

// Set form validation rules

$this->form_validation->set_rules('first_name', '<strong><em>first name</em></strong>', 'required|xss_clean|trim|min_length[2]|max_length[100]');

$this->form_validation->set_rules('last_name', '<strong><em>last name</em></strong>', 'required|xss_clean|trim|min_length[2]|max_length[100]');

$this->form_validation->set_rules('password', '<strong><em>password</em></strong>', 'required|xss_clean|trim|min_length[6]|max_length[20]');

$this->form_validation->set_rules('confirm_password', '<strong><em>password confirmation</em></strong>', 'required|xss_clean|trim|matches[password]');

// If there are form validation errors

if($this->form_validation->run() == FALSE)

{

// Set registration errors as a

// flash data variable

$this->session->set_flashdata('admin_user_add_errors', validation_errors());

redirect(base_url() . 'users/new');

}

else

{

// Set form post first_name and last_name

// as variables

$first_name_post = $this->input->post('first_name', TRUE);

$last_name_post = $this->input->post('last_name');

// Set registration success message

// as flash data

$this->session->set_flashdata("admin_user_add_success", "<p><strong>$first_name_post $last_name_post has been added to the database!</strong></p>");

// Run model to insert form fields into

// database

$this->UserDashboardModel->admin_insert_user($this->input->post(NULL, TRUE));

redirect(base_url() . 'users/new');

}

View

<?php
// If the admin sessin variable DOESN'T exist
// redirect to home page
if(!$this->session->userdata('admin_session'))
{
    redirect(base_url());
}
?>

<div class="success">
    <?php echo $this->session->flashdata('update_success'); ?>
</div>

<form action="<?php echo base_url() . 'users/edit/process/' . $show_single_user['id']; ?>" method="post" class="side-by-side-form">
    <input type="hidden" name="user_details_update"/>
    <p>
        <label for="email">Email:</label><br />
        <input type="text" name="email" value="<?php echo $show_single_user['email']; ?>"/>
    </p>

    <p>
        <label for="first_name">First Name:</label><br />
        <input type="text" name="first_name" value="<?php echo $show_single_user['first_name']; ?>"/>
    </p>

    <p>
        <label for="first_name">Last Name:</label><br />
        <input type="text" name="last_name" value="<?php echo $show_single_user['last_name']; ?>"/>
    </p>

    <p>
        <select name="user_level">
            <?php
            // Assign the user level option
            // tags to display with the "Admin"
            // first ONLY if user record is
            // for an admin
            if($show_single_user['user_level'] == 'admin')
            {
                $first_user_level = 'admin';
                $second_user_level = 'normal';
            }
            else
            {
                $first_user_level = 'normal';
                $second_user_level = 'admin';
            }
            ?>
            <option value="<?php echo  $first_user_level;?>"><?php echo ucfirst($first_user_level); ?></option>
            <option value="<?php echo  $second_user_level;?>"><?php echo ucfirst($second_user_level); ?></option>
        </select>
    </p>

    <p>&nbsp;</p>
    <p>
        <input type="submit" value="Update"/>
    </p>
</form>

<?php

// If the admin sessin variable DOESN'T exist

// redirect to home page

if(!$this->session->userdata('admin_session'))

{

redirect(base_url());

}

<?php echo $this->session->flashdata('update_success'); ?>

</div>

<form action="<?php echo base_url() . 'users/edit/process/' . $show_single_user['id']; ?>" method="post" class="side-by-side-form">

<p>

<label for="email">Email:</label><br />

</p>

<p>

<label for="first_name">First Name:</label><br />

</p>

<p>

</p>

<p>

<?php

// Assign the user level option

// tags to display with the "Admin"

// first ONLY if user record is

// for an admin

if($show_single_user['user_level'] == 'admin')

{

$first_user_level = 'admin';

$second_user_level = 'normal';

}

else

{

$first_user_level = 'normal';

$second_user_level = 'admin';

}

</select>

</p>

<p>

</p>

</form>

Insert a Submitted User into a Database Using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

<?php
class UserDashboardModel extends CI_Model
{

    // Registration form insert user
    public function insert_user($post_data)
    {

        $this->db->query("INSERT INTO users (first_name, last_name, email, password, user_level, created_at, updated_at) VALUES (?,?,?,?,?,NOW(),NOW())", array($post_data['first_name'], $post_data['last_name'], $post_data['email'], substr(md5($post_data['password']), 0, -2), 'normal'));

    }

}
?>

<?php

class UserDashboardModel extends CI_Model

{

// Registration form insert user

public function insert_user($post_data)

{

}

Controller

<?php
class UserDashboard extends CI_Controller
{

    public function __construct()
    {
        parent::__construct();

        // Load the UserDashboardModel on all pages
        $this->load->model('UserDashboardModel');

        $this->output->enable_profiler();
    }

    // Register a new user with a "user_level" of normal
    // and use a select tag
    public function registernewuser()
    {
        // Load the form helper
        $this->load->helper('form');

        // Load the form_validation library
        $this->load->library('form_validation');

        // Set form validation rules
        $this->form_validation->set_rules('email', '<strong><em>email</em></strong>', 'required|xss_clean|trim|min_length[5]|max_length[100]|is_unique[users.email]|valid_email');

        $this->form_validation->set_rules('first_name', '<strong><em>first name</em></strong>', 'required|xss_clean|trim|min_length[2]|max_length[100]');

        $this->form_validation->set_rules('last_name', '<strong><em>last name</em></strong>', 'required|xss_clean|trim|min_length[2]|max_length[100]');

        $this->form_validation->set_rules('password', '<strong><em>password</em></strong>', 'required|xss_clean|trim|min_length[6]|max_length[20]');

        $this->form_validation->set_rules('confirm_password', '<strong><em>password confirmation</em></strong>', 'required|xss_clean|trim|matches[password]');

        // If there are form validation errors
        if($this->form_validation->run() == FALSE)
        {

            // Set registration errors as a
            // flash data variable
            $this->session->set_flashdata('register_errors', validation_errors());


            redirect(base_url() . 'register');
        }
        else
        {

            // Set form post first_name and last_name
            // as variables
            $first_name_post = $this->input->post('first_name', TRUE);
            $last_name_post = $this->input->post('last_name');

            // Set registration success message
            // as flash data
            $this->session->set_flashdata("register_success", "<p><strong>$first_name_post $last_name_post, thank you for registering!</strong></p>");

            // Run model to insert form fields into
            // database
            $this->UserDashboardModel->insert_user($this->input->post(NULL, TRUE));

            redirect(base_url() . 'register');

        }

    }

}
?>

<?php

class UserDashboard extends CI_Controller

{

public function __construct()

{

parent::__construct();

// Load the UserDashboardModel on all pages

$this->load->model('UserDashboardModel');

$this->output->enable_profiler();

}

// Register a new user with a "user_level" of normal

// and use a select tag

public function registernewuser()

{

// Load the form helper

$this->load->helper('form');

// Load the form_validation library

$this->load->library('form_validation');

// Set form validation rules

$this->form_validation->set_rules('first_name', '<strong><em>first name</em></strong>', 'required|xss_clean|trim|min_length[2]|max_length[100]');

$this->form_validation->set_rules('last_name', '<strong><em>last name</em></strong>', 'required|xss_clean|trim|min_length[2]|max_length[100]');

$this->form_validation->set_rules('password', '<strong><em>password</em></strong>', 'required|xss_clean|trim|min_length[6]|max_length[20]');

$this->form_validation->set_rules('confirm_password', '<strong><em>password confirmation</em></strong>', 'required|xss_clean|trim|matches[password]');

// If there are form validation errors

if($this->form_validation->run() == FALSE)

{

// Set registration errors as a

// flash data variable

$this->session->set_flashdata('register_errors', validation_errors());

redirect(base_url() . 'register');

}

else

{

// Set form post first_name and last_name

// as variables

$first_name_post = $this->input->post('first_name', TRUE);

$last_name_post = $this->input->post('last_name');

// Set registration success message

// as flash data

$this->session->set_flashdata("register_success", "<p><strong>$first_name_post $last_name_post, thank you for registering!</strong></p>");

// Run model to insert form fields into

// database

$this->UserDashboardModel->insert_user($this->input->post(NULL, TRUE));

redirect(base_url() . 'register');

}

View

<?php
// Load the form helper
$this->load->helper('form');
// Load the form_validation library
$this->load->library('form_validation');
?>

<?php
// Display validation errors if they exist
echo $this->session->flashdata('register_errors');
?>

<?php
// Display success message if it exists
echo $this->session->flashdata('register_success');
?>

<form id="signin-register-add" action="<?php echo base_url() . 'register/newuser'; ?>" method="post">
    <input type="hidden" name="register"/>
    <div class="row-fluid">
        <div class="col-md-3"><p><label for="email">Email Address:</label></p></div>
        <div class="col-md-9"><p><input type="text" name="email" value="<?php echo set_value('email'); ?>"/></p></div>
    </div>

    <div class="row-fluid">
        <div class="col-md-3"><p><label for="first_name">First Name:</label></p></div>
        <div class="col-md-9"><p><input type="text" name="first_name" value="<?php echo set_value('first_name'); ?>"/></p></div>
    </div>

    <div class="row-fluid">
        <div class="col-md-3"><p><label for="last_name">Last Name:</label></p></div>
        <div class="col-md-9"><p><input type="text" name="last_name" value="<?php echo set_value('last_name'); ?>"/></p></div>
    </div>

    <div class="row-fluid">
        <div class="col-md-3"><p><label for="password">Password:</label></p></div>
        <div class="col-md-9"><p><input type="password" name="password"/></p></div>
    </div>

    <div class="row-fluid">
        <div class="col-md-3"><p><label for="confirm_password">Confirm Password:</label></p></div>
        <div class="col-md-9"><p><input type="password" name="confirm_password"/></p></div>
    </div>

    <div class="row-fluid">
        <div class="col-md-9 col-md-offset-3"><p><input type="submit" value="Register"/></p></div>
    </div>
</form>

<?php

// Load the form helper

$this->load->helper('form');

// Load the form_validation library

$this->load->library('form_validation');

<?php

// Display validation errors if they exist

echo $this->session->flashdata('register_errors');

<?php

// Display success message if it exists

echo $this->session->flashdata('register_success');

<form id="signin-register-add" action="<?php echo base_url() . 'register/newuser'; ?>" method="post">

<div class="col-md-3"><p><label for="email">Email Address:</label></p></div>

</div>

<div class="col-md-3"><p><label for="first_name">First Name:</label></p></div>

</div>

</div>

<div class="col-md-3"><p><label for="password">Password:</label></p></div>

</div>

<div class="col-md-3"><p><label for="confirm_password">Confirm Password:</label></p></div>

</div>

</div>

</form>

Check a Submitted Email Against a Database Table to Ensure it hasn’t Already Been Added using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

<?php
class UserDashboardModel extends CI_Model
{

    // Check login email against
    // users table in database to
    // ensure it doesn't already exist
    public function check_login_email($submitted_email, $submitted_password)
    {
        return $this->db->query("SELECT * FROM users WHERE (email = ? AND password = ?)", array($submitted_email, $submitted_password))->row_array();
    }

}
?>

<?php

class UserDashboardModel extends CI_Model

{

// Check login email against

// users table in database to

// ensure it doesn't already exist

public function check_login_email($submitted_email, $submitted_password)

{

return $this->db->query("SELECT * FROM users WHERE (email = ? AND password = ?)", array($submitted_email, $submitted_password))->row_array();

}

Controller

<?php
class UserDashboard extends CI_Controller
{

    public function __construct()
    {
        parent::__construct();

        // Load the UserDashboardModel on all pages
        $this->load->model('UserDashboardModel');

        $this->output->enable_profiler();
    }

    // Error validation and redirect to:
    // admin page OR
    // normal user page
    public function checksignin()
    {

        $sec_email = $this->input->post('email', TRUE);
        $password = $this->input->post('password', TRUE);
        $sec_password = substr(md5($password), 0, -2);

        $check_user = $this->UserDashboardModel->check_login_email($sec_email, $sec_password);

        // If user exists in database...
        if($check_user)
        {
            // Set user first/last name as variable
            $hello_user_name = 'Hello, ' . $check_user['first_name'] . ' ' . $check_user['last_name'];

            // If user_level is "admin"
            // go to page and create an "admin_session" variable AND
            // create a session variable with a first AND
            // last name
            if($check_user['user_level'] == 'admin')
            {
                $this->session->set_userdata('admin_session', 'admin_session');

                $this->session->set_userdata('admin_user_name', $hello_user_name);

                redirect(base_url() . 'dashboard/admin');
            }
            // Elseif user_level is "normal"
            // go to page and create an "normal_session" variable AND
            // create a session variable with a first AND
            // last name
            elseif($check_user['user_level'] == 'normal')
            {
                $this->session->set_userdata('normal_session', 'normal_session');

                $this->session->set_userdata('normal_user_name', $hello_user_name);

                redirect(base_url() . 'dashboard');
            }

        }
        else
        {
            // If the user doesn't exist in the database
            // redirect to the sign in page and
            // display the error session variable below
            $this->session->set_userdata('not_in_db_error', '<strong><p>Your email/password are invalid. Please try again.</p></strong>');

            redirect(base_url() . 'signin');
        }
    }

}
?>

<?php

class UserDashboard extends CI_Controller

{

public function __construct()

{

parent::__construct();

// Load the UserDashboardModel on all pages

$this->load->model('UserDashboardModel');

$this->output->enable_profiler();

}

// Error validation and redirect to:

// admin page OR

// normal user page

public function checksignin()

{

$sec_email = $this->input->post('email', TRUE);

$password = $this->input->post('password', TRUE);

$sec_password = substr(md5($password), 0, -2);

$check_user = $this->UserDashboardModel->check_login_email($sec_email, $sec_password);

// If user exists in database...

if($check_user)

{

// Set user first/last name as variable

$hello_user_name = 'Hello, ' . $check_user['first_name'] . ' ' . $check_user['last_name'];

// If user_level is "admin"

// go to page and create an "admin_session" variable AND

// create a session variable with a first AND

// last name

if($check_user['user_level'] == 'admin')

{

$this->session->set_userdata('admin_session', 'admin_session');

$this->session->set_userdata('admin_user_name', $hello_user_name);

redirect(base_url() . 'dashboard/admin');

}

// Elseif user_level is "normal"

// go to page and create an "normal_session" variable AND

// create a session variable with a first AND

// last name

elseif($check_user['user_level'] == 'normal')

{

$this->session->set_userdata('normal_session', 'normal_session');

$this->session->set_userdata('normal_user_name', $hello_user_name);

redirect(base_url() . 'dashboard');

}

else

{

// If the user doesn't exist in the database

// redirect to the sign in page and

// display the error session variable below

$this->session->set_userdata('not_in_db_error', '<strong><p>Your email/password are invalid. Please try again.</p></strong>');

redirect(base_url() . 'signin');

}

View

<?php
// Display user error if it exists
echo $this->session->userdata('not_in_db_error');
$this->session->unset_userdata('not_in_db_error');
?>

<form id="signin-register-add" action="<?php echo base_url() . 'dashboard/checksignin'; ?>" method="post">
    <input type="hidden" name="checksignin"/>

    <div class="row-fluid">
        <div class="col-md-3"><p><label for="email">Email Address:</label></p></div>
        <div class="col-md-9"><p><input type="text" name="email"/></p></div>
    </div>

    <div class="row-fluid">
        <div class="col-md-3"><p><label for="email">Password:</label></p></div>
        <div class="col-md-9"><p><input type="password" name="password"/></p></div>
    </div>

    <div class="row-fluid">
        <div class="col-md-9 col-md-offset-3"><p><input type="submit" value="Sign In"/></p></div>
    </div>
</form>

<?php

// Display user error if it exists

echo $this->session->userdata('not_in_db_error');

$this->session->unset_userdata('not_in_db_error');

<form id="signin-register-add" action="<?php echo base_url() . 'dashboard/checksignin'; ?>" method="post">

<div class="col-md-3"><p><label for="email">Email Address:</label></p></div>

</div>

<div class="col-md-3"><p><label for="email">Password:</label></p></div>

</div>

</div>

</form>

To Top ↑

Blog

Archive for the MVC Category

Post to a MySQL Database Using a jQuery AJAX Form with CodeIgniter
Posted on July 10, 2015 in AJAX, CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model Example

Controller Example

jQuery AJAX to Read from and Insert into a MySQL Database

View that Shows PHP and HTML for the
Read more…

Delete a Database Row using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

Controller

View

Insert a User with Admin Privileges into a Database Using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

Controller

View

Insert a Submitted User into a Database Using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

Controller

View

Check a Submitted Email Against a Database Table to Ensure it hasn’t Already Been Added using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

Controller

View

Search

Categories

Blog

Archive for the MVC Category

Post to a MySQL Database Using a jQuery AJAX Form with CodeIgniter Posted on July 10, 2015 in AJAX, CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model Example

Controller Example

jQuery AJAX to Read from and Insert into a MySQL Database

View that Shows PHP and HTML for the Read more…

Delete a Database Row using CodeIgniter with Model, Controller, and View Code Examples Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

Controller

View

Insert a User with Admin Privileges into a Database Using CodeIgniter with Model, Controller, and View Code Examples Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

Controller

View

Insert a Submitted User into a Database Using CodeIgniter with Model, Controller, and View Code Examples Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

Controller

View

Check a Submitted Email Against a Database Table to Ensure it hasn’t Already Been Added using CodeIgniter with Model, Controller, and View Code Examples Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Model

Controller

View

Search

Categories

Category Search

Post to a MySQL Database Using a jQuery AJAX Form with CodeIgniter
Posted on July 10, 2015 in AJAX, CodeIgniter, MVC, MySQL, PHP by Matt Jennings

View that Shows PHP and HTML for the
Read more…

Delete a Database Row using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Insert a User with Admin Privileges into a Database Using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Insert a Submitted User into a Database Using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings

Check a Submitted Email Against a Database Table to Ensure it hasn’t Already Been Added using CodeIgniter with Model, Controller, and View Code Examples
Posted on July 2, 2015 in CodeIgniter, MVC, MySQL, PHP by Matt Jennings