Showing 481-500 of 826 items.

Using sub query for doubletts

Created 14 years ago by mb mb, updated 13 years ago by mb mb. 3 comments

find doubletts by db fields. in this example i will check doublets for 3 tabelfields (col1,col2,col3). so i will get a subquery with the condition, select and grouping of the tablefields. the having with COUNT() > 1 means: find all records more then one result.

$model=new MyModel('search');
$model->unsetAttributes();

3 0
10
Viewed: 28 359 times
Version: 1.1
Category: Tips

How to use Multiple instances of the same model in the same form

Created 14 years ago by kiran sharma kiran sharma, updated 14 years ago by Maurizio Domba Cerin Maurizio Domba Cerin. 21 comments

When i had created this functionality then i found some difficulties and not got much idea from wiki and forums. so, i think this will be useful for newbie users and save time of other developers when create related functionality. I refer Collecting Tabular Input tutorial but not got clear idea for create/update...

Simple way to use AutoComplete using different ID and Display Value

Created 14 years ago by raheelk2k raheelk2k, updated 14 years ago by raheelk2k raheelk2k. 5 comments

Usually when we use AutoComplete in a project, We need to show "title" or "name" in the list, while when the form is posted, we need some sort of integer ID referring to the selected value. Out of the Box, CJuiAutoComplete widget doesn't provides different display text and post values.

6 0
13
Viewed: 67 515 times
Version: 1.1
Category: Tutorials

Custom Number Formatting or Decimal Separators and i18n

Created 14 years ago by c@cba c@cba, updated 14 years ago by c@cba c@cba. 8 comments

By default, the decimal separator in php (also in mysql) is a dot (.). So when we work with floats in Yii (in calculations, validation, sql statements etc.), the decimal separator has to be a dot. If we want to use for example a comma (,) as the decimal separator, that is if we want to display numbers and enable users to enter numbers with a comma before the decimals, we have to...

4 0
16
Viewed: 94 957 times
Version: 1.1
Category: Tutorials

Yii behind a reverse proxy, SSL support and correct IP logging

Created 14 years ago by mrkmg mrkmg, updated 14 years ago by mrkmg mrkmg. 0 comments

If you are hosting Yii behind a reverse proxy, for example nginx, and you are having issues with your logs showing the proxies IP, or the urls being created arn't being created for SSL because your SSL certs are located on your reverse proxy instead of the Yii server, this code may be able to help you. I placed them in the very top of Yii's entry script, index.php

0 0
2
Viewed: 21 277 times
Version: 1.1
Category: Tips

Alternative wildcard characters CDbCriteria

Created 14 years ago by maigret maigret, updated 14 years ago by maigret maigret. 0 comments

In SQL, wildcard characters can be used in "LIKE" expressions; the percent sign (%) matches zero or more characters, and underscore (_) a single character. Sometimes users are not familiar with these or they are using different ones like (*) and (+) similar to regular expressions. My colleages do so and then i decided to add this feature by extending CbCriteria. Especially adding a new parameter $...

1 0
2
Viewed: 13 854 times
Version: 1.1
Category: How-tos

How to upload image(photo), and path entry in database with update functionality

Created 14 years ago by kiran sharma kiran sharma, updated 12 years ago by Shahcheraghean Shahcheraghean. 22 comments

I saw many posts that community newbie is confuse in image/photo upload with random name. so I post this topic covering all useful things regarding to image/photo upload(not covering image attribute related functionality)

15 0
39
Viewed: 217 867 times
Version: 1.1
Category: Tips

ACL and RBAC

Created 14 years ago by zeroByte zeroByte, updated 14 years ago by kevinkorb kevinkorb. 0 comments

This HowTo assumes that you have a smattering of ACL in general and of how the acl-extension works basically. It will introduce you into the abstract and give you a hint on how to use Business-Rules. If you have in-depth questions, please refer to the extension documentation. Using ACL in an RBAC-manner cannot and should never obs...

0 0
3
Viewed: 36 708 times
Version: 1.1
Category: How-tos