hello friends. in this post i found to generate GCM KEY for push notification

step 1:  login to https://console.developers.google.com/ with you gmail id..

if you not created yet any project then click on  CREATE PROJECT button..

Step 2:  you see this screen..

Convert field datatype or get time according to time zone..

Hi,  friends..

in this post i found a code which is listed below.

i facing some problem in PHP/SQL to store special charecter or other languages in database. When we save data in varchar datatype field then it show ?????. so after googling i found this code. i change field data type VarChar to varbinary so that data is store into binary form. and when i retrive data then i change datatype of data to varbinary to varchar by using this code...

i using CONVERT function

CONVERT(`name`, CHAR(255)) as `name` -> name is field name.. 

SELECT `groupId`, CONVERT(`name`, CHAR(255)) as `name`, `image`, `type`, `status`, CONVERT_TZ(`addedDate`,'-6:00','".$zone."') as `addedDate` FROM `msg_user_group` WHERE `groupId` = 1;