get_where in codeigniter - Stack Of Codes


Thursday, 18 January 2018

get_where in codeigniter

CodeIgniter is a framework based on MVC principles. As a result, you would usually separate application logic, data abstraction and "output" into their respective areas for CodeIgniter use. In this case: controllers, models and views.
Just for reference, you should usually have you "data" code as a model function, in this case the get_where functionality. I highly suggest you read through the provided User Guide to get to grips with CodeIgniter, it should hold your hand through most steps.

function files(){
    $owner = $this->auth->get_user();
    $data['files'] = $this->db->get_where('files', array('owner =' => '$owner'))->result();
    $this->load->view('name_of_my_view', $data);

And then make sure to use the correct variable in your view:
<?php foreach($files as $row): ?>
    <span><?=$row['name']; ?></span>
<?php endforeach; ?>

No comments:

Post a Comment


PHP (27) CodeIgniter (22) SQL (4) Facebook (3) HTML (3) Blogger (2) Constructor (2) Destructor (2) Google (2) Aadhaar (1) Agent (1) Browser (1) CSS (1) Cakephp (1) Constants (1) How to (1) India (1) Ip address (1) JS (1) Jquery (1) Meta Tags (1) Robots (1) Scraping Data (1) escape_str (1) htaccess (1) iS mobile (1) javascript (1) mysqli (1)