Wiki

Articles tagged with "database"X
Displaying 1-10 of 13 result(s).

How to display static pages in Yii with database content?

Created 8 months ago by yasenTutorials4 comments – viewed 9,261 times – ( +4 )
To extend further static pages as shown by Qiang http://www.yiiframework.com/wiki/22/how-to-display-static-pages-in-yii/ here're the steps to take:

Auto set model fields values

Created 11 months ago by vibhaJadwaniTutorials3 comments – viewed 7,712 times – ( +7 )
This is a tutorial for how to auto set model values without any code.

How to catch and log MySQL deadlock errors

Created about a year ago by sebTips0 comments – viewed 5,762 times – ( +4 )
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

Update two models with one view

Created about a year ago by sensorarioTips10 comments – viewed 19,411 times – ( +10 / -2 )
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

Use application on production/development environment without making changes

Created about a year ago by ifdatticTips2 comments – viewed 16,957 times – ( +8 / -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

Created about a year ago by Tudor IlisoiOthers0 comments – viewed 6,007 times – ( +8 )
This is an incipient implementation of application-driven database with Yii.
tags: database, model

Guidelines for good schema design

Created about a year ago by Steve FriedlTips13 comments – viewed 36,765 times – ( +127 )
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.

Sub-domains with different databases in Yii!

Created 2 years ago by jwerdHow-tos3 comments – viewed 8,235 times – ( +1 )
Sub-domains with different databases in Yii!

Single table inheritance

Created 2 years ago by samdarkHow-tos6 comments – viewed 14,244 times – ( +31 )
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 of the same table.

A simple class to use a different db for a module

Created 2 years ago by tydeas_drTips2 comments – viewed 8,817 times – ( +8 )
What would you do if you want/need to have a different than the main database connection in an module's models?