Tag: activerecord

52 votes
5 answers
2.2K views
How to do IS NULL and IS NOT NULL with Yii 2 ActiveRecord?

I have a table which has a field `activated_at` timestamp NULL DEFAULT NULL, which means that it can contain a

avatar
Don
0 1 0 9
asked 07 September, 2021
54 votes
4 answers
1.2K views
Yii2 : Active Record add Not In condition

What is the active Record way of adding IN condition to an active Query in yii 1.x you could use CDbCriteria l

avatar
Sachiko
0 1 0 9
asked 07 September, 2021
55 votes
8 answers
1.5K views
Yii2 How to perform where AND or OR condition grouping?

I am new to Yii-2 framework. How can i achieve following query in Yii-2 framework using activeQuery and models

avatar
Venice
0 1 0 9
asked 07 September, 2021
53 votes
3 answers
1.2K views
Increment field of mysql database using codeigniter's active record syntax

I have the following php-codeigniter script which attempts to increment a field of a record using active-recor

avatar
Shanita
0 1 0 9
asked 07 September, 2021
55 votes
5 answers
1.1K views
How to add an ORDER BY clause using CodeIgniter's Active Record methods?

I have a very small script to get all records from a database table, the code is below. $query = $this->db-

avatar
Rudy
0 1 0 9
asked 07 September, 2021
57 votes
11 answers
1.1K views
CodeIgniter Active Record - Get number of returned rows

I'm very new to CodeIgniter and Active Record in particular, I know how to do this well in normal SQL but

avatar
Majorie
0 1 0 9
asked 07 September, 2021
52 votes
10 answers
1.8K views
How to select rows where column value IS NOT NULL using CodeIgniter's ActiveRecord?

I'm using CodeIgniter's Active Record class to query the MySQL database. I need to select the rows i

avatar
Arline
0 1 0 9
asked 07 September, 2021