Wiki articles in category How-tos tagged with "database"

Showing 1-6 of 6 items.

Generate CTreeview from database table and update a model

Created 9 years ago by Kostas Apazidis (KonApaz), updated 9 years ago by Kostas Apazidis (KonApaz).

Suppose we want to set a category to product (or an item in general term), Also suppose categories has sub-categories (multi-level)

1 0
1 follower
Viewed: 13 592 times
Version: 1.1
Category: How-tos

How to avoid a database update if the ActiveRecord was not modified

Created 9 years ago by tomvdp, updated 9 years ago by tomvdp.

The classic Yii way for doing an update action is as follows:

1 0
3 followers
Viewed: 26 152 times
Version: 1.1
Category: How-tos

Multiple Database Connection : Select database based on login user id, Dynamic

Created 10 years ago by Rajith R, updated 9 years ago by parthshah.

create a class file under protected\components named RActiveRecord.php

6 0
12 followers
Viewed: 44 281 times
Version: 1.1
Category: How-tos

Sub-domains with different databases in Yii!

Created 12 years ago by jwerd, updated 12 years ago by jwerd.

I used another example posted here a while back where the person was modifying the index.php and adding in a switch case for different domains and loading separate config files. This was actually too much for me, because all my portals are the exact same (as far as routes, modules, extensions, etc) and if I ever wanted to add another route it wouldn't be feasible opening up all the config files t...

2 0
12 followers
Viewed: 25 688 times
Version: 1.1
Category: How-tos

Single table inheritance

Created 12 years ago by samdark, updated 12 years ago by samdark.

Relational databases do not support inheritance so if we need to represent it, we have to somehow store meta info while keeping performance by minimizing JOINs. One way to solve this problem is using single table inheritance. All fields for the whole class tree are stored in a single table. Class name is stored in the type field...

34 0
35 followers
Viewed: 52 847 times
Version: 1.1
Category: How-tos

Multiple-database support in Yii

Created 13 years ago by Steve Friedl, updated 11 years ago by phazei.

The customary configuration of a Yii application includes just a single database section in the protected/config/main.php file, but it's easy to extend this to support more than one, tying each Model to one of the databases.

20 0
39 followers
Viewed: 144 130 times
Version: 1.1
Category: How-tos
Tags: database