Author Archives: navaneeth

Get country name from country code in magento

Posted by on May 22, 2015 in Magento |
Reply

When dealing with magento customization sometimes we need to get country name from country code. Its pretty easy to do so with a single line of code

Magento has a model to manage the countries which is directory/country

So first we need to load the model with the desired country code as shown below

<?php
echo Mage::getModel("directory/country")->load('in')->getName();
?>

Hope this helps to get country name from country code in magento

Calculate age in years months and days in mysql

Posted by on Mar 17, 2015 in General |
2

When we are dealing with dates in mysql sometimes we need to calculate the age in years months and days directly from the mysql query

We can easily achieve it from the below sql query


SELECT name,dob,
CONCAT(TIMESTAMPDIFF( YEAR, dob, now() ),' Years,',
TIMESTAMPDIFF( MONTH, dob, now() ) % 12,' Months,',
FLOOR( TIMESTAMPDIFF( DAY, dob, now() ) % 30.4375 ),' Days')
as AGE from users

And the output of the query will shown like this


+-----------------+------------+-----------------------------+
| name            | dob        |  Age                        |     
+-----------------+------------+-----------------------------+
| Arun            | 1989-09-07 | 25 Years, 6 Months, 8 Days  |
| Disilva         | 1960-12-04 | 54 Years, 3 Months, 11 Days |
| Pam             | 1990-07-03 | 24 Years, 8 Months, 13 Days |
+-----------------+------------+-----------------------------+

OpenID 2.0 for Google Accounts is going to Shutdown

Posted by on Mar 12, 2015 in General |
Reply

Google OpenID 2.0 for Google Accounts is going to Shutdown and they are migrating Open ID 2.0 to the Google Plus Sign-In. Open ID 2.0 and Google Plus Sign-In is a way that allows website owners to let their users log into their website using their Google account credentials.

Shutting down Open ID 2.0 and migrating to Google Plus Sign-In is further proof that Google Plus is really here to stay.

According to Google, there is no Developer Registration for Open ID 2.0, so there is no way for Google to contact web developers using Open ID 2.0. However, I believe that there would most likely be a way for Google to identify the sites using Open ID 2.0. For example, they could actually identify the sites using it–and then contact the site owners using Google Webmaster Tools.

Here is the schedule for the migration to Google Plus Sign-In:

January 12, 2015: Auto-approval is progressivly disabled for more and more users, these users will be forced to re-consent. Developers passing openid_shutdown_ack are unaffected.

February 23, 2015: Auto-approval is turned off, users must consent on each request. Developers passing openid_shutdown_ack are unaffected.

March 23, 2015: Grace period for developers using the openid_shutdown_ack parameter ends, warning is shown and auto-approval turned off for all applications.

April 20, 2015: OpenID is shut down. A static error page will be displayed on all requests. Make sure you have migrated well before this date.

Import CSV File Into MySQL using LOAD DATA INFILE

Posted by on Feb 27, 2015 in General, MySQL, Php |
2

In this post we are discussing on how to use LOAD DATA INFILE statement to import CSV file into MySQL table.

The following statement imports data from c:\tmp\data.csv file into the discounts table.

LOAD DATA INFILE 'c:/tmp/data.csv' 
INTO TABLE discounts 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

The field of the file is terminated by a comma indicated by FIELD TERMINATED BY ‘,’ and enclosed by double quotation marks specified by ENCLOSED BY ‘”‘.

Each line of the CSV file is terminated by a new line character indicated by LINES TERMINATED BY ‘\n’.

Because the file has the first line that contains the column headings, which should not be imported into the table, therefore we ignore it by specifying IGNORE 1 ROWS option.

Transforming data while importing

Sometimes the format of the data does not match with the target columns in the table. In simple cases, you can transform it by using the SET clause in the LOAD DATA INFILE statement.

Suppose the date column in the data.csv file is in mm/dd/yyyy format.

When importing data into the discounts table, we have to transform it into MySQL date format by using str_to_date() function as follows:

LOAD DATA INFILE 'c:/tmp/data.csv'
INTO TABLE discounts
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
(title,@date,amount)
SET date= STR_TO_DATE(@date, '%m/%d/%Y');

Hope this will help to import data from csv to mysql database