Wiki

Articles tagged with "database", sorted by ratingX
Displaying 11-20 of 21 result(s).

Use application on production/development environment without making changes

Created 4 years ago by ifdatticTips3 comments – viewed 46,059 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.

Update two models with one view

Created 4 years ago by sensorarioTips11 comments – viewed 39,347 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

Created 4 years ago by sebTips1 comment – viewed 11,783 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

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

Created 3 years ago by Rajith RHow-tos4 comments – viewed 24,614 times – ( +9 / -6 ) – version 1.1
create a class file under protected\components named RActiveRecord.php

Active Record snapshotting (Model data base history)

Created about a year ago by BizleyTutorials3 comments – viewed 5,357 times – ( +2 ) – version 1.1
One of the common tasks the web application might be required to perform, especially the app using some kind of a CMS, is to save the history of data changes. Your client for sure will want the answer to this simple question - If I mess this up or delete by accident can we bring it back? Well, DB backup is one thing and quick recovery is another - let's talk about latter one.

Sub-domains with different databases in Yii!

Created 5 years ago by jwerdHow-tos5 comments – viewed 15,530 times – ( +2 ) – version 1.1
Sub-domains with different databases in Yii!

Multi Data Provider

Created 2 years ago by Sharon LavieTips0 comments – viewed 8,195 times – ( +1 ) – version 1.1
Lately, i needed to deal with the following scenario: read from two databases (db1,db2), and write to a third database (db3).

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

Created 2 years ago by tomvdpHow-tos0 comments – viewed 8,912 times – ( +1 ) – version 1.1
The classic Yii way for doing an update action is as follows:

Generate CTreeview from database table and update a model

Created 2 years ago by Kostas Apazidis (KonApaz)How-tos0 comments – viewed 5,466 times – ( +1 ) – version 1.1
Suppose we want to set a category to product (or an item in general term), Also suppose categories has sub-categories (multi-level)

Insert data from database to another database table

Created 2 years ago by Kostas Apazidis (KonApaz)Tutorials0 comments – viewed 4,491 times – ( +1 ) – version 1.1
According to below wiki we could migrate database schema to another database