Solved errror while upgrade magento 1.9.3.1 to 1.9.3.3 CE

Hello

Recently I faced problems while upgrade magento 1.9.3.1 to 1.9.3.3 community Edition.

I saw that missing formkey in every page. So it create problems. You have to simply put this one line code . Add in all of your custom checkout templates in forms next line

<?php echo $this->getBlockHtml('formkey') ?>

You have to check these pages :

Shipping cart form:

app/design/frontend/<package>/<theme>/template/checkout/cart/shipping.phtml

Multishipping billing checkout form:

app/design/frontend/<package>/<theme>/template/checkout/multishipping/billing.phtml

Multishipping shipping checkout form:

app/design/frontend/<package>/<theme>/template/checkout/multishipping/shipping.phtml

Billing checkout form:

app/design/frontend/<package>/<theme>/template/checkout/onepage/billing.phtml

Shipping checkout form:

app/design/frontend/<package>/<theme>/template/checkout/onepage/shipping.phtml

Payment checkout form:

app/design/frontend/<package>/<theme>/template/checkout/onepage/payment.phtml

Shipping method checkout form:

app/design/frontend/<package>/<theme>/template/checkout/onepage/shipping_method.phtml

Persistent Billing checkout form:

app/design/frontend/<package>/<theme>/template/persistent/checkout/onepage/billing.phtml

Also do this for "base" folder.

On top of that the following JS files have been updated to be compatible with that change:

• js/varien/payment.js
• skin/frontend/base/default/js/opcheckout.js

You have to do:

If you're using with custom versions of those templates you'll have to update them by adding the following code into them:

<?php echo $this->getBlockHtml('formkey') ?>

If you're using a 3rd party checkout module, you'll have to get in touch with them so they can provide an updated version of their module.

Also if you have custom versions of the previously listed JS files, you'll have to update them too.

IMPORTANT NOTE : the checkout formkey validation can be changed in the backend via a new config field under System > Configuration > Admin > Security > Enable Form Key Validation On Checkout . THIS IS NOT ENABLED BY DEFAULT so you'll have to enable it to benefit from this security feature!!! Note that you'll get a notice in the backend if it's not enabled.

 

Download database with php script

Hello
Now I describe you how to download large database sql file in zip with php script.
This will help you in magento or large database.

Code :

<?php

$DBUSER="root";
$DBPASSWD="password";
$DATABASE="magento_dbtest";

$filename = "backup-" . date("d-m-Y") . ".sql.gz";
$mime = "application/x-gzip";

header( "Content-Type: " . $mime );
header( 'Content-Disposition: attachment; filename="' . $filename . '"' );

$cmd = "mysqldump -u $DBUSER --password=$DBPASSWD $DATABASE | gzip --best";  
passthru( $cmd );

echo 'done';
exit(0);
?>

This will save .zip file.

Transfer Files Server to Server Using Simple PHP

Hello.

Here i explained to move/migrate files to another server/hosting, and you/your client only have FTP access to the server. And to download these files and re-upload to another server can take a lot of time using FTP client such as Filezilla. FTP do not have zip – unzip functionality, so you need to upload it one by one. And server to server transfer is a lot faster than downloading and uploading the files. You can use this simple PHP script to move files from one server to another server.

Note: It’s just a simple examples. you need to build your own auth/security method if needed.

1. Using PHP Copy to move files from server to server.

You can just create a php file in the destination server and load the file once in your browser. For example you add this code in http://destination-url/copy-files.php and in copy-files.php you add this php code:

/**

 * Transfer Files Server to Server using PHP Copy

 *

 */

 

/* Source File URL */

$remote_file_url = 'http://origin-server-url/files.zip';

 

/* New file name and path for this file */

$local_file = 'files.zip';

 

/* Copy the file from source url to server */

$copy = copy( $remote_file_url, $local_file );

 

/* Add notice for success/failure */

if( !$copy ) {

    echo "Oh! failed to copy $file...\n";

}

else{

    echo "Done! success to copy $file...\n";

}

2. Using PHP FTP to move files from server to server

/**

 * Transfer (Import) Files Server to Server using PHP FTP

 */

/* Source File Name and Path */

$remote_file = 'files.zip';

 

/* FTP Account */

$ftp_host = 'your-ftp-host.com'; /* host */

$ftp_user_name = 'ftp-username@your-ftp-host.com'; /* username */

