CodeIgniter Query Builder Class nested query [duplicate]

Question

I have this query that works fine on mysql, but I can't get it to work in CodeIngniter's Query Builder Class. It's a search box with multiple inputs.

I've tried this, but couldn't make it work.

$this->db->like('num_articulo ', $aricle_number, 'after');
$array = array('descripcion1' => $article_description, 'descripcion2' => $article_description)
$this->db->or_like($array);
$this->db->where('status', 1);
       return $this->db->get('articulos')->result_array();

Here is my sql

SELECT * FROM articulos WHERE num_articulo LIKE 'yyyyy%' AND (descripcion1 LIKE '%xxxx%' OR descripcion2 LIKE '%xxxx%')

Indigo · Accepted Answer · 2018-03-23 09:20:38Z

1

CodeIgniter Query Builder has a neat query grouping feature:

$this->db->group_start()
$this->db->group_end()

Hence, you're query would look like, in a pure QB fashion:

$this->db->like('num_articulo ', $aricle_number, 'after');
$this->db->group_start();
    $this->db->like('descripcion1', $article_description);
    $this->db->or_like('descripcion2',  $article_description);
$this->db->group_end();
$this->db->where('status', 1); // This one doesn't seem to appear in your query example?

$this->db->get('articulos')->result_array();

You would get the following query:

SELECT * FROM `articulos` WHERE `num_articulo` LIKE 'yyyyy%' ESCAPE '!' AND ( `descripcion1` LIKE '%xxxx%' ESCAPE '!' OR `descripcion2` LIKE '%xxxx%' ESCAPE '!' ) AND `status` = 1

Note: CodeIgniter adds ESCAPE '!' internally to identify the escape symbol.

answered Mar 23, 2018 at 9:20

Indigo

8737 silver badges16 bronze badges

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

1 Comment

Lucas.Fradusco Over a year ago

worked like a charm! wasn't aware of that function. ty!

Lucas.Fradusco · Accepted Answer · 2018-03-21 19:24:30Z

0

might not be the nicest thing to do, but it worked just fine.

$this->db->like('num_articulo', $number, 'after');
$this->db->where('status', 1);
$this->db->where('(descripcion1 LIKE "%'.$search_data.'%" OR descripcion2 LIKE "%'.$search_data.'%")');
return $this->db->get('articulos')->result_array();

answered Mar 21, 2018 at 19:24

Lucas.Fradusco

391 silver badge7 bronze badges

Collectives™ on Stack Overflow

CodeIgniter Query Builder Class nested query [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related