getting an error while fetching page title from database using codeigniter php

Question

Fetching page title from database getting error as

A PHP Error was encountered Severity: Notice Message: Trying to get property of non-object Filename: controllers/digital_marketing.php Line Number: 20

A PHP Error was encountered Severity: Notice Message: Trying to get property of non-object Filename: controllers/digital_marketing.php Line Number: 21

I am having two tables like 1.digital_marketing 2.pagetitle

In the first table i am inserting the data related to digital marketing along with digitalmarketing_name(The table will be in the following format)

digital_id  description   digitalmarketing_name
1           dfhbsdjbfd     digital_marketing

Second Table:(pagetitle)

pagetitle_id  page_title            title
1             digital_marketing     Digital Marketing

In this i am comparing page_title if both the page_titles match then i need to display title name but while comparing that getting an error which i have posted above.

If i am using underscore(_) in the page title it is getting that error if not it is working fine.

Controller:

class Digital_marketing extends CI_Controller {
function __construct()
{ 
    parent::__construct();
    $this->load->model('index_model');
    $this->load->model('digitalmarketing_model');

}
public function index()
{

    $data['records2']=$this->digitalmarketing_model->get_digitalmarketing();
    $pageReult = $this->digitalmarketing_model->getpagetitle($this->uri->segment(1));
    $data['page_title']=$pageReult->title;
    $data['meta_tags']=$pageReult->meta_tags;

    $data['mainpage'] = "digital-marketing";
    $this->load->view('templates/template',$data);
}

Model:

function getpagetitle($id)
{

    $this->db->select('P.*,D.digitalmarketing_name');       
    $this->db->from('pagetitle AS P');      
    $this->db->join('digital_marketing AS D','D.digitalmarketing_name=P.page_title','INNER');
    $this->db->where(array('P.page_title'=>$id));       
    $q=$this->db->get();        
    //var_dump($this->db->last_query());
    //print_r($q->num_rows());
    if($q->num_rows()>0)
      {
    $output = $q->result();

   return $output[0];
        }
    else
    {
    return false;
    }
}

The pagetitle which i have inserted in digital_marketing table it is my controller name.

Have u loaded model ?

Gaurav
– Gaurav

2017-09-21 07:07:41 +00:00
Commented Sep 21, 2017 at 7:07 — Gaurav
– Gaurav, Commented Sep 21, 2017 at 7:07
@Gaurav i have loaded model

user6728960
– user6728960

2017-09-21 07:12:02 +00:00
Commented Sep 21, 2017 at 7:12 — user6728960
– user6728960, Commented Sep 21, 2017 at 7:12
Please post your full controller code.

NikuNj Rathod
– NikuNj Rathod

2017-09-21 07:13:55 +00:00
Commented Sep 21, 2017 at 7:13 — NikuNj Rathod
– NikuNj Rathod, Commented Sep 21, 2017 at 7:13
@NikuNjRathod Uploaded full controller code

user6728960
– user6728960

2017-09-21 07:20:20 +00:00
Commented Sep 21, 2017 at 7:20 — user6728960
– user6728960, Commented Sep 21, 2017 at 7:20

NikuNj Rathod · Accepted Answer · 2017-09-21 09:30:55Z

1

You can change your modal function

Controller.php

    public function index()
        {

            $data['records2']=$this->digitalmarketing_model->get_digitalmarketing();
#echo $this->uri->segment(1); exit;
            $pageReult = $this->digitalmarketing_model->getpagetitle($this->uri->segment(1));
            $data['page_title']=$pageReult->title;
            $data['meta_tags']=$pageReult->meta_tags;

            $data['mainpage'] = "digital-marketing";
            $this->load->view('templates/template',$data);
        }

Modal : digitalmarketing_model.php

function getpagetitle($id) {
    $this->db->select('p.*,d.digitalmarketing_name');
    $this->db->from('digital_marketing AS d');
    $this->db->join('pagetitle as p', 'p.page_title = d.digitalmarketing_name', 'left');
    $this->db->where('p.page_title',$id);
    $query = $this->db->get();
    if ($query->num_rows() > 0) {
        $row = $query->row();
        return $row;
    } else {
        return false;
    }
}

I hope this will helps you.

edited Sep 21, 2017 at 9:30

answered Sep 21, 2017 at 8:04

NikuNj Rathod

1,6381 gold badge19 silver badges29 bronze badges

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

6 Comments

NikuNj Rathod Over a year ago

please post your segments $last = $this->uri->total_segments(); $record_num = $this->uri->segment($last);

user6728960 Over a year ago

Not getting you were i need to post this

NikuNj Rathod Over a year ago

Please add above code in your controller inside action.

user6728960 Over a year ago

I have added next to these line $data['meta_tags']=$pageReult->meta_tags; getting same error

NikuNj Rathod Over a year ago

Please print this in your controller action $this->uri->segment(1)

|

Collectives™ on Stack Overflow

getting an error while fetching page title from database using codeigniter php

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related