Wiki

Articles in category "tips", sorted by date (updated)X
Displaying 1-10 of 150 result(s).

Multi Data Provider

Updated about a month ago by Sharon LavieTips0 comments – viewed 7,297 times – ( +1 ) – version 1.1
Lately, i needed to deal with the following scenario: read from two databases (db1,db2), and write to a third database (db3).

Yii2: Query build for complexity SQL

Updated 3 months ago by Scott_HuangTips0 comments – viewed 4,393 times – version 2.0
As for complexity SQL query we have two solutions as below, I will discuss #2 in this article.

View a related field in CGridView

Updated 7 months ago by rafaelt88Tips1 comment – viewed 8,093 times – ( +6 ) – version 1.1
Generally we need to show one or more fields from a model that is related to another model used in CGridView. For our case we will use two related models, which explain how to use model "A" fields in a CGridView that used model "B".

Load & Save With Relation

Updated 7 months ago by moo.tensaiTips0 comments – viewed 5,535 times – ( +1 ) – version 2.0
Use this extension : yii2-relation-trait

Building a search GET request with scenarios ; calling a SearchModel from URLs...

Updated 9 months ago by Louis GacTips0 comments – viewed 4,603 times – ( +1 ) – version 2.0
Search Models are a very elegant and powerful way to build an Active Data Provider. If you use them a lot, you'll quickly need to use scenarios, which will lead you to a very DRY Controller code.
tags: search, get, Scenarios

Customize your Growl/Alert msg easy and quickly

Updated 9 months ago by Scott_HuangTips0 comments – viewed 3,345 times – ( +2 / -1 ) – version 2.0
I leverage Kartik's notification widgets.

Things to Consider when application hosting on AppFog

Updated 11 months ago by VINAY Kr. SHARMATips0 comments – viewed 2,187 times – ( +1 ) – version 1.1
I faced many issues when hosted our company website on AppFog.

Solution for session lose of Facebook iframe application in Internet Explorer .

Updated 11 months ago by sirin kTips0 comments – viewed 7,254 times – ( +2 ) – version 1.1
Facebook iframe app’s session is losing in Internet Explorer when doing a second redirection inside the facebook iframe app.The main reason is ,by default IE wont allow cookies in its priavacy settings If cookies not available means session is also not available for our Facebook iframe app in IE.

mysql performance tip

Updated 11 months ago by sirin kTips2 comments – viewed 8,812 times – ( +2 / -1 ) – version 1.1
When we are doing an insert of huge no.of rows into an SQL table ,Normally we will try to write separate insert quries this may lead us to a long duration of execution time and we can increase the speed of executing SQL quries by adding all the rows into a single insert query.
tags: mysql

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

Updated 11 months ago by sirin kTips6 comments – viewed 42,178 times – ( +7 ) – 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