How can i initialize a userdefined variable.

[eluser]jinojoseph[/eluser]
Hi all,

I want to initialize a variable like $this->id = mysql_insert_id(); in the model page after a new record is created and i need to get this variable in the controller page.

How can i get this "id" variable in the controller without returning that id using the return statement.

Thanks in advance,

Jino

[eluser]pistolPete[/eluser]
If you use PHP5, you need to define this variable as public:

Code:

class Model_name extends Model {
    
    public $id;

    public function __construct()
    {
        parent::Model();
    }
}

In PHP4 all class variables are public.

Code:

class Model_name extends Model {
    
    var $id;

    function Model_name()
    {
        parent::Model();
    }
}

Now you can access this variable in your controller using:

Code:

$this->model_name->id

[eluser]jinojoseph[/eluser]
Thanks for ur quick reply!!!. It will be very thankful if u also mention how to initialize a value to this public variable "id " in the model page.

[eluser]pistolPete[/eluser]
Just like you wrote in your first post:

Code:

$this->id = 0;

[eluser]jinojoseph[/eluser]
I initialized a public variabe named action as public $action in the model page,

after that,

$data = array('master_name' => $this->input->post('master_name'));


$query = $this->db->insert('master', $data);

$this->action = "insert"; // THis variabel is used in the controller as a flag.

This is causing database error.

Error Number: 1054

Unknown column 'action' in 'field list'

INSERT INTO `master` (`action`, `master_name`) VALUES (NULL, 'sdf')

[eluser]stuffradio[/eluser]
That error is a MySQL error, it's saying you don't have a column named action in your table "master".

[eluser]jinojoseph[/eluser]
I know that it is a mysql error, but the reason for this error is because of the "action" variable initialization.

Is there any way to initialize the variable "action" without causing this mysql error.

[eluser]Michael Wales[/eluser]
Your code isn't making any sense...

Code:

// The data to insert into the table.
$data = array(‘master_name’ => $this->input->post(‘master_name’));
$query = $this->db->insert(‘master’, $data);

Code:

// The error
INSERT INTO `master` (`action`, `master_name`) VALUES (NULL, ‘sdf’)

This means somewhere you are adding 'action' to the $data array. Not what your code in this post is showing us. Are you sure you are not trying to pass $this to the insert() method?

[eluser]jinojoseph[/eluser]
please read the posts completely from the begining and try to reply..

regards,

[eluser]Michael Wales[/eluser]
I did read the post from the beginning and I am trying to help. Let's see if we can break this down a little futher:

Here you are inserting 2 columns: action and master_name.

Code:

INSERT INTO `master` (`action`, `master_name`) VALUES (NULL, ‘sdf’)

Here you are inserting 1 column: master_name.

Code:

$data = array(‘master_name’ => $this->input->post(‘master_name’));
$query = $this->db->insert(‘master’, $data);

In the code you have show us, thus far, the only place in which action is referenced is:

Code:

$this->action = 'insert';

So, even though the code you are showing us is this:

Code:

$data = array(‘master_name’ => $this->input->post(‘master_name’));
$query = $this->db->insert(‘master’, $data);

In reality, it looks like this:

Code:

$data = array(‘master_name’ => $this->input->post(‘master_name’));
// ... Do some other stuff here to add an action key to the $data array ...
$query = $this->db->insert(‘master’, $data);

If you would like help in debugging this problem, please share the relevant code in it's entirety.

To do what you want - your code should look something like this:

Code:

class Model_name extends Model {

  var $id;

  function insert($data) {
    $this->db->insert('master', $data);
    if ($this->db->affected_rows() > 0) {
      $this->id = $this->db->last_insert_id();
      return TRUE;
    }

    return FALSE;
  }

}

Code:

class Controller_name extends Controller {

  function index() {
    $this->load->model('model_name');
    if ($this->model_name->insert(array('master_name' => $this->input->post('master_name'))) {
      echo 'Inserted ID: ' . $this->model_name->id;
    } else {
      echo 'Did not insert data.';
    }
  }

}