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 5 years ago by Kostas Apazidis (KonApaz), updated 5 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: 9 396 times
Version: 1.1
Category: How-tos

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

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

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

1 0
3 followers
Viewed: 16 943 times
Version: 1.1
Category: How-tos

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

Created 6 years ago by Rajith R, updated 5 years ago by parthshah.

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

6 0
12 followers
Viewed: 34 673 times
Version: 1.1
Category: How-tos

Sub-domains with different databases in Yii!

Created 8 years ago by jwerd, updated 8 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: 20 203 times
Version: 1.1
Category: How-tos

Single table inheritance

Created 8 years ago by samdark, updated 8 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
36 followers
Viewed: 44 484 times
Version: 1.1
Category: How-tos

Multiple-database support in Yii

Created 8 years ago by Steve Friedl, updated 7 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
40 followers
Viewed: 121 722 times
Version: 1.1
Category: How-tos
Tags: database