CodeIgniter query shows variable name in executed query instead of the variable's value [duplicate]

Question

I am having problems in fetching data from my database here is my getOne function

public function getOne($sku)
{
    $ans = 0;
    $query = $this->db->query('SELECT * FROM barcode_sku WHERE sku = "$sku"');
    $res = $query->result();
    $row = $res[0];
    $ans =  $row->quantity;
    
    
    return $ans;
}

the variable $sku will have values like bc_001 or bc_002.... The problem is if I hard code this value i.e bc_001 in my query it fetches the result correctly however when I use the variable $sku in my query it does not work.

Simplify your CodeIgniter script: return $this->db->get_where('barcode_sku', ['sku' => $sku])->row('quantity'); — mickmackusa
– mickmackusa ♦, Commented Nov 3 at 19:47

skmail · Accepted Answer · 2015-08-27 16:52:05Z

1

Because you're using single quotes to warp your query statement php will not prase the variable inside that query, instead use the double quotations to allow php to interpret the $sku variable.

 $query = $this->db->query("SELECT * FROM barcode_sku WHERE sku = \"$sku\"");

Also don't forget to escape $sky variable to avoid SQL Injections.

a better solution is to use codeigniter active record.

http://www.codeigniter.com/userguide2/database/active_record.html

answered Aug 27, 2015 at 16:52

skmail

4233 silver badges6 bronze badges

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

Comments

Fake Face · Accepted Answer · 2015-08-27 16:52:34Z

0

may be you can modify the query like this:

public function getOne($sku){

    $ans = 0;
    $sql= 'SELECT * FROM barcode_sku WHERE sku = ?';
    $query = $this->db->query($sql, array($sku));
    $res = $query->result();
    $row = $res[0];
    $ans =  $row->quantity;


    return $ans;
}

answered Aug 27, 2015 at 16:52

Fake Face

1164 bronze badges

Comments

Sorav Garg · Accepted Answer · 2015-08-27 17:03:32Z

0

please try this --

public function getOne($sku)
{
    $this->db->select('*');
    $this->db->from('barcode_sku');
    $this->db->like('sku ', $sku,'after');
    $query = $this->db->get();
    return $query->result_array();
}

it will return a array..

edited Aug 27, 2015 at 17:03

answered Aug 27, 2015 at 16:58

Sorav Garg

1,0671 gold badge9 silver badges29 bronze badges

Collectives™ on Stack Overflow

CodeIgniter query shows variable name in executed query instead of the variable's value [duplicate]

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related