Wiki

Displaying 341-350 of 685 result(s).

Using sub query for doubletts

Created about a year ago by mbTips3 comments – viewed 6,728 times – ( +1 ) – version 1.1
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.

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

Created about a year ago by kiran sharmaHow-tos19 comments – viewed 25,146 times – ( +20 / -6 ) – version 1.1
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 about a year ago by raheelk2kTutorials4 comments – viewed 17,157 times – ( +9 ) – version 1.1
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.

Custom Number Formatting or Decimal Separators and i18n

Created about a year ago by c@cbaTutorials8 comments – viewed 28,537 times – ( +6 ) – version 1.1
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...

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

Created about a year ago by mrkmgTips0 comments – viewed 3,995 times – version 1.1
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

Extending CJuiDialog

Created 2 years ago by dstudioHow-tos0 comments – viewed 8,253 times – ( +2 / -2 ) – version 1.1
Sometimes you have CJuiDialog with different content but same buttons (or width, height). If you don't want to repeat yourself this is a great solution:

How to render a view in Fancybox using ajax

Created 2 years ago by rix.rix.How-tos1 comment – viewed 16,619 times – ( +6 ) – version 1.1
Sometimes you want to render a view in Fancybox.
tags: fancybox, ajax, views

How to create front and admin side login form

Created 2 years ago by vibhaJadwaniHow-tos7 comments – viewed 45,912 times – ( +6 ) – version 1.1
In this WIKI you can learn how to create front and admin login form, using database.

Auto set model fields values

Created 2 years ago by vibhaJadwaniTutorials3 comments – viewed 13,691 times – ( +8 ) – version 1.1
This is a tutorial for how to auto set model values without any code.

Alternative wildcard characters CDbCriteria

Created 2 years ago by maigretHow-tos0 comments – viewed 4,843 times – ( +2 ) – version 1.1
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 $wildcard_chars to the method addSearchCondition to replace them if needed with standard SQL characters: