用CodeIgniter插入语句 - 很困惑

Question

I'm doing well with CodeIgniter. I can do SELECT statements on my MySQL database with no problems at all. But, now I'm trying to do an INSERT statement.

Note that I have not tried an UPDATE statement yet.

After reading the docs, I'm so confused.

This is what I have:

contacts.php:

function add() {

    //echo "<pre>";print_r($_POST);

    $this->load->model('Contacts_model');
    $this->Contacts_model->insertContact($_POST);
}

contacts_model.php:

function insertContact($_POST) {

    //echo "<pre>";print_r($_POST);
    $title = $_POST['title']; // I can echo this here. It works
    $f_name = $_POST['f_name']; // I can echo this here. It works



    $sql = "INSERT INTO contacts (title,f_name) " .
        "VALUES (" .
        $this->db->escape($title) .
        "," .
        $this->db->escape($f_name) .
        ")";
    $this->$db->query($sql);
}

I've read about Active Record, but if that's what is messing me up, then I still don't realize what I'm doing wrong. All of the examples look exactly like mine.

Help?

EDIT

    $sql = "INSERT INTO contacts (title,f_name) VALUES ('$this->db->escape($title)','$this->db->escape($f_name)'";
    $this->$db->query($sql);

I've also tried it like this. And many other variants. It doesn't seem to be my syntax... I think.

Answer 1

Your query is fine, only reason that why query is not being executed is that you are using this:

$this->$db->query($sql);

there is nothing like $db, just use this:

$this->db->query($sql);

I'm sure this is the problem, but if it is not then please kindly post the error what it is giving. Thanks.

Hope this helps.