Wiki

Articles tagged with "database", sorted by date (updated)X
Displaying 1-10 of 21 result(s).

Active Record snapshotting (Model data base history)

Updated about a month ago by BizleyTutorials3 comments – viewed 2,168 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.

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

Updated 8 months ago by parthshahHow-tos4 comments – viewed 17,467 times – ( +9 / -6 ) – version 1.1
create a class file under protected\components named RActiveRecord.php

CRUD operation in Yii framework

Updated 10 months ago by Mohammad FareedTutorials4 comments – viewed 6,108 times – ( +1 / -6 ) – version all
Simple Yii Script for performing CRUD operations:

Insert data from database to another database table

Updated 11 months ago by Kostas Apazidis (KonApaz)Tutorials0 comments – viewed 2,662 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

Updated 11 months ago by Kostas Apazidis (KonApaz)How-tos0 comments – viewed 2,951 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

Updated 11 months ago by Kartik VTutorials0 comments – viewed 3,318 times – ( +37 / -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

Updated about a year ago by tomvdpHow-tos0 comments – viewed 4,952 times – ( +1 ) – version 1.1
The classic Yii way for doing an update action is as follows:

Multi Data Provider

Updated about a year ago by Sharon LavieTips0 comments – viewed 6,396 times – ( +1 )
Lately, i needed to deal with the following scenario: read from two databases (db1,db2), and write to a third database (db3).

Guidelines for good schema design

Updated 2 years ago by softarkTips14 comments – viewed 64,776 times – ( +142 ) – version 1.1
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.

How to display static pages in Yii with database content?

Updated 2 years ago by yasenTutorials6 comments – viewed 22,240 times – ( +11 ) – 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: