Author Archives: navaneeth

PHP array of all US States

Posted by on Mar 7, 2014 in Php, Snippets |
Reply

$usStates = array(
‘AL’ => ‘Alabama’,
‘AK’ => ‘Alaska’,
‘AZ’ => ‘Arizona’,
‘AR’ => ‘Arkansas’,
‘CA’ => ‘California’,
‘CO’ => ‘Colorado’,
‘CT’ => ‘Connecticut’,
‘DE’ => ‘Delaware’,
‘FL’ => ‘Florida’,
‘GA’ => ‘Georgia’,
‘HI’ => ‘Hawaii’,
‘ID’ => ‘Idaho’,
‘IL’ => ‘Illinois’,
‘IN’ => ‘Indiana’,
‘IA’ => ‘Iowa’,
‘KS’ => ‘Kansas’,
‘KY’ => ‘Kentucky’,
‘LA’ => ‘Louisiana’,
‘ME’ => ‘Maine’,
‘MD’ => ‘Maryland’,
‘MA’ => ‘Massachusetts’,
‘MI’ => ‘Michigan’,
‘MN’ => ‘Minnesota’,
‘MS’ => ‘Mississippi’,
‘MO’ => ‘Missouri’,
‘MT’ => ‘Montana’,
‘NE’ => ‘Nebraska’,
‘NV’ => ‘Nevada’,
‘NH’ => ‘New Hampshire’,
‘NJ’ => ‘New Jersey’,
‘NM’ => ‘New Mexico’,
‘NY’ => ‘New York’,
‘NC’ => ‘North Carolina’,
‘ND’ => ‘North Dakota’,
‘OH’ => ‘Ohio’,
‘OK’ => ‘Oklahoma’,
‘OR’ => ‘Oregon’,
‘PA’ => ‘Pennsylvania’,
‘RI’ => ‘Rhode Island’,
‘SC’ => ‘South Carolina’,
‘SD’ => ‘South Dakota’,
‘TN’ => ‘Tennessee’,
‘TX’ => ‘Texas’,
‘UT’ => ‘Utah’,
‘VT’ => ‘Vermont’,
‘VA’ => ‘Virginia’,
‘WA’ => ‘Washington’,
‘WV’ => ‘West Virginia’,
‘WI’ => ‘Wisconsin’,
‘WY’ => ‘Wyoming’,
);

Show posts from a category magento AW BLog

Posted by on Mar 4, 2014 in Magento |
3

When using the AheadWorks Blog Magento Extensions sometimes necessary show blog category from block or cms page. Need to make small changes before use code

{{block type="blog/cat" categories="1" template="aw_blog/cat.phtml"}}

Go to app/code/community/AW/Blog/Block/Cat.php and change

public function getCategory()
{
	$cats = Mage::getSingleton('blog/cat');
	return $cats;
}

to

public function getCategory()
  {
  $cats = Mage::getSingleton('blog/cat');
 $cats = Mage::getSingleton('blog/cat');
	  $_id = ($this->getData('categories')) ? $this->getData('categories') : false;
	  if (!empty($_id)) {
		$cats->load($_id);
	  }
	  return $cats;
}

Export MySQL data to csv using php

Posted by on Feb 21, 2014 in General |
Reply

A lot of clients requires to export the data from database to csv. So i decided to add an post related to this
on export mysql data to csv using php

Below is the code on how we can do this make sure you dont have any out put before the code below,If so it produces an header already sent error


/* Database connection information */
$gaSql['user']       = $config['username'];
$gaSql['password']   = $config['password'];
$gaSql['db']         = $config['dbname'];
$gaSql['server']     = $config['host'];

/*
 * MySQL connection
 */
$gaSql['link'] =  mysql_pconnect( $gaSql['server'], $gaSql['user'], $gaSql['password']  ) or
die( 'Could not open connection to server' );

mysql_select_db( $gaSql['db'], $gaSql['link'] ) or
die( 'Could not select database '. $gaSql['db'] );
/*
 * Remove upto this if you already have database connection
 */
$select = "SELECT * FROM table ";

$export = mysql_query ( $select ) or die ( "Sql error : " . mysql_error( ) );

$fields = mysql_num_fields ( $export );

for ( $i = 0; $i < $fields; $i++ )
{
    $header .= mysql_field_name( $export , $i ) . ",";
}

while( $row = mysql_fetch_row( $export ) )
{
    $line = '';
    foreach( $row as $value )
    {
        if ( ( !isset( $value ) ) || ( $value == "" ) )
        {
            $value = ",";
        }
        else
        {
            $value = str_replace( '"' , '""' , $value );
            $value = '"' . $value . '"' . ",";
        }
        $line .= $value;
    }
    $data .= trim( $line ) . "\n";
}
$data = str_replace( "\r" , "" , $data );

if ( $data == "" )
{
    $data = "\n(0) Records Found!\n";
}

header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=file_name.csv");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";