Wiki articles tagged with "sql"

Showing 1-4 of 5 items.

What SQL-Statement creates yii?

Created a year ago by Necip, updated a year ago by Necip.

The usual way to find out what Yii has created for an SQL query is to mutilate the SQL in the sourcecode and call the program again so that the SQL statement with errors is displayed. Or you can use the SQL logger, which must be switched on and off each time and logs all SQL statements, which leads to an enormous slowdown in program execution and decelerates your workflow.

0 0
1 follower
Viewed: 7 664 times
Version: 1.1
Category: Tips

Yii2: Query build for complexity SQL

Created 4 years ago by Scott_Huang, updated 4 years ago by Scott_Huang.

As for complexity SQL query we have two solutions as below, I will discuss #2 in this article.

0 0
Viewed: 12 884 times
Version: 2.0
Category: Tips

custom sql query results to CDetailView

Created 6 years ago by Kostas Apazidis (KonApaz), updated 5 years ago by Rohit Suthar.

This is a bried guide about displaying of custom sql query results.

3 0
Viewed: 40 023 times
Version: 1.1
Category: How-tos

Using a CDbDataReader (sql query result) in a zii widget (such as CGridView or CListView)

Created 8 years ago by Revelis Luc Bonnin, updated 8 years ago by Revelis Luc Bonnin.

If in your application you have to proceed to a complex SQL query that is not associated to a model, you will use CDbDataReader like it is described in the Yii documentation. An example could be

8 1
Viewed: 30 900 times
Version: 1.1
Category: How-tos