Wiki

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

CRUD operation in Yii framework

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

Insert data from database to another database table

Created 3 months ago by KonApazTutorials0 comments – viewed 1,480 times – ( +1 ) – version 1.1
According to below wiki we could migrate database schema to another database

Generate CTreeview from database table and update a model

Created 4 months ago by KonApazHow-tos0 comments – viewed 1,558 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)

How to store array/widget configuration to the database with config validation rules

Created 4 months ago by Kartik VTutorials0 comments – viewed 1,755 times – ( +29 / -4 ) – version 2.0
You may have scenarios, where you want to store a specific array configuration to the database. A classic example could be saving Yii widget configuration to the database and then retrieving it at runtime, with dynamic parameters set. This wiki discusses one of the approaches to do this. Let's consider you have something like the NavBar configuration below to store in the db:

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

Created 4 months ago by tomvdpHow-tos0 comments – viewed 3,052 times – ( +1 ) – version 1.1
The classic Yii way for doing an update action is as follows:

Multi Data Provider

Created 11 months ago by Sharon LavieTips0 comments – viewed 5,405 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

Created about a year ago by Rajith RHow-tos3 comments – viewed 12,773 times – ( +9 / -6 ) – version 1.1
create a class file under protected\components named RActiveRecord.php

How to display static pages in Yii with database content?

Created about a year ago by yasenTutorials5 comments – viewed 18,999 times – ( +10 ) – version 1.1
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 2 years ago by vibhaJadwaniTutorials3 comments – viewed 14,257 times – ( +9 ) – version 1.1
This is a tutorial for how to auto set model values without any code.

How to catch and log MySQL deadlock errors

Created 2 years ago by sebTips1 comment – viewed 8,386 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