Edit Pages

I update it into something else:

models/Mpages.php

PHP Code:

public function add_settings()
 {
 
 $data = array(
 'email' => $this->input->post('email'),
 'site_name' => $this->input->post('sitename'),
 'meta_title' => $this->input->post('title'),
 'meta_keyword' => $this->input->post('keyword'),
 'meta_description' => $this->input->post('description'),
 'facebook' => $this->input->post('facebook'),
 'twitter' => $this->input->post('twitter'),
 'rss' => $this->input->post('rss') 
 );
 
 $query = $this->db->update('setting', $data);
 return $query->result_array();
 
 
 } 


There is a new error that I do not know how to fix it:

Fatal error: Call to a member function result_array() on boolean in C:\Program Files (x86)\EasyPHP-Devserver-16.1\eds-www\CompanyGiondaCI\application\models\Mpages.php on line 197
A PHP Error was encountered
Severity: Error
Message: Call to a member function result_array() on boolean
Filename: models/Mpages.php
Line Number: 197
Backtrace:

@davy_yg is your "setting" table store only 1 record? It seems to me since you just updating the record in that table without condition. What if you haven't yet any record in this "setting" table? If that is the case you should insert the settings first and the next execution will be updating.

Mpages.php

PHP Code:

function settings()
{
    $data = array(
        'email' => $this->input->post('email'),
        'site_name' => $this->input->post('sitename'),
        'meta_title' => $this->input->post('title'),
        'meta_keyword' => $this->input->post('keyword'),
        'meta_description' => $this->input->post('description'),
        'facebook' => $this->input->post('facebook'),
        'twitter' => $this->input->post('twitter'),
        'rss' => $this->input->post('rss')
    );

    if($this->db->from('settings')->count_all_results())
    {
        $success = $this->db->update('setting', $data);
    }
    else
    {
        $success = $this->db->insert('setting', $data);
    }

    // the update and insert method only return boolean [true means success, false means failed]
    if($success)
    {
        // meaning success so return the record from setting table
        // again, i assumed that the record from table is just 1 so this function only return a single result if success
        return $this->db->get('setting')->row();
    }

    return false;
} 


[Just a programmer] [/Just a programmer]