Wiki articles tagged with "database"

Simple Yii Script for performing CRUD operations:

Default date format in Oracle is DD-MON-RR (25-JAN-18). With that output, we can't using date formatting.

Note the tag {{homeUrl}} will be dynamically replaced at runtime.

The classic Yii way for doing an update action is as follows:

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.

Lately, i needed to deal with the following scenario: read from two databases (db1,db2), and write to a third database (db3).

According to below wiki we could migrate database schema to another database

Suppose we want to set a category to product (or an item in general term), Also suppose categories has sub-categories (multi-level)

I used another example posted here a while back where the person was modifying the index.php and adding in a switch case for different domains and loading separate config files. This was actually too much for me, because all my portals are the exact same (as far as routes, modules, extensions, etc) and if I ever wanted to add another route it wouldn't be feasible opening up all the config files t...

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:

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).

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.

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.

This is a tutorial for how to auto set model values without any code.

create a class file under protected\components named RActiveRecord.php

Add these lines in /config/main.php

'components'=>array(
.........
		'db'=>array(
			'connectionString' => 'mysql:host=localhost;dbname=database1',
			'emulatePrepare' => true,
			'username' => 'root',
			'password' => 'itsasecret',
			'charset' => 'utf8',
		),
		'db2'=>array(
		    'class' => 'CDbConnection',
			'connectionString' => 'mysql:host=localhost;dbname=databa...

What would you do if you want/need to have a different than the main database connection in an module's models?

This is an incipient implementation of application-driven database with Yii.

To get null from database instead of empty strings you need to set up your DB connection as follows:

The customary configuration of a Yii application includes just a single database section in the protected/config/main.php file, but it's easy to extend this to support more than one, tying each Model to one of the databases.