Wiki

Displaying 361-370 of 705 result(s).

Using sub query for doubletts

Created 2 years ago by mbTips3 comments – viewed 7,477 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 2 years ago by kiran sharmaHow-tos20 comments – viewed 29,395 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 2 years ago by raheelk2kTutorials4 comments – viewed 18,417 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 2 years ago by c@cbaTutorials8 comments – viewed 32,228 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 2 years ago by mrkmgTips0 comments – viewed 4,258 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,617 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 17,738 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 50,720 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 14,669 times – ( +9 ) – 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 5,233 times – ( +3 ) – 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: