Errors

Nate L · September 18th, 2008, 02:53 PM

I've followed every step and I am getting errors when I test my code, after page 88.

Code:

A PHP Error was encountered

Severity: Notice

Message: Undefined index: id

Filename: controllers/welcome.php

Line Number: 13
A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `status` = 'active' ORDER BY `category_id` asc LIMIT 100' at line 4

SELECT `id`, `name`, `thumbnail`, `category_id` FROM (`products`) WHERE `id` != AND `status` = 'active' ORDER BY `category_id` asc LIMIT 100

I've checked and double check my code and it is all correct.

-Nate

soreeyes · October 15th, 2008, 04:56 AM

In the finished code I am getting a similar error. If I log in with false name and password, I get the error 'Undefined index: userid'. The alternative code (in madmins.php) should be:

function verifyUser($u,$pw){
        $this->db->select('id,username');
        $this->db->where('username',db_clean($u,16));
        $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
        {
            $_SESSION['userid'] = 0;
            $this->session->set_flashdata('error', 'Sorry, your username or password is incorrect!');
        }
    }[u]</u>

macov · October 20th, 2008, 10:01 PM

Yes, I have the same problem... May be the session was not initialized?