Database query in CodeIgniter

Question

I have a table named "news" containing the following details: id, title, slug, text

As such, I used the following code to retrieve the whole "news" table from my database.

public function get_news($slug = FALSE)
        {
            if ($slug === FALSE)
            {
                $query = $this->db->get('news');
                return $query->result_array();
            }

            $query = $this->db->get_where('news', array('slug' => $slug));
            return $query->row_array();
        }

Displaying the result

<?php foreach ($news as $news_item): ?>

                <h3><?php echo $news_item['title']; ?></h3>
                <div class="main">
                        <?php echo $news_item['text']; ?>
                </div>
                <p><a href="<?php echo site_url('news/'.$news_item['slug']); ?>">View article</a></p>

        <?php endforeach; ?>

How should I go about to change the code in order to get the query result of "select title, text from news;"?

Evgeny · Accepted Answer · 2016-01-09 10:16:06Z

2

Try this

$query = $this->db->select('title, text,')->from('news')->get();

and with where:

 $query = $this->db->select('title, text,')->from('news')->where('slug', $slug)->get();

answered Jan 9, 2016 at 10:16

Evgeny

4,0192 gold badges24 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

beny lim Over a year ago

Thanks for your help. May I know if I want to perform this query "select title from news where text='me'" does it correspond to the query statement below? $query = $this->db->select('title')->from('news')->where('text', 1)->get();

Evgeny Over a year ago

Yes, but at where('text', 1) why 1? Should be where('text', 'me'). Also please mark my answer as valid.

Collectives™ on Stack Overflow

Database query in CodeIgniter

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related