Summary of related usage of database operation function $this->db->where() in CI framework

The examples in this article summarize the related usage of the database operation function $this->db->where() in the CI framework. Share it with everyone for your reference, the details are as follows:

Usage of CI framework database operation function this->db->where()

1) $this->db-> ;where('MATCH (field) AGAINST ("value")', NULL, FALSE)

If $this->db->where() accepts the optional third parameter, set it to FALSE, CodeIgniter will not protect field or table names that contain backticks.

2) $this->db->or_where()

This function is almost identical to the one above. The only difference is that the clause generated by this function uses OR. Connected:

$this->db->where('name !=', $name);
$this->db->or_where('id >', $id);
// 生成: WHERE name != 'Joe' OR id > 50

Description: or_where() was previously called orwhere(), which is obsolete.

3) $this->db->where_in();

Generate a WHERE field IN ('item', 'item') query statement, and use AND if appropriate connect them.

$names = array('Frank', 'Todd', 'James');
$this->db->where_in('username', $names);
// 生成: WHERE username IN ('Frank', 'Todd', 'James')

##4)$this->db->or_where_in();

Generate a WHERE field IN ('item', 'item') query statements, concatenated with OR if appropriate.

$names = array('Frank', 'Todd', 'James');
$this->db->or_where_in('username', $names);
// 生成: OR username IN ('Frank', 'Todd', 'James')

##5)$this->db->where_not_in();

Generate a WHERE field NOT IN ('item' , 'item') query statements, connected with AND if appropriate.

$names = array('Frank', 'Todd', 'James');
$this->db->where_not_in('username', $names);
// 生成: WHERE username NOT IN ('Frank', 'Todd', 'James')

##6)$this->db->or_where_not_in();

Generate a WHERE field NOT IN ('item' , 'item') query statements, connected with OR if appropriate.

$names = array('Frank', 'Todd', 'James');
$this->db->or_where_not_in('username', $names);
// 生成: OR username NOT IN ('Frank', 'Todd', 'James')

I hope this article will be helpful to everyone’s PHP program design based on the CodeIgniter framework.

For more related usage summary of the database operation function $this->db->where() in the CI framework, please pay attention to the PHP Chinese website!