$ftp_user_pass = 'ftppassword'; /* password */
/* New file name and path for this file */

$local_file = 'files.zip';

/* Connect using basic FTP */

$connect_it = ftp_connect( $ftp_host );

/* Login to FTP */

$login_result = ftp_login( $connect_it, $ftp_user_name, $ftp_user_pass ); 
 
/* Download $remote_file and save to $local_file */

if ( ftp_get( $connect_it, $local_file, $remote_file, FTP_BINARY ) ) {

    echo "Done! Successfully written to $local_file\n";

}

else {

    echo "Oh! There was a problem\n";

}

/* Close the connection */

ftp_close( $connect_it );

 using FTP you have more flexibility, the code above is using ftp_get to import the files from source server to destination server. But we can also use ftp_put to export the files (send the files) from source server to destination, using this code:

/**

 * Transfer (Export) Files Server to Server using PHP FTP

 */

/* Remote File Name and Path */

$remote_file = 'files.zip';

/* FTP Account (Remote Server) */

$ftp_host = 'your-ftp-host.com'; /* host */

$ftp_user_name = 'ftp-username@your-ftp-host.com'; /* username */

$ftp_user_pass = 'ftppassword'; /* password */

/* File and path to send to remote FTP server */

$local_file = 'files.zip';


/* Connect using basic FTP */

$connect_it = ftp_connect( $ftp_host );

/* Login to FTP */

$login_result = ftp_login( $connect_it, $ftp_user_name, $ftp_user_pass );

/* Send $local_file to FTP */

if ( ftp_put( $connect_it, $remote_file, $local_file, FTP_BINARY ) ) {

    echo "WOOT! Successfully transfer $local_file\n";

}

else {

    echo "Doh! There was a problem\n";

}

/* Close the connection */

ftp_close( $connect_it );

To make it easier to understand:

• ftp_connect is to connect via FTP.
• ftp_login is to login to FTP account after connection established.
• ftp_close is to close the connection after transfer done (log out).
• ftp_get is to import/download/pull file via FTP.
• ftp_put is to export/send/push file via FTP.

After you import/export the file, always delete the PHP file you use to do this task to prevent other people using it.

ZIP and UNZIP Files using PHP

Of course to make the transfer easier we need to zip the files before moving, and unzip it after we move to destination.

ZIP Files using PHP

You can zip all files in the folder using this code:

/**

 * ZIP All content of current folder

 */

/* ZIP File name and path */

$zip_file = 'files.zip';

/* Exclude Files */

$exclude_files = array();

$exclude_files[] = realpath( $zip_file );

$exclude_files[] = realpath( 'zip.php' );
/* Path of current folder, need empty or null param for current folder */

$root_path = realpath( '' );

/* Initialize archive object */

$zip = new ZipArchive;

$zip_open = $zip->open( $zip_file, ZipArchive::CREATE );

 

/* Create recursive files list */

$files = new RecursiveIteratorIterator(

    new RecursiveDirectoryIterator( $root_path ),

    RecursiveIteratorIterator::LEAVES_ONLY

);



/* For each files, get each path and add it in zip */

if( !empty( $files ) ){

 

    foreach( $files as $name => $file ) {

 

        /* get path of the file */

        $file_path = $file->getRealPath();

 

        /* only if it's a file and not directory, and not excluded. */

        if( !is_dir( $file_path ) && !in_array( $file_path, $exclude_files ) ){

 

            /* get relative path */

            $file_relative_path = str_replace( $root_path, '', $file_path );

 

            /* Add file to zip archive */

            $zip_addfile = $zip->addFile( $file_path, $file_relative_path );

        }

    }

}

 

/* Create ZIP after closing the object. */

$zip_close = $zip->close();

UNZIP Files using PHP

You can unzip file to the same folder using this code:

/**

 * Unzip File in the same directory.

 * @link http://stackoverflow.com/questions/8889025/unzip-a-file-with-php

 */
$file = 'file.zip';

 

$path = pathinfo( realpath( $file ), PATHINFO_DIRNAME );

 

$zip = new ZipArchive;

$res = $zip->open($file);

if ($res === TRUE) {

    $zip->extractTo( $path );

    $zip->close();

    echo "Done! $file extracted to $path";

}

else {

    echo "Oh! I couldn't open $file";

}