Wiki

Articles in category "tips"X
Displaying 51-60 of 122 result(s).

Using sub query for doubletts

Created about a year ago by mbTips3 comments – viewed 6,053 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.

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

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

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

Created about a year ago by kiran sharmaTips11 comments – viewed 72,577 times – ( +27 / -3 ) – version 1.1
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)

BootProgressColumn - Progress Bar Inside GridView Column compatible with 'bootstrap' extension

Created about a year ago by LuizTips1 comment – viewed 11,096 times – ( +7 ) – version 1.1
A little hint of how to create a progress bar inside the column of the grid, using the 'bootstrap' extension.

How to filter CGridView with From Date and To Date datepicker

Created about a year ago by kiran sharmaTips12 comments – viewed 24,662 times – ( +14 / -3 ) – version 1.1
This artical is related to allow user to filter CGridView with date range using datepicker on submit button. Here I use Yii Cookie to preserve date in datepicker textbox after submitting the form.

Access log output from unit tests

Created about a year ago by MikeTips2 comments – viewed 4,693 times – ( +4 ) – version 1.1
Say, you want to write a test for a component which provides a caching feature. How would you know, that some method of your component returns a cached result? With the solution described here you can inspect all log outputs. So you could search the logs for accesses to the DB to really make sure, that the result was served from cache.

Importing CSV file to mysql table using "LOAD DATA" command.

Created about a year ago by sirin kTips12 comments – viewed 24,795 times – ( +5 ) – version 1.1
hi, Here i am giving you some simple step to import huge data from a csv file to your mysql table.this is useful when you have a very huge data to import from csv format.
tags: csv, mysql, import

How to catch and log MySQL deadlock errors

Created 2 years ago by sebTips0 comments – viewed 7,581 times – ( +4 ) – version 1.1
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.
tags: database

using multiple radio button

Created 2 years ago by francis jaTips3 comments – viewed 23,753 times – ( +5 ) – version 1.1
When we use multiple radio buttons with same name in Yii many people have the problem on getting the value of the selected radiobutton. The radioButtonList can be used for that, but if we need to use radioButton itself to place the button any where in a view, we need to include one more parameter in htmloption array().

Troubleshooting Rights Extension

Created 2 years ago by junxiongTips5 comments – viewed 15,903 times – ( +8 ) – version 1.1
Rights is one of user interface for Yii's Role Base Access Control extension. It is one of most downloaded extensions in Yii's Web.