Use Array Data in CodeIgniter Model as SQL?

Question

In my controller, I am passing data to the model using the following code:

$data = array(
    'gid'   =>  $this->input->post('gid'),
    'name'  =>  $this->input->post('name'),
    'pic'   =>  $this->input->post('pic'),
    'link'  =>  $this->input->post('link')
);  
var_dump($data);
$this->Login_model->insert_entry($data);

In my model, what I want to do is use the gid value as part of an SQL statement, like so:

$get_gid = $this->db->query('SELECT * FROM users WHERE gid = $gid');

Obviously this doesn't work, so I'm just wondering how I get the gid from $data and use it in my SQL statement?

Tested using

$get_gid = $this->db->where('gid', $data['gid'])->get('users');
print_r($get_gid);

However output is:

CI_DB_mysql_result Object ( [conn_id] => Resource id #30 [result_id] => Resource id #33 [result_array] => Array ( ) [result_object] => Array ( ) [custom_result_object] => Array ( ) [current_row] => 0 [num_rows] => 0 [row_data] => )

bidon · Accepted Answer · 2013-07-10 23:56:53Z

0

Did you try gid = $data['gid']

I assume that yours model method looks like this:

insert_entry($data)
{
     here active record or query...
 }

If yes try to display query to see if $data['gid'] is visible there

You can try it by

$this->db->get_compiled_select();

Or after query runs

$this->db->last_query();

edited Jul 10, 2013 at 23:56

answered Jul 10, 2013 at 23:39

bidon

32 bronze badges

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

Comments

MJ X · Accepted Answer · 2013-07-11 03:44:22Z

0

Try this way:

$data = array(
 'gid'   =>  $this->input->post('gid'),
 'name'  =>  $this->input->post('name'),
 'pic'   =>  $this->input->post('pic'),
 'link'  =>  $this->input->post('link')

);

$gid = $data['gid'];

$this->db->where('gid',$gid);
$this->db->from('users');
$query = $this->db->get(); 
if($query)
{
    //you can return query or you can do other operations here like insert the array data
    //$this->db->insert('yourtable',$data);
    return $query;
}
else
{
    return FALSE;
}

answered Jul 11, 2013 at 3:44

MJ X

9,12413 gold badges86 silver badges125 bronze badges

Comments

rfpdl · Accepted Answer · 2013-07-11 06:10:15Z

0

You can try:

$get_gid = $this->db->query('SELECT * FROM users WHERE gid = '.$data['gid'].');

answered Jul 11, 2013 at 6:10

rfpdl

9641 gold badge14 silver badges37 bronze badges

Comments

Ravi · Accepted Answer · 2014-05-27 11:11:25Z

0

You just Forget after query $query->result().

answered May 27, 2014 at 11:11

Ravi

7171 gold badge8 silver badges18 bronze badges

Collectives™ on Stack Overflow

Use Array Data in CodeIgniter Model as SQL?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related