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 3 years ago by ifdatticTips3 comments – viewed 35,085 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 3 years ago by sensorarioTips11 comments – viewed 34,469 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 3 years ago by sebTips1 comment – viewed 9,447 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 about a year ago by Rajith RHow-tos4 comments – viewed 17,625 times – ( +9 / -6 ) – version 1.1
create a class file under protected\components named RActiveRecord.php

Active Record snapshotting (Model data base history)

Created 2 months ago by BizleyTutorials3 comments – viewed 2,237 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 3 years ago by jwerdHow-tos4 comments – viewed 13,272 times – ( +2 ) – version 1.1
Sub-domains with different databases in Yii!

Multi Data Provider

Created about a year ago by Sharon LavieTips0 comments – viewed 6,434 times – ( +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 about a year ago by tomvdpHow-tos0 comments – viewed 5,000 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 11 months ago by Kostas Apazidis (KonApaz)How-tos0 comments – viewed 3,001 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 11 months ago by Kostas Apazidis (KonApaz)Tutorials0 comments – viewed 2,690 times – ( +1 ) – version 1.1
According to below wiki we could migrate database schema to another database