CODEWITHSUNDEEP
phpmysqlcodeigniter
Jakob Busk Sørensen
Jakob Busk Sørensen

Reputation: 6091

How to handle result objects from MySQL

I am trying to get some relational database handling to work, using PHP and MySQL. To combine output from two different tables, I found some help here on stackoverflow. On of the suggestions was to combine the output in one result object (as I understand it), so the code looks like this:

// Function to read all projects from database
public function get_projects() {
    $query = "SELECT pt.*, at.* FROM ed_projects as pt, ed_project_address as at WHERE pt.project_id = at.project_id";
    $db_result = $this->db->query($query);
    $result_object = $db_result->result();
    return $result_object;
}

Where ed_project is the name of the main table, and ed_project_address is the subtable (or whatever it is called), which contains streetname, postal code, city, etc. for each project. The address properties are linked to projects by a project_id.

I can get this to work on the "reading from the database" part, but when I try to use it, I get an error: "Fatal error: Cannot use object of type stdClass as array in (...)". As I am using CodeIgniter, it is passed through 2 additional steps:

Project View Controller:

/* index() - Project view controller
 * Handles the showing of the project main page, that is the list of all
 * projects found in the database. See also views/projects/index.php.
 */
public function index() {
    $data['projects'] = $this->project_model->get_projects();
    $data['title'] = 'Ejendomme';
    $this->load->view('templates/header', $data);
    $this->load->view('projects/index', $data);
    $this->load->view('templates/footer');
}

Project View:

<?php foreach ($projects as $projects_item): ?>

    <h2><?php echo $projects_item['pt.projects']->project_name ?></h2>
    <div class="main"><?php echo $projects_item['at.address_street'] ?></div>

<?php endforeach ?>

The error is in Project View (index.php) on line 3. I have been reading quite a bit on objects in PHP, but the addition of the CodeIgniter framework seems to obscure things just enough for me to not get it :-(. Am I way off here? Or am I just missing the very last bit?

Upvotes: 0

Views: 407

Answers (1)

Shaiful Islam
Shaiful Islam

Reputation: 7134

you just made mistake at your model you returns the object 

return $result_object;

but you using it as array at view. you should use it like this

  $projects_item->project_name

If you want to use it as array at your view you should return data from model like this 

$result_object = $db_result->result_array();

Also your query will produce error if your both table has same column name. In that case you have to specify which column form which table you want to select.

Upvotes: 1

Related Questions