Articles tagged with "database", sorted by date (updated)X
Displaying 1-10 of 15 result(s).

Multi Data Provider

Updated 6 months ago by Sharon LavieTips0 comments – viewed 4,288 times – ( +1 )
Lately, i needed to deal with the following scenario: read from two databases (db1,db2), and write to a third database (db3).

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

Updated 8 months ago by Rajith RHow-tos4 comments – viewed 8,616 times – ( +6 )
create a class file under protected\components named RActiveRecord.php

Guidelines for good schema design

Updated about a year ago by softarkTips13 comments – viewed 51,575 times – ( +138 ) – version 1.1
Virtually all Yii applications are built on top of a database, and though Yii is very flexible in how it addresses your DB, some design choices make things more convenient than others.

How to display static pages in Yii with database content?

Updated about a year ago by yasenTutorials4 comments – viewed 16,238 times – ( +8 ) – version 1.1
To extend further static pages as shown by Qiang here're the steps to take:

Multiple-database support in Yii

Updated about a year ago by phazeiHow-tos14 comments – viewed 58,108 times – ( +27 ) – version 1.1
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.
tags: Database

Auto set model fields values

Updated about a year ago by vibhaJadwaniTutorials3 comments – viewed 11,955 times – ( +8 ) – version 1.1
This is a tutorial for how to auto set model values without any code.

Update two models with one view

Updated about a year ago by SebKTips10 comments – viewed 27,903 times – ( +10 / -2 ) – version 1.1
Suppose to have two models: Users and Emails. You do not want to store email in a Users model. And User can have 0 or many emails. This is the form generated to create a new user (just username).
tags: database, model, view, form

How to catch and log MySQL deadlock errors

Updated 2 years ago by sebTips0 comments – viewed 7,596 times – ( +4 ) – version 1.1
This method allows to log InnoDB monitor output when deadlock error occured. This way we will have much more useful data to find and fix deadlock.
tags: database

Use application on production/development environment without making changes

Updated 2 years ago by ifdatticTips3 comments – viewed 26,803 times – ( +8 / -1 ) – version 1.1
I like programing on my localhost, however it really bugged me to make changes to index.php & config files on my production server. After combining all available wiki articles on this topic and some trial and error this is what I use for my applications so I could just upload it to production server and it will work without any changes.

Application-driven database with CDbMigration and an extended CActiveRecord

Updated 2 years ago by Tudor IlisoiOthers0 comments – viewed 7,780 times – ( +8 ) – version 1.1
This is an incipient implementation of application-driven database with Yii.
tags: database, model