Wiki

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

Use application on production/development environment without making changes

Created 2 years ago by ifdatticTips3 comments – viewed 31,363 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 2 years ago by sensorarioTips11 comments – viewed 32,036 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 2 years ago by sebTips1 comment – viewed 8,598 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-tos3 comments – viewed 13,862 times – ( +9 / -6 ) – version 1.1
create a class file under protected\components named RActiveRecord.php

Sub-domains with different databases in Yii!

Created 3 years ago by jwerdHow-tos4 comments – viewed 12,261 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 5,661 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 6 months ago by tomvdpHow-tos0 comments – viewed 3,572 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 5 months ago by KonApazHow-tos0 comments – viewed 1,838 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 5 months ago by KonApazTutorials0 comments – viewed 1,762 times – ( +1 ) – version 1.1
According to below wiki we could migrate database schema to another database

CRUD operation in Yii framework

Created 5 months ago by Mohammad FareedTutorials4 comments – viewed 3,138 times – ( +1 / -6 ) – version all
Simple Yii Script for performing CRUD operations: