Welcome Guest, Not a member yet? Register   Sign In
Database access question
#1

(This post was last modified: 07-31-2019, 08:49 AM by ronniebel.)

I'm working through the CodeIgniter tutorial called "News section" at this link.

https://www.codeigniter.com/user_guide/t...ction.html

All is set up, including the database "news" table, but when I load my page - https://spokaneesl.com/news/ - I get a database error.

In my database.php file, I notice that the dbprefix item has this.

'dbprefix' => 'ci_',

When I remove that prefix and just have 

'dbprefix' => '',

then https://spokaneesl.com/news/ is blank. I'm expecting the news items to appear on that page.

Any ideas what I'm doing wrong?

Here's my News_model code. The error says line 12 which is this. -- $query = $this->db->get('news');

<?php
class News_model extends CI_Model {

public function __construct()
{
$this->load->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();
}

}
Reply


Messages In This Thread
Database access question - by ronniebel - 07-31-2019, 08:34 AM
RE: Database access question - by ronniebel - 07-31-2019, 10:10 AM
RE: Database access question - by Wouter60 - 07-31-2019, 11:23 AM



Theme © iAndrew 2016 - Forum software by © MyBB