Wiki

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

Using Nginx and Apache2 in separate distributed servers (ie, Amazon EC2 instances)

Updated 3 days ago by Luis Lobo BorobiaTips0 comments – viewed 6,365 times – ( +2 / -1 ) – version all
We are running one frontend running NGINX and several app servers running Apache2. There are several issues we have come across but right now I'll be documenting one of them. I'll be completing this article when I get more time.

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

Updated about a month ago by sirin kTips0 comments – viewed 8,350 times – ( +2 / -1 ) – 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 about a month ago by sirin kTips2 comments – viewed 10,136 times – ( +2 / -2 ) – 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 about a month ago by sirin kTips6 comments – viewed 48,593 times – ( +7 / -1 ) – 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

Get notified about the status of a Facebook user in your web app using periodic Ajax calls.

Updated about a month ago by sirin kTips0 comments – viewed 7,494 times – ( +4 / -1 ) – version 1.1
hello, This article is helpful only if you have the following situation: A web app which uses facebook login to login its users and if a user is logged out from his/her facebook account through another browser tab, then your app dont know that he is logged out out or not from his facebook account and he/she will remain as logged in your web application.Its ok if you have no problem with this situation.But if you want to forcefully logout the user from your application if he is logged out from his facebook account means you can try this example.This example uses periodic ajax calls to facebook's graph api to check whether the user is logged in or not.
tags: facebook, user

An important tip when you are using CArrayDataProvider.

Updated about a month ago by sirin kTips0 comments – viewed 12,360 times – ( +8 / -2 ) – version 1.1
Yii ‘s CArrayDataProvider is very helpful to display model relation data's directly on it.But it is truely a confusing one because by default it will assume a table field named “id” as primary key for its pagination purpose and what if you dont have field named “id” as primary key on your table? so its truely confusing and if you tried to display without an “id” field on ur table you will get an error like “yourmodel.id is not defined”.

REST API and null values in XML

Updated 6 months ago by marko60Tips0 comments – viewed 6,533 times – ( -1 ) – version 2.0
I have been working on a REST API using the excellent tools provided by Yii2. My problem was that I have to differentiate between empty values and null values. In other words, <elem></elem> is different from null as it represents an empty string. Also, although some use <elem/> to represent a null value it should still be interpreted as an empty string. In other cases, the absence of the element is taken to represent a null value, but this may create problem with some parsers.
tags: REST, XML, null

A universal model attribute for its synthetic representation

Updated 9 months ago by Alexandre RodichevskiTips2 comments – viewed 3,811 times – ( -1 ) – version 2.0
It is convenient to use the same identification attribute, say info, in all of the active records of your application. It should be a virtual read-only attribute defined by a getter method, its label being the model name.

Boost composer-asset-plugin update speed

Updated 10 months ago by samdarkTips5 comments – viewed 8,175 times – ( +5 / -1 ) – version 2.0
If you're using a lot of bower and npm assets with Yii 2.0 you might encounter long running composer update tasks.

How to change GridView delete confirmation message for specific controllers only?

Updated about a year ago by AlaFalakiTips1 comment – viewed 12,410 times – ( +2 / -1 ) – version 2.0
Hello, If you want to give extra attention for some specific delete actions and you don't want to override whole yii.confirm JS method here is what you can do: (I've only put the ActionColumn part of the GridView here to just give you the idea)