search
Homephp教程php手册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!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version