Wiki

Articles in category "tips", sorted by date (updated)X
Displaying 11-20 of 152 result(s).

mysql performance tip

Updated about a year ago by sirin kTips2 comments – viewed 9,282 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 about a year ago by sirin kTips6 comments – viewed 45,098 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

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

Updated about a year ago by sirin kTips0 comments – viewed 6,886 times – ( +4 ) – 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 year ago by sirin kTips0 comments – viewed 10,992 times – ( +8 / -1 ) – 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”.

Using PayPal IPN with Yii2

Updated about a year ago by dariooTips0 comments – viewed 4,618 times – version 2.0
I'm using PayPal's script from

Debuging variables in Yii2

Updated about a year ago by johonunuTips3 comments – viewed 8,847 times – ( +2 / -1 ) – version 2.0
This tutorial is explained following "basic" application structure.

Selecting best language based on Browser language and available languages.

Updated about a year ago by le_topTips0 comments – viewed 4,374 times – ( +2 ) – version 1.1
Your application is international and you have to select the best language for the user. Your user may have selected 'fr_CA' and you have 'fr_FR' or 'fr' available. What do you do? Here is a tip.

New Relic Error Alert with Yii

Updated about a year ago by razvanphpTips2 comments – viewed 13,897 times – ( +6 ) – version 1.1
Introduction

YII2 Pagination Options

Updated about a year ago by VivekYiiTips0 comments – viewed 5,268 times – ( +1 ) – version 2.0
solution here If we are using default pagination option like
tags: pagination, View, vivs

Using counters with ActiveRecord

Updated about a year ago by marcovtwoutTips9 comments – viewed 27,224 times – ( +14 / -1 ) – version 1.1
Let's say, for example, that you are developing a blog or some kind of CMS and you want to track the number of times each post was viewed (maybe to show a list of the most viewed ones).