How to you debug blank pages? - Printable Version

Code:

class Mdl_users extends Model {



    // We will give this model the following properties so they can be set dynamically from the controller

    var $user_id;

    var $username;

    var $password

    var $last_name;

    var $first_name;

    var $phone;

    var $email;

    var $org;

    var $admin;



    function Mdl_users() {



        // All models need to call the constructor of the parent Model class

        parent::Model();



    }



    function get() {



        // BEGIN FILTER CRITERIA CHECK

        // If any of the following properties are set before mdl_users->get() is called from the controller then we will include

        // a where statement for each of the properties that have been set.

        if ($this->user_id) {

            $this->db->where("user_id", $this->user_id);

        }



        if ($this->username) {

            $this->db->where("username", $this->username);

        }



        if ($this->password) {

            $this->db->where("password", $this->password);

        }



        if ($this->last_name) {

            $this->db->where("last_name", $this->last_name);

        }



        if ($this->first_name) {

            $this->db->where("first_name", $this->first_name);

        }



        if ($this->phone) {

            $this->db->where("phone", $this->phone);

        }



        if ($this->email) {

            $this->db->where("email", $this->email);

        }



        if ($this->org) {

            $this->db->where("org", $this->org);

        }



        if ($this->admin) {

            $this->db->where("admin", $this->admin);

        }

        // END FILTER CRITERIA CHECK



        // We will display our results in order by last name and then first name.

        $this->db->orderby("last_name, first_name");



        // This will execute the query and collect the results and other properties of the query into an object.

        $query = $this->db->get("users");



        // If you set users->user_id from your controller, then there will only be one row to return.

        if ($this->user_id) {

            return ($query->row());

        }



        // If mdl_users->users_id was not specified in the controller, then we will return the results as a result set.

        else {

            return ($query->result());

        }



    }



    function save() {



        // When we insert or update a record in CodeIgniter, we pass the results as an array:

        $db_array = array(

        "user_id" => $this->user_id,

        "username" => $this->username,

        "password" => $this->password,

        "last_name" => $this->last_name,

        "first_name" => $this->first_name,

        "phone" => $this->phone,

        "email" => $this->email,

        "org" => $this->org,

        "admin" => $this->admin);



        // If mdl_users->contact_id was set in the controller, then we will update an existing record.

        if ($this->users_id) {

            $this->db->where("users_id", $this->users_id);

            $this->db->update("users", $db_array);

        }



        // If mdl_users->users_id was not set in the controller, then we will insert a new record.

        else {

            $this->db->insert("users", $db_array);

        }



    }



    function delete() {



        // As long as mdl_contacts->contact_id was set in the controller, we will delete the record.

        if ($this->users_id) {

            $this->db->where("users_id", $this->users_id);

            $this->db->delete("users");

        }



    }



}

Code:

&lt;?php

 class User extends Controller {



    function User(){

        parent::Controller();

        $this->load->model("mdl_users");

        $this->load->scaffolding('users');

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

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

    }



    function index(){

        $data['title'    ]     = "Users Summary";

        $data['heading'    ]     = "Listing of all application users:";

        $this->load->database();

        $data['query'] = $this->mdl_users->get();



         [color=red]$this->load->view('all', $data);[/color]

    }

    

    function detail(){

        $data['title'    ]     = "User Detail";

        $data['heading'    ]     = "Edit user attributes:";

        

        $this->load->view('detail', $data);

    }

    

    function search(){

        

    

    

    

}

?&gt;

Code:

&lt;html&gt;

&lt;head&gt;

&lt;title&gt;&lt;?php echo $title ?&gt;&lt;/title&gt;

&lt;/head&gt;

&lt;body&gt;

    <h1>&lt;?php echo $heading ?&gt;</h1>

    

    &lt;form method="POST" action=""&gt;

    <table cellspacing="3" border="0">

    &lt;?php foreach($query->result() as $row): ?&gt;

    <tr bgcolor="yellow" >

    <td>&lt;?php echo $row->username ?&gt;</td>

    <td>&lt;?php echo $row->password ?&gt;</td>

    <td>&lt;?php echo $row->email ?&gt;</td>

    <td>&lt;?php echo $row->org ?&gt;</td>

    <td>&lt;?php echo $row->phone ?&gt;</td>

    <td>&lt;?php echo anchor('user/detail/'.$row->id, 'Edit User Info'); ?&gt;</td>

    </tr>

    &lt;?php endforeach; ?&gt;

    </table>

    &lt;/form&gt;

&lt;/body&gt;

&lt;/html&gt;