In this guide I will explain best practise regarding performance in MySQL, PHP and of course our loved Yii Framework. Since this is a complex topic, I will start with some basics and then expand this guide from time to time. Since this wiki can become big, you may click on View history - there you can see what changes have been made, so you don't miss anything.

In this cookbook I will attempt to explain how to use the lightweight version of Role-Based Access Control using a php file. This version does not use database but a php file and is controlled by CPhpAuthManager class.

A simple trick to get the localized version of a model field is to add this little method to your models.

In this post I am going to describe a solution to make your yii-based web application safe from illegal content injections.

p.s. latest version of this tutorial is always available unter the docs/ folder of the User Management Module.

In this tutorial we will be setting up a content type to be ordered by weight using the JUI Sortable plugin.

This example uses a MySQL DB with a table named tree with the fields id, name, and parent_id. The parent_id will be NULL for root elements. The SQL is kept simple (no autoinc, no FK, etc).

From: http://lacot.org/ and me.

Hello ppl. Even though i have a small experience with yii I though of writing this to help people which want to do something similar.

Hi, I was having problems each time I had to test the site or edit something on my local machine, like changing the db connection, change the debug mode to false, the trace level to 0, disable Gii, etc. So I created a class to resolve all my problems, hope to help you in your projects!

In this article you will find Yii framework extensions enabling you to add various charts/print out buttons etc. to your webapp.

Installing WAMP on XP was pretty easy; W7 is not so trivial. It's not difficult once you know, but it took me best part of a day to figure out and required gleaning various bits of information from around the web; this tutorial brings it all together in one place to (hopefully) make other peoples lives that bit easier. It does assume that you are reasonably happy configuring Apache, PHP, and MySQL...

Sometime, in a many-to-many relation, you need to retrieve AR that aren't linked. In practice, AR with null value in the join table. So you implements a criteria like this :

public function scopeUnused( $useAnd = true )
    {
        $join = " left outer join composed_by j on t.ID = j.ID ";
        $condition = ' j.ID Is Null';

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

In order to nicely display flash Messages, create view like this called views/site/dialog.php :

I found a better solution.

It is a common case coders often come accross. For example the purpose of these checkbox is to mark records to be deleted

Followings are the simple steps to put an analogue clock widget on your skeleton application that is just generated by yiic.

This page is created to supply short directions and general tips for managing a Yii application in NetBeans IDE.

• Install Firebug plugin for Firefox from here.