Pk Magento 2: August 2014

<?php
/* vars for export */
// database record to be exported
$db_record = 'XXXXXXXXX';
// optional where query
$where = 'WHERE 1 ORDER BY 1';
// filename for export
$csv_filename = 'db_export_'.$db_record.'_'.date('Y-m-d').'.csv';
 
// database variables
$hostname = "localhost";
$user = "XXXXXXXXX";
$password = "XXXXXXXXX";
$database = "XXXXXXXXX";
 
// Database connecten voor alle services
mysql_connect($hostname, $user, $password)
or die('Could not connect: ' . mysql_error());
mysql_select_db($database)
or die ('Could not select database ' . mysql_error());
 
// create empty variable to be filled with export data
$csv_export = '';
 
// query to get data from database
$query = mysql_query("SELECT * FROM ".$db_record." ".$where);
$field = mysql_num_fields($query);
 
// create line with field names
for($i = 0; $i < $field; $i++) {
$csv_export.= mysql_field_name($query,$i).';';
}
// newline (seems to work both on Linux & Windows servers)
$csv_export.= '
';
 
// loop through database query and fill export variable
while($row = mysql_fetch_array($query)) {
// create line with field values
for($i = 0; $i < $field; $i++) {
$csv_export.= '"'.$row[mysql_field_name($query,$i)].'";';
} 
$csv_export.= '
'; 
}
 
// Export the data and prompt a csv file for download
header("Content-type: text/x-csv");
header("Content-Disposition: attachment; filename=".$csv_filename."");
echo($csv_export);
?>

Magento tranjectional mail with variable by template id

<?php
// Transactional Email Template's ID
        $templateId = 5;

// Set sender information
        $senderName = 'Kraftbuy';
        $senderEmail = $email_general;
        $sender = array('name' => "admin",
                    'email' => "admin@gmail.com");

// Set recepient information
        $recepientEmail = $email;
        $recepientName = $Name_of_Contact_Person_for;

// Get Store ID
        $store = Mage::app()->getStore()->getId();

//Set variables that can be used in email template you can assign this variable in tranjectional mail {{var ustomerName}}

$vars = array('customerName' => 'puneet kumar',
                  'customerEmail' => 'puneetk00@gmail.com');

$translate  = Mage::getSingleton('core/translate');

// Send Transactional Email
        Mage::getModel('core/email_template')
      ->addBcc($senderEmail)
            ->sendTransactional($templateId, $sender, $recepientEmail, $recepientName, $vars, $storeId);

$translate->setTranslateInline(true);

Pk Magento 2

Export MySQL to CSV (php script)

Magento tranjectional mail with variable by template id

Magento 2.4.8 released with new features.

Popular Posts

Posts